Re: 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?".
>
> Peter
>
> --
> Peter Mount
> Enterprise Support
> Maidstone Borough Council
> Any views stated are my own, and not those of Maidstone Borough Council.
>
>
>

--
Bruce Momjian | http://www.op.net/~candle
pgman(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026