MS SQL Server (2005, 2008) ==> PostgreSQL 9.x

From: "J(dot)V(dot)" <jvsrvcs(at)gmail(dot)com>
To: PG-General Mailing List <pgsql-general(at)postgresql(dot)org>
Subject: MS SQL Server (2005, 2008) ==> PostgreSQL 9.x
Date: 2011-11-18 21:23:56
Message-ID: 4EC6CCEC.1060301@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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.

Browse pgsql-general by date

  From Date Subject
Next Message Gauthier, Dave 2011-11-18 21:44:59 Re: How to use like with a list
Previous Message Jerry Sievers 2011-11-18 21:14:28 Re: CLONE DATABASE (with copy on write?)