MS SQL Server (2005, 2008) ==> PostgreSQL 9.x - Mailing list pgsql-general

From J.V.
Subject MS SQL Server (2005, 2008) ==> PostgreSQL 9.x
Date
Msg-id 4EC6CCEC.1060301@gmail.com
Whole thread Raw
List pgsql-general
What are some of my options for dumping data / constraints out of SQL
Server and importing to PostgreSQL 9.x?

I can probably recreate the schema in PostgreSQL with a tool and make
sure all constraints are there ( < 100 tables ), but want to know the
best way to get data over.

Text or number data should be no problem, but when not sure about
exporting/importing binary data.

If there is a tool out there, or I should just dump out as csv and
import, let me know.

thanks

J.V.

pgsql-general by date:

Previous
From: Jerry Sievers
Date:
Subject: Re: CLONE DATABASE (with copy on write?)
Next
From: "Gauthier, Dave"
Date:
Subject: Re: How to use like with a list