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.
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.
These credentials must already exist, and are typically not the credentials used by MOVEit Automation to access the database after it is running.
Fields:
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.
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.
Note: If you cannot connect, click Back and change your connection settings.
Specify how MOVEit Automation should authenticate to the database:
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:
You must stop and start the MSSQLSERVER service for the changes to take effect.
Perform full data integrity verification checkbox.
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.
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.