470,810 Members | 1,265 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 470,810 developers. It's quick & easy.

porting a full 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
Nov 23 '05 #1
1 1610
On 24 Sep 2004 at 17:23, pw*****@hotmail.com wrote:
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?


You can probably to a semi-automated process. I have sucessfully
transfereed the bulk of the data from SQlServer to PostgreSQL using
the SQLServers Data Transformation Services (DTC) and the
PostgreSQL ODBC driver. As long as you defined the tables and
columns the same in both databases you should be OK.

If you need to create the schema first, you can "script" the SQLServer
database and hack the output file.

Put indexes and foreign keys on the PostgreSQL database *after* you
transfer the data.

You would need to redefine the triggers and stored procedures
manually.

For our own specific databases I have written a small program (in C#)
to dump the contents of SQLServer tables into a PostgreSQL COPY
command format. This speeds up the actual data transfer by an order of
magnitude or so!

Cheers,
Gary.

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to ma*******@postgresql.org)

Nov 23 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

11 posts views Thread by Errol Neal | last post: by
9 posts views Thread by Sean Shanny | last post: by
2 posts views Thread by Robert Treat | last post: by
1 post views Thread by Janez Kostanjček | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.