convert Postgres script to SQL Server script?

Started by Matthew Hixsonabout 24 years ago2 messagesgeneral
Jump to latest
#1Matthew Hixson
hixson@poindextrose.org

Okay, I apologize in advance for asking this here, but I really have
looked around and haven't been able to find anything.
I'm looking for a script that can take a postgres sql script and convert
it into a MS SQL Server script. What I have is a script with 'create
table...' and 'create sequence...' commands and I would like to have some
script that can convert it to the equivalent commands to create the same
schema in SQL server. Maybe I'm going about this the wrong way? Is there
a better way to do this?
My development system is Postgres, but the application will need to be
deployed on SQL Server.
Any help would be greatly appreciated.
-M@

#2Jean-Michel POURE
jm.poure@freesurf.fr
In reply to: Matthew Hixson (#1)
Re: convert Postgres script to SQL Server script?

Le Jeudi 28 Février 2002 21:28, Matthew Hixson a écrit :

Maybe I'm going about this the wrong way?  Is there
a better way to do this?

Try this:

PostgreSQL tables -> MS Access using odbc,
Access tables -> MS SQL Server using MS migration wizard.

Good luck,
Jean-Michel