I am not able to migrate a database from MySQL to SQL Server, using Database Migration from MySQL Workbench.
In SQL Server Server authentication, it uses login sa, I have already tried to reset the login password, but I could not. I also tried changing the authentication from Windows Authentication to SQL Server Authentication and I could not.
The Database Migration feature of only works for import from other databases for MySQL itself, / p>
Note that the target session can only specify a connection to MySQL, not other systems.
YoushouldthendotheoppositeandusetheSQLServerImportandExportWizard. This answer briefly shows how to use this tool, in your case just change the source for MySQL.
