Porting from MS SQL Server to PostGres

[p***@hotmail.com]

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

[Goulet, Dick]

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 precreate all 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: ***@hotmail.com [mailto:***@hotmail.com]
Sent: Thursday, September 23, 2004 3:47 PM
To: pgsql-***@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 ***@postgresql.org

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to ***@postgresql.org so that your
message can get through to the mailing list cleanly

[Rosser Schwarz]

I'd precreate all of the tables/indexes and then move the data...

If you have a lot of data, it's probably better to punt on creating
the indices until after you've moved the data. Bulk populating
indexed tables, particularly if the table has more than just the
primary key index, can be awfully slow. At one point, we tried
dumping several million tuples into a table with a dozen-odd indices.
Only did that once.

/rls