Click here to Skip to main content
15,867,568 members
Please Sign up or sign in to vote.
5.00/5 (1 vote)
See more:
Hi Geniuses,

I am trying to Migrate SQL server express 2005(from VS2008) to MYSQL using MYSQL migration toolkits. But it keep on throwing the error as below. I have also change the default UID and Password 'sa' to something. Looks like not able to connect to my Local server by MYSQL migration toolkits. Any link or any help will be highly appreciated.

Thanks in advance.
Asem Ibohal

-------------------------------------------------

Connecting to source database and retrieve schemata names.
Initializing JDBC driver ...
Driver class MS SQL JDBC Driver
Opening connection ...
Connection jdbc:jtds:sqlserver:
MSIL
Connecting to source database and retrieve schemata names.
Initializing JDBC driver ... 
Driver class MS SQL JDBC Driver

MSIL
net.sourceforge.jtds.jdbc.ConnctionJDBC2.java:364)
net.sourceforge.jtds.jdbc.ConnectionJDBC3.<iava:50)
net.sourceforge.jtds.jdbc.Driver.connect(Driver.java:178)
java.sql.DriverManager.getConnection(Unknown Source)
java.sql.DriverManager.getConnection(Unknown Source)
com.mysql.grt.modules.ReverseEngineeringGenericrseEngineeringGeneric.java:141)
com.mysql.grt.modules.

===================================================
Posted

A simple google search for "migrate sql server to mysql" gives back 1.4 MILLION hits, and the very first one in the list might answer your question.
 
Share this answer
 
Neve mind, I used "Full Convert Enterprise Trial" from

http://www.spectralcore.com/downloadtrialfile.php?reqfile=trial-fc-ent&actcode=386A-B226-55B5&firstname=Asem[^]

and it work fine. MSQL Migration tools really sucks..
 
Share this answer
 

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)



CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900