MySQL Forums
Forum List  »  Microsoft SQL Server

Re: Data transfer -- Problem temporarily resolved
Posted by: Rajani Raja
Date: July 25, 2005 10:53AM

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.


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.