SSMA for Mysql Console Migration
The migration was successful in SSMA gui.
But not on the console.
It's a script I wrote
<?xml version="1.0" encoding="utf-8"?>
<ssma-script-file xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:noNamespaceSchemaLocation="..\Schemas\M2SSConsoleScriptSchema.xsd">
<script-commands>
<open-project
project-folder="C:\Users\82106\Documents\SSMAProjects\mysql_mssql"
project-name="mysql_mssql"
/>
<connect-source-database server="nkmysql"/>
<connect-target-database server="nk-sql-server"/>
<migrate-data>
<data-migration-connection
source-server="nkmysql"
target-server="nk-sql-server"
/>
<metabase-object object-name="nk_test_db.test" />
<metabase-object object-name="nk_test_db.pi_cloud_shutdown_time" />
</migrate-data>
</script-commands>
</ssma-script-file>
This is the result of running on Windows PowerShell.
PS C:\Users\82106> SSMAforMySqlConsole.exe -s "C:\Users\82106\Desktop\SSMA_SCRIPT\open_project.xml" -C "C:\Users\82106\Desktop\SSMA_SCRIPT\ServerConnection.xml"
[2023-11-01 오후 5:20:27] MESSAGE generic Microsoft SSMA for MySql v9.4
[2023-11-01 오후 5:20:27] WARNING Server nkmysql password is provided in non-secure cleartext form. SSMA Console application provides an option to protect the password through encryption. Please see ?securepassword option in SSMA help file for more information.
[2023-11-01 오후 5:20:27] WARNING Server nk-sql-server password is provided in non-secure cleartext form. SSMA Console application provides an option to protect the password through encryption. Please see ?securepassword option in SSMA help file for more information.
[2023-11-01 오후 5:20:27] MESSAGE generic #### Start processing command sequence...
[2023-11-01 오후 5:20:27] START open-project
[2023-11-01 오후 5:20:28] FINISH
[2023-11-01 오후 5:20:28] START connect-source-database
[2023-11-01 오후 5:20:28] MESSAGE generic Establishing connection to mysql server 'nkmysql'
[2023-11-01 오후 5:20:31] MESSAGE output-window Connection to MySQL established successfully.
Connection string: Driver={MySQL ODBC 8.0 ANSI Driver};Server=nkmysql.mysql.database.azure.com;Port=3306;User=nkadmin;Option=3
[2023-11-01 오후 5:20:38] FINISH
[2023-11-01 오후 5:20:38] START connect-target-database
[2023-11-01 오후 5:20:38] MESSAGE generic Establishing connection to sql-azure server 'nk-sql-server'
[2023-11-01 오후 5:20:38] FINISH
[2023-11-01 오후 5:20:38] START migrate-data
[2023-11-01 오후 5:20:38] MESSAGE generic Object passed as a parameter table nk_test_db.test
[2023-11-01 오후 5:20:38] MESSAGE generic Object passed as a parameter table nk_test_db.pi_cloud_shutdown_time
[2023-11-01 오후 5:20:38] MESSAGE generic Running command on all tables in database nk_test_db
[2023-11-01 오후 5:20:38] MESSAGE generic Migration started...
[2023-11-01 오후 5:20:38] FATALERR Attempt to reconnect source failed.
Please let me know if there is anything wrong.
Thank you for reading.