Migrate MySQL to Microsoft SQL or Azure SQL

Prerequisites for Azure SQL database

• An Azure SQL database server. You must have an Azure SQL server before you migrate your data. If you have not already created an Azure SQL server, you can create one on the Azure Management Portal.

Prerequisites for Microsoft SQL and Azure SQL

• Server information. Server name or IP address and the port number
• Credentials. Account credentials with administrator access (sa account or equivalent)
• Microsoft SQL only: instance name if applicable

• To migrate an existing MySQL database to Microsoft SQL or Azure SQL, complete the following steps.

1. Launch the MIAutomation-MyToMS.exe conversion utility.
2. On the Identify Database Server dialog box, provide the Microsoft SQL or Azure SQL connection information and administrator credentials.
   1. SQL Server Type

      Select the SQL Server Type.

   2. SQL Server Location

      Server (host, port): The hostname and port (if required) of the database server.

      Instance, if any: Name of the instance. Leave this field blank to use the default instance.

   3. SQL Server Administrator Credentials

      Use Windows Integrated Authentication: (MS SQL only) Uses the credentials of the Windows user that is running the utility. The SQL Server must be configured to use the Windows user authentication and the user must have administrative rights.

      Use SQL Server Authentication: Provide the account credentials for an existing administrative user defined in the MSSQL Server or Azure SQL Server.

3. Click Next.

   If the MOVEit Automation service is running, the conversion utility will offer to stop it. If you do not stop the service, the new database will not be used until you restart the service.

4. The utility verifies that it can connect to the SQL Server with the specified server details and administrator credentials.

   Note: You can edit the Azure SQL pricing options in the Azure portal after the database is created.

5. To create a MOVEit Automation database, click Next.
6. On the Create Database dialog box, the message Empty database created successfully is displayed. Provide the credentials that the MOVEit Automation Server will use to access the database, or an account will be created. The new user is given db_owner, bd_reader, and bd_datawriter permissions.

   Use Windows Integrated Authentication: (MS SQL only) Sets the credentials to the Windows user that runs the MOVEit Automation service. The conversion utility creates the SQL Server login and configures the user rights to the MOVEit Automation database.

   Create SQL Server User: Specify a user name and password. The conversion utility creates a new SQL Server user with the specified password and configures user rights to the MOVEit Automation database. The password is encrypted and stored in the registry.

7. Click Next.
8. The SQL Database Creation Completed dialog box confirms that the database creation is complete.

   Perform full data integrity verification

   Check box selected: When the copy is complete, the program scans the two databases and compares all records.

   Check box cleared: When the copy is complete the program checks only that the correct number of records exist in the destination database.

9. To copy the existing MySQL database into the new MS SQL or Azure SQL server database, click Next. To leave the database unpopulated, click Cancel.
10. The Copying Database dialog box displays the progress bar. If the database is large, the copy process may take some time.
11. When the Database copied successfully message appears, click Finish.

Log File

The conversion tool places a log file in the temporary directory, as specified by the environment variable TMP. The name of this directory is similar to C:\Users\username\Local Settings\Temp. The filename is MICMyToMS.log. If you need to contact technical support, have this log file available.