Converter

The Convert to MS SQL Server utility creates an empty MOVEit Central database on a Microsoft SQL Server and configures MOVEit Central 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 process is complete, the Configure MOVEit Central program can be used to alter the settings.

Convert to MS SQL Server is not included in the MOVEit Central 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 Central to work with Microsoft SQL Server?

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

This following sections describe how to use the conversion utility.

Start the Convert to MS SQL Server Utility

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

At startup, 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. The database driver setup program does not require any input from you. It displays a window like:

Identify Database Server

The first page of the converter utility prompts for the credentials used to create the database. These credentials must already exist, and are typically not the credentials used by MOVEit Central to access the database once it's running.

The settings on this page are:

• SQL Server host is the hostname or IP address of the database server.
• Instance is the name of the instance. Typically this is empty, meaning the default instance. In some configurations of Microsoft SQL Server Express, this must be SQL Express.
• Use Windows Authentication sets the credentials to the Windows user that is running the utility. This requires that the computer on which the SQL Server is running has an identical Windows user, and that SQL Server is 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" might be used. Again, these must already exist.

When you choose Next, if the MOVEit Central service is running, the conversion utility will offer to stop it. If you do not choose to stop it, be aware that the new database will not go into use until you restart the service.

Test Database Connection

When you enter this page, the utility connects to SQL Server to test the credentials. It also checks to see whether a "micstats" database already exists on this server. If so, it will ask whether it is OK to delete the database.

When you have connected to the database successfully and see the above message, choose Next to create the database. If you cannot connect, choose Back and change your connection settings.

Create Database

This page shows progress in creating the database. When the database has been created successfully, you will see a prompt for the credentials that MOVEit Central itself should use to connect to the database.

The settings on this page are:

• Windows Authentication sets the credentials to the WIndows user that runs the MOVEit Central service. This requires that the computer on which the SQL Server is running have an identical user. The conversion program will, however, create the SQL Server login, as well as 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 will create the specified SQL login and database user on the SQL Server. The password is stored encrypted in the registry.

Choose Next to create the SQL login and to make the necessary MOVEit Central settings.

If you are using SQL Server authentication and see an error message reading "The user is not associated with a trusted SQL Server connection", then most likely the database is not configured to accept SQL Server logins. You can use SQL Server Management Studio to set SQL Server to allow SQL Server logins:

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.

SQL Database Creation Completed

This page will be displayed when the SQL login has been created, and MOVEit Central has been set to use it.

Choose Next to start copying the existing MySQL database into the newly-created MS SQL Server database, or choose Cancel to leave the new database unpopulated.

Choosing Perform full data integrity verification will cause the program to scan the two databases and compare all records after the copy is done. This will add about 30% to the total conversion time. If you do not choose to perform the full verification, the program will only check that the correct number of records ended up in the destination database.

Copying Database

This page displays while the program copies records from the existing MySQL database into the newly-created MS SQL Server database.

If the database is very large, the copy process many take a long time--even hours for multi-gigabyte databases.

When the copying is complete, this message is shown:

If you had earlier chosen to have the MOVEit Central service stopped, the conversion program will offer to start it again when you choose Finish.

Log File

The conversion program leaves a log file in the user's temporary directory, as given by the environment variable TMP. This directory is often named something like C:\Documents and Settings\username\Local Settings\Temp. The filename is MICMyToMS.log. If you need to contact technical support, please have this file on hand.