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
> 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.
> or i should try other solutions??
> ---------------------------(end of
> 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
pgsql-general by date
|Next:||From: Jelle Ouwerkerk||Date: 2001-04-27 14:28:19|
|Subject: rotating log files|
|Previous:||From: Peter T Mount||Date: 2001-04-27 13:45:06|
|Subject: Re: JDBC and Accents|