Re: SQL Server 2000 to PostgreSQL 8.0.3 - Mailing list pgsql-admin

From Ben Kim
Subject Re: SQL Server 2000 to PostgreSQL 8.0.3
Date
Msg-id Pine.GSO.4.10.10508090904410.18818-100000@coe.tamu.edu
Whole thread Raw
In response to Re: SQL Server 2000 to PostgreSQL 8.0.3  (James Herbers <james@herbers.ca>)
Responses Re: SQL Server 2000 to PostgreSQL 8.0.3  ("josh@segrestfarms.com" <josh@segrestfarms.com>)
List pgsql-admin
Here's my 2 cents.

If you have access to DTS in SQL Server 2000, it will be one convenient
solution for simple transfer.

It's a matter of creating a new task, defining the SQL Server database as
source and PostgreSQL database as destination, and clicking through. There
will be some mismatches in data types, but you can convert data using
scripts inisde the DTS task on the fly.


Regards,

Ben Kim
Developer
College of Education
Texas A&M University


pgsql-admin by date:

Previous
From: Guido Barosio
Date:
Subject: Re: REVOKE from all tables ...
Next
From: John DeSoi
Date:
Subject: Re: REVOKE from all tables ...