I'm trying to use the MySQL Migration Toolkit to get a database out of SQL server and into MySQL.
My domain account has been granted access to the sql server in question and I can sucessfully create and test a normal ODBC connection.
When I try to use the toolkit I put in the server name and user / pass etc... and when I click on the button that would list the db's it gives me the error that the login failed.
I've tried user and password, domain\user, user@domain and variants thereof. Is this something that will work when my access is by my domain account? Is there some sort of special jdbc connect string I should be using?
It's been a while since I've used the Migration ToolKit...but isn't there an option to use an existing ODBC connection? Or do you need the jdbc driver? Does it give you an error message or a stack trace?
Have you tried checking the mysql forums? Also, I'm pretty sure there are a few issues if you're migrating from Access or Oracle that are discussed in the toolkit help documentation. Maybe there's something tricky with MS SQL too?