Page History

Among IDERA SQL Secure

...

's features, it 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 SQL Server host instance name in 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
3. Manager on the repository server and find
each of
4. the SQLsecure Collector Job and the SQLsecure Groom Job.
5. Create a SQL script for each
of these jobs
6. job using the native tools.

On the new SQL Server,

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

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

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

   Note
   Update the

"

5. SERVER

"

6. value to match the instance name of the new repository.

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

Select

8. In the installation wizard, select the option to use

the

9. an existing repository

when prompted in the installation wizard

10. .

 E with the name of

11. E-mail

licensing@idera.com

12. IDERA with the new SQL Server instance name that hosts the SQLsecure repository database. Then you will receive a new permanent key for the new SQLsecure installation.