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.



Wed, 17 May 2000 17:24:16 +0100
Peter Mount <petermount@it.maidstone.gov.uk>
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@candle.pha.pa.us               |  (610) 853-3000
  +  If your life is a hard drive,     |  830 Blythe Avenue
  +  Christ can be your backup.        |  Drexel Hill, Pennsylvania 19026

Wed, 17 May 2000 12:45:03 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: MSSQL7 & PostgreSQL 7.0