MS Access / PostgreSQL

[Matthew Hawkins]

Chris Fletcher (cf at netspeed.com.au) wrote:
> Can anyone recommend a 'safe' way to import the entire contents of an MS
> SQL7 database table into a MYSQL database.  The MS SQL database contains
> about 10 million records and cant really be taken offline so it needs to be
> done live.  And without impacting performance either.

This sounds like a pipe dream, as a live database presumably is in an
inconsistent state and hence you won't ever get an accurate copy of it
while it is live.  Asking for a full dump to not impact performance is
only going to get a positive answer if you've got undercommitted
hardware and/or undercommitted use of the database happening at the time
;)

If you could, you could start off the mysql server from data stored in a
backup of the live system, then replay the commit logs for the time
since that backup was done to bring it up to date.  Not sure if MSSQL
stores that kind of useful information though.

As for plain transferring, I'd be inclined to dump it as CSV and import
that into mysql, since I wouldn't trust MSSQL to use any form of SQL
compatible with mysql (or anything else, for that matter - including any
other version of MSSQL), and it's much easier to fix CSV than to parse
whatever flavour of SQL and try to fix that.

-- 
Matt
-------------- next part --------------
A non-text attachment was scrubbed...
Name: not available
Type: application/pgp-signature
Size: 189 bytes
Desc: not available
Url : http://lists.samba.org/archive/linux/attachments/20021014/f1fb6843/attachment.bin