SSMA for Mysql Console Migration

케이 엔 5 Reputation points
2023-11-01T08:25:23.3066667+00:00

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.

SQL Server Migration Assistant
SQL Server Migration Assistant
A Microsoft tool designed to automate database migration to SQL Server from Access, DB2, MySQL, Oracle, and SAP ASE.
507 questions
{count} vote