MSSQL -> PostgreSQL

From: Chris Cameron <chris(at)upnix(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: MSSQL -> PostgreSQL
Date: 2003-05-09 16:16:26
Message-ID: 1052496986.24103.6.camel@localhost
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I'm looking to convert 2 MSSQL DB's to PostgreSQL. I've searched the
archives and various websites and found a number of solutions.

The problem is, none of them work for me. One of the databases is 150
Megs, the other 3 Gigs. It isn't very feasible for me to go into a 3 gig
file and search/replace all sorts of things (which seems pretty "iffy" a
solution to me).

I've also tried converting the MSSQL tables/data to MySQL dumps (we had
a -very- good tool laying around for that), and then running a
mysql2postgresql script against it. I've tried the one in
/contrib/mysql/ and the one on pgsql.com. Both died when they ate all
the memory on the machine (2 gigs worth).

So, any suggestions for someone looking to convert a 3+ gig database?
We're willing to pay for any tool that may work, but I haven't been able
to find any.

Thanks,
Chris

--
Chris Cameron
UpNIX Internet Administrator
ardvark.upnix.net
bitbucket.upnix.net
--
http://www.upnix.com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message jerome 2003-05-09 18:08:53 PG_DUMP too slow...
Previous Message Bob Wheldon 2003-05-09 16:09:10 Zope