Problem Migrating Mysql Database to SQL Server

Asked

Viewed 655 times

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.

inserir a descrição da imagem aqui

  • 1

    Do the reverse, use the Import and Export Data SQL Server or the Integration Services.

  • 1

    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"..

2 answers

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.

Migration Database

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

You are not signed in. Login or sign up in order to post.