Hello MySQL Community,
in the last Week I started my internship and my task is to migrate data from SQL Server 2008 R2 Express to MySQL. Therefor i wanted to use the MySQL Migration Toolkit, which seemed to be a proper solution for my task. But now I am facing a problem and even my superiors, who are quite experienced in databases couldn't help me. So the problem is, that whatever I do the Migration Toolkit doesn't detect the source Database.
I think as hostname, "localhost" or "127.0.0.1" is the right decision, the Port is 1433, I unlocked it in the TCP/IP protocolls as well. But I'm not really sure what I should use as username and/or password. I defined a username and a password for the entity I wanted to use and tried these but it didn't work. My windows username and pass didn't work as well. Here is the error report I usually get:
Connecting to source database and retrieve schemata names.
Initializing JDBC driver ...
Driver class MS SQL JDBC Driver
Opening connection ...
The list of schema names could not be retrieved (error: 0).
ReverseEngineeringMssql.getSchemata :Network error IOException: Connection refused: connect
What am I doing wrong? I would be very nice of you if you can help me get that fixed.
Kind regards, Robert
Edited 1 time(s). Last edit at 06/21/2011 06:54AM by Robert Vagt.