Upgrading the Database Protector

• 1: Preparing the System for Upgrade
• 2: Dropping the UDFs
• 3: Upgrading the Database Protector
• 4: Recreating the UDFs
• 5: Restarting the RPAgent

1 - Preparing the System for Upgrade

Before proceeding with an upgrade, stop the required services and create a backup of all the configuration files.

To prepare the system for an upgrade:

1. Log in to the database server as a user with the required permissions.

2. In the Windows search box, type Run

3. Press ENTER.

   The Run dialog box appears.

4. Type services.msc.

5. Press ENTER.

   The Services window appears.

6. To stop the RPAgent, right-click the Resilient Package Agent service and select Stop.

7. To stop the Log Forwarder, right-click the Logforwarder service and select Stop.

Note: To preserve the current configuration, copy the config.ini file to the required location. The config.ini file is available in the C:\Program Files\Protegrity\Database Protector\sqlserver\data directory.

2 - Dropping the UDFs

After stopping the services and creating a backup of the configuration files, drop the existing user defined functions.

To delete the UDFs:

1. Log in to the database server as the user that has the permissions.

2. Navigate to the C:\Program Files\Protegrity\Database Protector\sqlserver\sqlscripts folder.

3. Execute the DropObjects.sql file.

4. Create a backup of the Database Protector directory.

3 - Upgrading the Database Protector

Note: Starting with version 7.2.0, for first‑time ESA installations, initialize Policy Management before installing the protector. For more information about initializing the Policy Management, refer to the section Initializing the Policy Management.

To upgrade the Database Protector, install the newer version of the Database protector. For more information, refer Installing the MSSQL Database Protector.

4 - Recreating the UDFs

After the upgrade, recreate the required UDFs to restore the Database Protector functionality.

To re-create the UDFs:

1. Log in to the database server as the user that has the permissions.

2. Navigate to the C:\Program Files\Protegrity\Database Protector\sqlserver\sqlscripts directory.

3. To register the assembly, execute the CreateAssembly.sql script.

4. To create the UDFs, execute the CreateFunctions.sql script.

5 - Restarting the RPAgent

After the upgrade, restart the required services and deploy policies to restore Database Protector operations.

To restart the RPAgent service:

1. In the Windows search box, type Run.

2. Press ENTER.

   The Run dialog box appears.

3. Type services.msc.

4. Press ENTER.

   The Services window appears.

5. To restart the RPAgent service, right-click Resilient Package Agent service and select Restart.

6. To restart SQL Server, right-click on the SQL Server service and select Restart.

7. Deploy the policies from the ESA to the Database Protector.