MySQL Migration Toolkit & SQL Express

Question

I'm trying to port a database from SQL Server Express over to my MySQL database. I've made sure the SQL Express is running on port 1433 and all, and the MySQL Migration toolkit is even able to see the different databases/schemas I have in my SQL Server Express DB.

The problem is that MySql Migration toolkit won't let me press "next" until I enter a username/password, which doesn't make sense to me since it is able to connect to the Express DB and view all of the schemas without those.

I've tried using the "advanced" settings to directly specify the connection string, but that's not working for me either. I'm probably getting the string wrong. Help?

Answer 1

By default SQL Express has access for user 'sa' and empty password. Try that.

Answer 2

Ahah! I got it! I was able to make it work using this connection string:

jdbc:jtds:sqlserver://localhost:1433/Bookstore;user=;password=;charset=utf-8;domain=

I put that in the advanced text box, and then just a space for the username (that probably could have been anything though).

(The sa and empty password trick wouldn't work for me)

Answer 3

My SQL Server is a named instance... like computername$SQLExpress...

what can be possible connection string? My next button isnot being active even if i tried the given connection string

Answer 4

OK. In Source Database select MS SQL Server. In Advanced Settings write

jdbc:jtds:sqlserver://10.210.4.2:1433/INFRASTRUCTURE;instance=MENG;user=sa;password=XXX;charset=utf-8;domain=

Test your connection with clic button database to retrive list from server. If no conect then:

• ¿Do you connected from remote machine? OK is your firewall Up? Can shutdown? No? configure and open your 1433 port or SqlServer executable.

Ah! and enable and Start SqlServer Browser service!

Uhhh fill the other text box to activate the next button.

Happy MySqling!