Wednesday, March 21, 2012

Postgres to SQL Express

Is there a utility that will allow migrating Postgres dtatbases to SQL Express?
Thank you for your assistance John.
"John Bell" wrote:
[vbcol=seagreen]
> Hi Patrick
> Postgres is not one of the databases that has a migration assistant
> http://www.microsoft.com/sql/solutions/migration/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:
|||Hi Patrick
Postgres is not one of the databases that has a migration assistant
http://www.microsoft.com/sql/solutions/migration/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?
sql

No comments:

Post a Comment