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.
- Install the SQL Secure components on the new SQL Server instance.
To copy SQL Secure settings to a new installation, follow the steps below
- Back up the SQL Secure repository database on the original server.
- Open the SQL Server Agent manager on the repository server and find the SQLsecure Collector Job and the SQLsecure Groom Job.
- Create a SQL script for each job using the native tools.
On the new SQL Server,
- Restore the SQLsecure repository.
- Execute the collected SQL scripts to re-create the jobs.
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.
Perform a Full Install of SQL Secure from the installation kit.
In the installation wizard, select the option to use an existing repository.
E-mail 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.
For SQL Secure 2.5 UPGRADES on SQL Server 2000