Mysql to SQL server 7.00

[niki]

Hi Guys,

I am working for a client who needs to move database from MySQL application to MS SQL SERVER 7.0.
Is there anybody who has done it before?
I need some help about how to load data from one system to another system.

THanks in advance.

[David Westmore]

We are using both products (although I personally haven't looked at MySQL yet and we haven't tried passing data betweeen them).

I would imagine that it would be quite easy to do using DTS (I've done copying data structures and the data itself from Adabas/C and Informix to SQL using DTS and it works OK, and I would immagine that MySQL would be simpler than Adabas/C).

Probably the best method is to set up an ODBC DSN on the SQL Server (that also means installing the ODBC driver for MySQL) and then using the Import Data wizard to create one or more DTS packages which will probably need some retouching).

I know we have a driver ODBC for MySQL, if you need info I can find out where we found it.

Regards

David Westmore
Castellanza (Italy)


------------
niki at 11/16/00 5:12:11 PM

Hi Guys,

I am working for a client who needs to move database from MySQL application to MS SQL SERVER 7.0.
Is there anybody who has done it before?
I need some help about how to load data from one system to another system.

THanks in advance.