MySQL Forums
Forum List  »  Microsoft SQL Server

Re: Data transfer -- Problem temporarily resolved
Posted by: Murtaza Millwala
Date: April 27, 2005 07:21PM

Experimenting with the dts package and some hints an advice from fellow DBA's, the problem of data transfer has been temporarily been resolved.

It may not be the most efficient way..but...hey..it gets the work done..

I had to transfer data from a MS SQL table to MYSQL table.

Achieved in the following way:
1) have a drop table execute sql task (which drops the mysql table)
2) have a create table execute sql task (which creates the mysql table again)
3) have a insert execute sql task (to insert a row of test data in mysql table)
[Naturally a MSSQL connection with data pump to MYSQL connection]
when data is transferred from MSSQL table to MYSQL table

4) have a delete execute sql task ( to delete the test data row)

Like I said..its not efficient...especially if you have very large data tables...
but for the time being thats the workaround I have found.

You can either use queries in your data pump to transfer the data or directly from source table(MSSQL) to destination table(MYSQL) if both are same.

If anyone comes up with a better idea or better workaround technique,
Please contact me on murtazam@spotlight.com.au or post the technique on this forum.

Thank You

Options: ReplyQuote




Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.