Repgen

Repgen generates the scripts required to setup and monitor an Oracle 8i/9i database Advanced Replication installation. The implementation of primary key, replication triggers and multiple conflict resolution methods is included. Licensed customers of Repgen Enterprise Edition receive source code and the ability to make site-specific customization of the generated files via an external module.

Free demo available for Windows, Solaris, Linux and MacOSX.

You don't have to be the world's greatest expert on Advanced Replication in order to implement and maintain a high quality and reliable replication configuration. Repgen incorporates the accumulated knowledge from Oracle?s instructor led training courses, tips, troubleshooting and setup recommendations from Oracle Worldwide Support, and the experience of DBAs who have spent years configuring and maintaining replicated Oracle databases.

Executing the scripts generated by Repgen is also much faster than pointing and clicking your way through the Replication Manager interface to set up a typical replication environment. For example it would take approximately 8 hours of pointing and clicking your way through the Replication Manager interface to setup replication for approximately 80 tables within 10 replication groups. This was the time required adding each group, adding each table, and adding a minimum of 2 conflict resolution methods for each table. It would take approximately 3 days to write scripts manually to perform these same tasks (not counting debugging time to resolve typo errors).

Unlike some DBA tools which transparently send commands directly to the database, Repgen permits the DBA to review and manually update every script prior to executing it on the database server. Additionally, Repgen Enterprise Edition permits the DBA to change the way scripts are generated through adding Perl subroutines to an external module file.