how to migrate from SQL Server7 to PostgreSQL7??

From: "Anzo" <anzo(at)kimo(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: how to migrate from SQL Server7 to PostgreSQL7??
Date: 2001-04-27 11:46:06
Message-ID: 9cbm1o$8mn$1@news.tht.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

hi there:
i have a plan to migrate my company's database from ms sql server 7 to
postgresql 7.
i had try to use ms sql server's dts to export to postgresql.
i download the odbc driver from postgresql.org and configure to my nt4
server.
ftp://postgresql.readysetnet.com/pub/postgresql/odbc/versions/psqlodbc-07_01
_0004.zip
i started to use dts in my sql server, when i choose the destination
datasource and press "next" , then the error message occurred
"Unexpected error occurred. The provider has returned an error result
without an error message"
can anybody give some helps ??
or i should try other solutions??
thanx!!

anzo

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tony Grant 2001-04-27 12:00:19 Re: JDBC and Accents
Previous Message Rod Taylor 2001-04-27 11:40:50 Re: last comma inside "CREATE TABLE ()" statements