Description:
We cannot migrate a SQL Server database to a SSL MySQL instance.
The migration is able to successfully create the tables at the target instance. However, when it tried to move the data fails with this error:
15:12:18 [INF][ copytable]: Connecting to MySQL server at <server_name>:<port> with user <user_name>
15:12:18 [ERR][ copytable]: Failed opening connection to MySQL: Access denied for user '<user_name>'@'<IP>' (using password: YES)
Since the target instance is using SSL, I need to define the connection using the required certificates which works fine at least to create the tables. However, it looks like when it tried the data move, it requires another connection and this time is not using the certificates.
I found out that it uses this tool: wbcopytables.exe but it looks like it does not support SSL.
How to repeat:
- Create a mysql instance and configure to use SSL
- Validate you can connect from Workbench providing the right certificates
- Try to migrate a database from a SQL Server instance using the right connections details (including the SSL certificates)