Re: Porting from MS SQL Server to PostGres - Mailing list pgsql-admin

From Goulet, Dick
Subject Re: Porting from MS SQL Server to PostGres
Date
Msg-id 4001DEAF7DF9BD498B58B45051FBEA650146C760@25exch1.vicorpower.vicr.com
Whole thread Raw
In response to Porting from MS SQL Server to PostGres  (pwbyrne@hotmail.com)
Responses Re: Porting from MS SQL Server to PostGres  (Rosser Schwarz <rosser.schwarz@gmail.com>)
List pgsql-admin
Given the "fun" I've had with Sql*Server and it's sister Access, you'd be much better off porting things manually.  I'd
precreateall of the tables/indexes and then move the data with the aid of Access or a similar ODBC tool.  As for the
rest,re-write it as Tsql is more like VB than pgplsql. 

Dick Goulet
Senior Oracle DBA
Oracle Certified 8i DBA

-----Original Message-----
From: pwbyrne@hotmail.com [mailto:pwbyrne@hotmail.com]
Sent: Thursday, September 23, 2004 3:47 PM
To: pgsql-admin@postgresql.org
Subject: [ADMIN] Porting from MS SQL Server to PostGres


Hi,

I'm looking for details, or tools about porting a full Ms Sql Server
2000 database to Postgres on Linux.

Is this possible?  We have the whole nine yards, stored procedures,
triggers, and all.

Is there a way to automate this process?

Thanks

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

pgsql-admin by date:

Previous
From: Manolatos Tilemahos
Date:
Subject: How to pass initdb LC_COLLATE & locale parameters when using wind ows? (with or without pginstaller)
Next
From: Curt Sampson
Date:
Subject: Re: memory strangeness (fwd)