Converter

The Convert to MS SQL Server utility creates an empty MOVEit Automation database on a Microsoft SQL Server and configures MOVEit Automation to use that database.This utility is run only one time to create the initial database. It provides an option to copy an existing MySQL database to the newly created SQL Server database. After the copying of the existing MySQL database is complete, the registry settings are automatically changed to use the MS SQL database. If the existing database is not to be copied, the Configure MOVEit Automation program can be used to alter the settings.

Convert to MS SQL Server is not included in the MOVEit Automation installation. You can download it from the MOVEit support site. For information about prerequisites and where to find the download, see How do I get MOVEit Automation to work with Microsoft SQL Server?

Note: DO NOT run this utility on a MOVEit Automation version that older than version 6.3. Data loss could occur. To convert a version of MOVEit Automation older than 6.3, first upgrade to version 6.3 or later, and then run the conversion.

• To use the Convert to MS SQL Server Utility

1. Select Programs > MOVEit Automation > Convert to MS SQL Server. The utility runs as a wizard.

   The Preparing to Install window appears. The utility checks to see whether the Microsoft SQL Native Client database driver is already installed. If it is not installed, the program installs it automatically.

2. On the Identify Database Server dialog box, provide the credentials that are used to create the database.

   These credentials must already exist, and are typically not the credentials used by MOVEit Automation to access the database after it is running.

   Fields:

   • SQL Server host. Hostname or IP address of the database server.
   • Instance, if any. Name of the instance. Typically this field is empty, meaning the default instance. In some configurations of Microsoft SQL Server Express, the value must be SQL Express.
   • Credentials for initial creation of database. The credentials for the option you select must already exist.
     • Use Windows Authentication. Uses credentials of the Windows user that is running the utility. The computer on which the SQL Server is running must have an identical Windows user, and the SQL Server must be configured to recognize that user.
     • Use SQL Server Authentication. Sets the user to the specified SQL Server login and password. For example, the login sa. The values you specify must already exist.
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 go into use until you restart the service.

4. On the Test Database Connection dialog box, the utility connects to SQL Server to test the credentials.

   The utility also checks to see whether a micstats database already exists on this server. If it exists, you are prompted to confirm whether it is OK to delete the database. Click OK.

5. When the Test Database Connection dialog box displays the message Connected to database successfully, click Next.

   Note: If you cannot connect, click Back and change your connection settings.

6. On the Create Database dialog box, the message Empty database created successfully appears. Provide the following information:

   Specify how MOVEit Automation should authenticate to the database:

   • Windows Authentication. Sets the credentials to the WIndows user that runs the MOVEit Automation service. The computer on which the SQL Server is running must have an identical user. The conversion program creates the SQL Server login, and the corresponding user within the database.
   • SQL Server Authentication. Sets the user to the specified SQL login and password when authenticating to the database. The conversion utility creates the specified SQL login and database user on the SQL Server. The password is stored encrypted in the registry.
7. Click Next.

   Note: If you are using SQL Server authentication and the following error message appears:

   The user is not associated with a trusted SQL Server connection

   the most likely cause of this error is that the database is not configured to accept SQL Server logins. Do the following:

   1. Open SQL Server Management Studio.
   2. Right-click on the server name and choose Properties.
   3. Choose Security, and then choose SQL Server and Windows Authentication mode.

   You must stop and start the MSSQLSERVER service for the changes to take effect.

8. After the SQL login is created and MOVEit Automation is set to use it, the SQL Database Creation Completed dialog box appears.

   Perform full data integrity verification checkbox.

   • Selected. After the copy is done, the program scans the two databases and compares all records. This process adds approximately 30% to the total conversion time.
   • Not selected. After the copy is done, the program checks only that the correct number of records exist in the destination database.
9. Click Next to start copying the existing MySQL database into the newly-created MS SQL Server database. Or, click Cancel to leave the new database unpopulated

   The Copying Database page shows a status bar. If the database is very large, the copy process might take a long time, such as several hours for multi-gigabyte databases.

10. When the Database copied successfully message appears, click Finish.
11. If you previously stopped the MOVEit Automation service, you are prompted to start it.

Log File

The conversion program places a log file in the user's 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.