Install the Sophos Central Migration Tool database schema
Follow these instructions to install the schema.
To install the Sophos Central Migration Tool database schema on a remote Sophos database:
- On the Sophos Enterprise Console management server, run the Sophos Central Migration Tool self-extractor
- 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.
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.
scmt_210folder to the remote database server.
On the remote database server, open a command prompt and change to the folder
C:\scmt_210\resources\DBScriptsfor the uncompressed installer content.
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.
Run the database installation script with the Data Source (or Server) and Initial Catalog (or Database) values obtained in step 3.
InstallDbCloudMigration SqlServerHost\SOPHOS SOPHOS551
If installation is unsuccessful, you'll see a message. Look at the log file
InstallDbCloudMigration.login the folder where you ran the script.
After installing the schema, go back to the Sophos Enterprise Console management server, and run
C:\scmt\_210\setup.exeto install Sophos Central Migration Tool.