Thread: MSSQL --> PostgreSQL

MSSQL --> PostgreSQL

From

Antonio Reale

Date:

25 March 2003, 16:13:12

Hi,
I'm a newbie with databases. I want to migrate a database from SQL Server 2000
to PostgreSQL (version 7.2.2). I read this tutorial:
http://techdocs.postgresql.org/techdocs/convertsqlsvr2pgsql.php

but when I create a new table on the destination tab and click OK (section 11
of tutorial) I receive this error:
"hresult 0x80004005 (-2147467259) returned."

I also tried with pgAdmin II but I received the error:
"380: invalid property value
Rolling back... Done."
I use Mandrake 9.0 and SQL server 2000 on win2000 Pro (+ ODBC drivers for
PostgreSQL).

--
Ciao,

Antonio.