Migrate SQL Secure to a different server

IDERA SQL Secure among its features allows migrating SQL Secure from one server to another.

For a successful SQL Secure migration make sure to  

• Move the repository to a new SQL Server host.
• Copy the SQL Secure Collector Jobs into a script and restore them to a new SQL Server host.
• Update the collector jobs' CLI operations with the new SQL Server host instance name.
• Install the SQL Secure components on the new SQL Server instance.

To copy SQL Secure settings to a new installation, follow the steps below

1. Back up the SQL Secure repository database on the original server.
2. Open the SQL Server Agent manager on the repository server and find each of the SQLsecure Collector Job and the SQLsecure Groom Job.
3. Create a SQL script for each of these jobs using the native tools.

On the new SQL Server,

1. Restore the SQLsecure repository.
2. Execute the SQL scripts you collected to re-create the jobs.

3. Each collection job contains a command-line operation similar to the following:

   C:\Program Files\Idera\SQLsecure\Bin\Idera.SQLsecure.Collector.exe" -TargetInstance "TARGETSERVER" -Repository "SERVER

   Update the "SERVER" value to match the instance name of the new repository.

4. Perform a Full Install of SQL Secure from the installation kit.

5. Select the option to use the existing repository when prompted in the installation wizard.

6.  E-mail licensing@idera.com with the name of the new SQL Server instance that hosts the SQLsecure repository database. Then you will receive a new permanent key for the new SQLsecure installation.