The steps involved in removing Repstance are detailed below.

6.1 How to remove Apply Process

To remove an Apply Process use the “remove” command (see chapter 7.14 Remove Apply Process). The details on how to remove Apply Process through the Web UI are provided in chapter 8.2.2.3 Modify, Delete and Validate Process.

After using this command, it will remove all information about the Apply Process, namely configuration files, and the checkpoint details, together with historical information. If the Target Database is reachable, the “remove” command will clean-up all the checkpoint information on the Target Database.

As the “remove” command can only accept a single “Apply parameter”, this action can only be used for one Apply Process at a time.

6.2 How to remove Capture Process

To remove a Capture Process use the “remove” command (see chapter 7.8 Remove Capture Process). The details on how to remove Capture Process through the Web UI are provided in chapter 8.2.2.3 Modify, Delete and Validate Processes.

After using this command, it will remove all information about the Capture Process, namely configuration files, checkpoint details, and the Trail Files. If the Source Database is MS SQL Server and it is reachable the “remove” command will disable CDC on the tables that were used by this Capture Process only.

As the “remove” command can only accept a single “Capture parameter”, this action can only be used for one Capture Process at a time.

Note – If there are still any Apply Processes using Trail Files from this Capture Process, they will fail.

The steps involved in removing Repstance Server Database Objects are detailed below.

6.3 Remove Target Database Objects

To remove Target Database Objects use the “remove” command (see chapter 7.2 Remove Repstance Database Objects) or Web UI (see chapter 8.2.1 Database Configuration).

After using this command, it will remove all the Data Objects that were required by the Apply Process. If there are still Apply Processes inserting data, using these objects they will immediately fail.

Note – It is strongly recommended that before running this command you run the “status” command and make a record the LSN/SCN in the “Last Applied DB Change” section for each Apply Process running on this database, in this way it will be possible to reverse this action for this database at a later point in time, assuming that the correct Trail Files still exist and can be accessed.

6.4 Remove Source Database Objects

To remove Source Database Objects use the “remove” command (see chapter 7.2 Remove Repstance Database Objects) or Web UI (see chapter 8.2.1 Database Configuration).

Note – When using this command it MUST be understood that there will be no way to “Recover” from its effects.

After using this command, it will remove all the Data Objects that were required by the Capture Processes. If there are still Capture Processes extracting data, using these objects they will immediately fail. For MS SQL Server it will disable CDC on this database. At this point Repstance will no longer be able to record or extract data from this database.