RE: MSSQL7 & PostgreSQL 7.0

> -----Original Message-----
> From: Bruce Momjian [mailto:pgman(at)candle(dot)pha(dot)pa(dot)us]
> Sent: 17 May 2000 16:45
> To: Peter Mount
> Cc: PostgreSQL Developers List (E-mail)
> Subject: Re: [HACKERS] MSSQL7 & PostgreSQL 7.0
>
>
> Yes, major issue.
>
> > Just been playing with SQL Server 7's DTS (Data Transform
> Service) and
> > thought, "Could SQL load data into Postgres?".
> >
> > The main idea (ok excuse as I didn't fancy doing much work this
> > afternoon), was publishing data on our Intranet (which uses
> Postgres).
> >
> > Anyhow, loaded the ODBC driver onto the SQL server, played
> and it only
> > works. I'll write up how to do it tonight (as there are a
> few gotcha's),
> > but it's one for the docs under "How do I migrate data from SQL7 to
> > PostgreSQL?".
> >

Feel free to tell me where to go if you think this is a shameless plug(!)
but pgAdmin also includes tools for migrating data from any ODBC datasource
(as well as ascii text files) to PostgreSQL. I'm open to suggestions if
anyone feels there are improvements worth making....

Regards,

Dave.

--
"If you stand still, sooner or later something will eat you."
- James Burke
http://www.vale-housing.co.uk/ (Work)
http://www.pgadmin.freeserve.co.uk/ (Home of pgAdmin)