Install the Sophos Central Migration Tool database schema

To install the Sophos Central Migration Tool database schema on a remote Sophos database:

  1. On the Sophos Enterprise Console management server, run the Sophos Central Migration Tool self-extractor scmt_sfx.exe.
  2. If the Sophos Enterprise Console management server uses a remote database, the installer can't connect to the database and prompts you to look at the setup log.
  3. In C:\Windows\TEMP, open the log file scmt-setup.log. You see entries like these:
    <timestamp> -- Processing string segment: Initial Catalog=SOPHOS551
    <timestamp> -- Processing string segment: Data Source= 
    SqlServerHost\SOPHOS
    <timestamp> -- Remote database found
    <timestamp> -- Database exception: Invalid object name 'CloudMigration.CloudMigrationDataStore'. 
    <timestamp> -- Unable to connect to the remote migration tool database. 
    Exiting...
    <timestamp> -- -- BOOTSTRAPPER ENDED –
    

    Make a note of the Data Source (or Server) and the Initial Catalog (or Database) values. They refer to the remote SQL instance name and the Sophos Enterprise Console database name and are used when installing or uninstalling the Sophos Central Migration Tool database schema.

  4. Copy the scmt_210 folder to the remote database server.
  5. On the remote database server, open a command prompt and change to the folder C:\scmt_210\resources\DBScripts for the uncompressed installer content.
    Note If the logged-on account does not have sufficient rights to create the Sophos Central Migration Tool database schema within the Sophos Enterprise Console database, open the command prompt with the option “Run as different user” and specify an account with sufficient rights.
  6. Run the database installation script with the Data Source (or Server) and Initial Catalog (or Database) values obtained in step 3. For example: InstallDbCloudMigration SqlServerHost\SOPHOS SOPHOS551.

    If installation is unsuccessful, you'll see a message. Look at the log file InstallDbCloudMigration.log in the folder where you ran the script.

  7. After installing the schema, go back to the Sophos Enterprise Console management server, and run c:\scmt_210\setup.exe to install Sophos Central Migration Tool.