Postgres Pro
Downloads
Home   >   mailing lists

RE: Migrate from MS SQL 6.5 to postgres?? - Mailing list pgsql-general

From Pablo Prieto
Subject RE: Migrate from MS SQL 6.5 to postgres??
Date
Msg-id 011901c0a0e6$660bde70$156710ac@pablo
Whole thread Raw
In response to Migrate from MS SQL 6.5 to postgres??  ("Steve O'Hagan" <sohagan@dont-spam-me-stanger.com.hk>)
List pgsql-general
Tree view 
-----Mensaje original-----
De: martin.chantler@convergys.com <martin.chantler@convergys.com>
Para: pgsql-general@postgresql.org <pgsql-general@postgresql.org>
Fecha: martes 27 de febrero de 2001 14:06
Asunto: Re: [GENERAL] Migrate from MS SQL 6.5 to postgres??


>
>I have an idea that might help
>I found ODBC to be very slow for importing data
>So I wrote a program in C that reads in dump files of SQL text on the Linux
>server itself


Hi!
I got the MS Sql Server data as Access Tables (slowly). After that I copied
the tables from Access to PostgreSQL (very fast).
The main advantage was don't overload MS SQL Server (very weak that fellow).

Greetings

Pablo

pgsql-general by date:

Previous
From: "Oliver Elphick"
Date:
Subject: Re: Case sensitivity
Next
From: "Oliver Elphick"
Date:
Subject: Re: inheritance and partial index: how to override constraints or default_values