Re: how to migrate from SQL Server7 to PostgreSQL7??

From: Peter T Mount <peter(at)retep(dot)org(dot)uk>
To: Anzo <anzo(at)kimo(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: how to migrate from SQL Server7 to PostgreSQL7??
Date: 2001-04-27 14:16:15
Message-ID: 988380975.3ae97f2f5e2c9@webmail.retep.org.uk
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Quoting Anzo <anzo(at)kimo(dot)com>:

> 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.

DTS works quite well actually ;-)

> 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 ??

Check the odbc drivers config. Check things like Read only is not set. When I
tried DTS (May last year) I had to play with the psqlodbc settings, but once
found DTS worked like a dream.

One thing I do remember: Don't rely on DTS to create the tables. Get it to show
you the sql, then do the creation manually - it doesn't get the syntax correct.

Peter

> or i should try other solutions??
> thanx!!
>
> anzo
>
>
>
>
>
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 4: Don't 'kill -9' the postmaster
>

--
Peter Mount peter(at)retep(dot)org(dot)uk
PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/
RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Jelle Ouwerkerk 2001-04-27 14:28:19 rotating log files
Previous Message Peter T Mount 2001-04-27 13:45:06 Re: JDBC and Accents