Previous Topic

Next Topic

Book Contents

Book Index

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.

  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:

  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:

  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.

  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.