About Configuring Large Purge
You can upgrade your production database more quickly and without any downtime by creating a copy of the database, and then filtering it. After the copied or cloned database is filtered, it is updated with the latest data by using a database replicator. You must shut down the system to disengage the replicator, and then switch from the production database to the cloned database.
The large purge of the database involves the following components:
- Production database: This is the Plant Applications database used for Proficy Manufacturing Data Cloud (Proficy MDC). In this document, the production database is referred to as ProductionDB.
- Cloned or filtered database: This is the database that is created by filtering the backup of ProductionDB. The cloned or filtered database is a subset of ProductionDB. In this document, the cloned or filtered database is referred to as CloneDB.
- Replicator: This is the software application used to replicate ProductionDB. The replicator captures the modifications made to the data in ProductionDB, and then replicates the same modifications to CloneDB.
Software Requirements
Following are the software requirements for purging ProductionDB:
- SQL Server Management Studio: Required to access the databases and run the necessary scripts.
- AWS DMS: Required to replicate ProductionDB and to update CloneDB with the latest data modifications made in ProductionDB.
- Supporting files: Download the following files from the KB article number 000036043:
- FilteredDatabaseCopy-1.0.0.zip (this file contains the FilteredDatabaseCopy.exe and FiltersMaster.xml files)
- RemoveUnreferencedRows-1.0.0.zip
- ReferencedTables.xml
Tip:You can search for the KB article here: https://digitalsupport.ge.com/.