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
scmt_sfx.exe
. - 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.
-
In
C:\Windows\TEMP
, open the log filescmt-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.
-
Copy the
scmt_210
folder to the remote database server. -
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.
-
Run the database installation script with the Data Source (or Server) and Initial Catalog (or Database) values obtained in step 3.
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. -
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.