Using Zbit, Inc's Data Replication Engine users can easily replicate one source database to multiple destination databases simultaneously using multiple tables in the source database. Replicator allows duplication between any OLEDB/ODBC compliant databases. Replicator does not use utilities specific to any particular database, instead Replicator issues, select, insert, and update SQL statements against source and target databases, therefore, there is no need for any third party tools to be installed. Before execution, Replicator finds an XML-based settings file on the user's computer to read all the configuration parameters. All queries use transactional operations to keep source and target databases in a consistent state. Replicator utilizes fully customizable queries for source and target databases when executed. At the conclusion of each execution, Replicator produces comprehensive log files with understandable and easy to read statistics giving the user the option of having verbose mode outputs in a log file. Replicator could be scheduled to run periodically using either a Windows scheduler or its internal scheduling mechanism.
|