Re: MSSQL -> PostgreSQL

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(at)upnix(dot)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(at)postgresql(dot)org
>

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