MS Access / PostgreSQL

[Michael James]

>Slightly off the main topic here but ...
>
>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.

In our evaluation people (on this list too) said that MSSQL could dump as SQL!
That was my planned path out, but I don't know how you get the dump to happen.

michaelj
-- 
A right not exercised is a privilege
a privilege not exercised is illegal.

Michael James			michael at james.st
8 Brennan St			Phone: +61 2 6247 2556
Hackett, ACT 2602		Mobile: +61 4 1747 4065
AUSTRALIA			Fax: +61 2 6278 0011