Re: Data transfer -- Problem temporarily resolved

[Rajani Raja]

Hi Bettina,

Can you please post the code that worked for you in transfering the data from MS sql server to Mysql Server.I am trying to transfer data through java programming on Mac OS X environment.but am not able to transfer.My code has two connection statements to 2 servers through their compatable drivers. .i am facing some problem with the datadump after connecting to the servers using this statement

stmt.executeUpdate("INSERT INTO mysqlserver.dbname.username.tablename SELECT * FROM mssqlsrv.dbname.username.tablename");

I dont find any migration tool kit thats compatible to Mac OS X.

Thanks.