You must perform this procedure at the Host location using the administrative computer on which the replication process was first initiated.
-
In the Project Management tree, select the replicated model to consolidate.
-
Click Tools > Consolidate Model from Workshare Command to open the Consolidate Models from Workshare Dialog.
-
Type the GoldenGate administrator password, and click OK.
A series of scripts are generated in a subfolder named "Consolidate<ModelName>" in the local temp folder.
-
Copy the scripts in the folder to their corresponding servers. See Copy generated scripts into GoldenGate folders.
-
Using the administrative account, connect to the Host server and all Satellite servers being removed.
-
Run the following script from the command prompt:
Consolidate_<Instance>.bat > Consolidate_<Instance>.log
-
You can click Start > Run and type %temp% in the Run dialog box to locate the local temp folder.
-
Although not a mandatory part of the consolidation of replicated databases workflow, it is recommended that you run the View Generator on the Model database. The View Generator is delivered to [Product Folder]\Administrator\Core\Tools\Administrator\Bin\ViewGenerator.exe.
-
The reports database is excluded from the consolidation process. Consequently, you must regenerate the reports database. See Regenerate the reports database.
-
After a successful consolidation, the permission groups (and their objects) that were associated to the Satellite locations now belong to the Host location. The consolidated databases now behave as normal, non-replicated databases.