Drop Table
Support Forum for database administrators and web based access to important newsgroups related to databasesIs there a utility that will allow migrating Postgres dtatbases to SQL Expre ss?
Post Follow-up to this messageThank you for your assistance John. "John Bell" wrote: > Hi Patrick > > Postgres is not one of the databases that has a migration assistant > http://www.microsoft.com/sql/soluti...on/default.mspx so you will > have to do this manually. The Import/Export wizard may allow you to transf er > tables/data across but you may still have to manipulate the data afterward s > and change some datatypes, therefore scripting the DDL and > exporting/importing the data via flat files may be the best option. > > HTH > > John > "Patrick" wrote: >
Post Follow-up to this messageHi Patrick Postgres is not one of the databases that has a migration assistant http://www.microsoft.com/sql/soluti...on/default.mspx so you will have to do this manually. The Import/Export wizard may allow you to transfer tables/data across but you may still have to manipulate the data afterwards and change some datatypes, therefore scripting the DDL and exporting/importing the data via flat files may be the best option. HTH John "Patrick" wrote: > Is there a utility that will allow migrating Postgres dtatbases to SQL Express?[/c olor]
Post Follow-up to this message
Show a Printable Version
Email This Page to Someone!
Receive updates to this thread