4
I am unable to migrate a database from Mysql to SQL Server using Mysql Workbench Database Migration.
In SQL Server authentication, it uses sa login, I tried to reset the password of this login, but I could not. I also tried to change the authentication of, Windows Authentication for SQL Server Authentication and could not.
4
The resource of Database Migration of Workbench only works for import from other databases to Mysql itself, not the other way around.
Note that the session target only it is possible to specify a connection to Mysql, and not to other systems.
You must then do the contrary and use the SQL Server Import and Export Wizard. That answer shows briefly how to use this tool, in your case just change the source for Mysql.
0
Try using SSMA - SQL Server Migration Assistant
It can migrate from Mysql versions above 4.1 and can deliver on Sqlserver from 2012 until 2019
You will need to install a Mysql Connector/ODBC v5.1
Browser other questions tagged mysql sql-server mysql-workbench
You are not signed in. Login or sign up in order to post.
Do the reverse, use the Import and Export Data SQL Server or the
Integration Services.– Lucio Rubens
the error code is very clear. 01S00... indicates invalid connection string. Looking closely at the screenshot, vc is in the Source RDBMS, that is, the database where the data is. If you want to migrate from Mysql to SQL Server, then why did you choose the destination in the source specification ? It should be Mysql.. SQL Server vc chooses in the next step, under "Target Selection"..
– Daniel Omine