|
Cetros RPL-scribe
RPL-scribe is more than a resource for performing replication with Oracle. It offers reduced cost when compared with Oracle RAC, offers zero-fail over and version flexibility between differing versions of server operating systems.
RPL-scribe does not need to connect to a database in order to generate its scripts, therefore it can be much faster than Oracle Replication Manager. Each folder tab pops into view instantly—even on slower computers. Scripts can be generated on your laptop even if you aren’t connected to the database server. Executing the scripts generated by RPL-scribe is also much faster than pointing and clicking your way through the Replication Manager interface to set up a typical replication environment.
As an example, it would take approximately eight hours of pointing and clicking your way through the Replication Manager interface to setup replication for approximately eighty tables within ten replication groups. This was the time required adding each group, adding each table and adding a minimum of two conflict resolution methods for each table. It would take more than three days to write scripts manually to perform these same tasks (not counting debugging time to resolve typographic errors). It takes between one and two hours to enter the initial configuration into RPL-scribe for these same eighty tables. It will take RPL-scribe a few seconds to generate the output files. You can then save your configuration so that you never have to reenter it again. Future incremental updates are as simple as reloading the previously saved configuration file, changing the information, then pressing the Generate button to regenerate the scripts. The updated configuration information can be saved to a file with a slightly different name in order to maintain historical documentation. Once the scripts have been generated it will take roughly twenty to thirty minutes to run these scripts on the database servers with the largest part of this time required for the task of generating replication support for the tables.
The application creates replication setup and removal scripts during the script generation process. The removal scripts can be especially helpful if major schema changes are required by developers. The replication configuration can be removed, schema changes made, tables added, then a new set of setup scripts can be generated by RPL-scribe accounting for the schema differences. Use of the actual scripts does not require a high bandwidth network connection to the server as would be required with a completely graphical process.
|
Cetros Products 
