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

From martin.chantler@convergys.com
Subject Re: Migrate from MS SQL 6.5 to postgres??
Date
Msg-id OFB13C2AF2.443BAB84-ON80256A00.003E8B1C@cbis.com
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
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
E.G. first line is a create table, next lines are all the insert's
This is very fast, 80mb of data in about 15 minutes
Only problem is the text files need to be formatted a bit specially
If you can write a program in say VB to create the text files (one per
table)
it could work.
If you are interested I could forward my C program and Foxpro prg that
creates the text files that
you could convert to VB


Regards,
MC





"Steve O'Hagan" <sohagan@dont-spam-me-stanger.com.hk> on 26/02/2001
08:46:14

To:   pgsql-general@postgresql.org
cc:    (bcc: Martin Chantler/CIMG/CVG)
Subject:  [GENERAL] Migrate from MS SQL 6.5 to postgres??


Any utilities around which would ease the pain involved in migrating an m$
sql6.5 database running on WinNT box to postgres running on a Linux box??

If no such utilities around - any advice on strategy to adopt??

Regards,
Steve O'Hagan






--

NOTICE:  The information contained in this electronic mail transmission is
intended by Convergys Corporation for the use of the named individual or
entity to which it is directed and may contain information that is
privileged or otherwise confidential.  If you have received this electronic
mail transmission in error, please delete it from your system without
copying or forwarding it, and notify the sender of the error by reply email
or by telephone (collect), so that the sender's address records can be
corrected.



pgsql-general by date:

Previous
From: Matthias Teege
Date:
Subject: Last x records
Next
From: brichard@cafod.org.uk (Bruce Richardson)
Date:
Subject: Re: Problems with RAISE EXCEPTION