Initialization error while migration assistance for MySQL

Question

I am trying to migrate my MySQL database to MS SQL. I have already installed the ODBC driver and SSMA for MySQL. However I got an initialization error when trying to open SSMA.

Cannot start because of an initialization error

Try to restart the application. If this problem remains, contact support group (please provide a log file).

Unexpected error.

Exception: One or more errors occurred.
 site: 
 source: 

InnerException #1: The type initializer for 'Microsoft.SSMA.Framework.Generic.AbstractTelemetryProvider.Containers.TelemetryEventData' threw an exception.
 site: Void .ctor(Microsoft.SSMA.Framework.Generic.AbstractTelemetryProvider.Enums.TelemetryOperationType, System.Guid)
 source: Microsoft.SSMA.Framework.Generic.AbstractTelemetryProvider
   at Microsoft.SSMA.Framework.Generic.AbstractTelemetryProvider.Containers.TelemetryEventData..ctor(TelemetryOperationType operationType, Guid activityId)
   at Microsoft.SSMA.Framework.Generic.AbstractTelemetryProvider.Recorders.Abstraction.TelemetryEventRecorder.AddEvent(TelemetryOperationType eventType)
   at Microsoft.SSMA.Framework.Generic.AbstractTelemetryProvider.Recorders.TelemetryApplicationEventRecorder.WriteSetup(String osName, String productName, Boolean isInternal)
   at System.Threading.Tasks.Task.Execute()
--- End of stack trace from previous location where exception was thrown ---
   at System.Runtime.ExceptionServices.ExceptionDispatchInfo.Throw()
   at System.Runtime.CompilerServices.TaskAwaiter.HandleNonSuccessAndDebuggerNotification(Task task)
   at Microsoft.SSMA.GUI.Product.SourceToTarget.Startup.GuiBootstrap`1.<InitializeAsync>d__11.MoveNext()
InnerException #2: Object reference not set to an instance of an object.
 site: System.String GetMachineId()
 source: Microsoft.SSMA.Framework.Generic.AbstractTelemetryProvider
   at Microsoft.SSMA.Framework.Generic.AbstractTelemetryProvider.Containers.TelemetryEventData.GetMachineId()
   at Microsoft.SSMA.Framework.Generic.AbstractTelemetryProvider.Containers.TelemetryEventData..cctor()

Answer 1

Hi @Chua Camille，

To use SSMA, you first must install the SSMA client program on a computer that can access both the source MySQL database and the target instance of SQL Server . Then, install the MySQL providers (MySQL ODBC 5.1 Driver (trusted)) on the computer that is running SSMA Client Program. For installation instructions, see Installing SSMA for MySQL (MySQLToSQL)

Please also make sure that SQL Server is running on the machine.

If these all do not work, try to uninstall SSMA and re-install.

Getting Started with SSMA for MySQL (MySQLToSQL)

Regards，

Zoe Hui

---

If the answer is helpful, please click "Accept Answer" and upvote it.