Wednesday, March 21, 2012

Postgres to SQL Express

Is there a utility that will allow migrating Postgres dtatbases to SQL Expre
ss?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/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:
>|||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 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:
[vbcol=seagreen]
> Is there a utility that will allow migrating Postgres dtatbases to SQL Express?[/v
bcol]

No comments:

Post a Comment