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

thanx Peter!!
but i have many tables and datas in SQL7, so  i hope some tools can help me
to do that.
DTS is the first tool i think about, but i still can't find what's wrong
with my odbc setting.
so...what should i do?? do it manually?
or do you have other suggestion?
thanx!!

anzo


"Peter T Mount" <peter@retep.org.uk> wrote in message
news:988380975.3ae97f2f5e2c9@webmail.retep.org.uk...
> Quoting Anzo <anzo@kimo.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@retep.org.uk
> PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/
> RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/
>
> ---------------------------(end of broadcast)---------------------------
> TIP 2: you can get off all lists at once with the unregister command
>     (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)