| Author |
Postgres to SQL Express
|
|
| Patrick 2006-11-28, 7:13 pm |
| Is there a utility that will allow migrating Postgres dtatbases to SQL Express?
| |
| Patrick 2006-11-30, 7:14 pm |
| Thank you for your assistance John.
"John Bell" wrote:
[color=darkred]
> 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:
>
| |
| John Bell 2006-11-30, 7:14 pm |
| 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:
> Is there a utility that will allow migrating Postgres dtatbases to SQL Express?
|
|
|
|