Re: MSSQL -> PostgreSQL - Mailing list pgsql-general

From Network Administrator
Subject Re: MSSQL -> PostgreSQL
Date
Msg-id 1053106953.3ec52309b5cbe@webmail.vcsn.com
Whole thread Raw
In response to MSSQL -> PostgreSQL  (Chris Cameron <chris@upnix.com>)
List pgsql-general
I'm not versed in MS-SQL (though I will be playing around with it in about a
week) however, I think I might be missing something- other than file system
limitations, table definitions and schema structure, is there a reason why you
can't dump the MS-SQL database tables to coma or tab separated text file?  You
can then use the PostgreSQL copy command to then read the data into the tables.


--
Keith C. Perry
Director of Networks & Applications
VCSN, Inc.
http://vcsn.com


Quoting Chris Cameron <chris@upnix.com>:

> 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
>
>
> ---------------------------(end of broadcast)---------------------------
> TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org
>




____________________________________
This email account is being host by:
VCSN, Inc : http://vcsn.com

pgsql-general by date:

Previous
From: "Dann Corbit"
Date:
Subject: Re: Heterogeneous service (like Oracle or Ms SQL Server)
Next
From: Doug McNaught
Date:
Subject: Re: Problem Starting Postgresql after upgrade from SuSE8.1 to SuSE 8.2