The Data Replication Engine allows users to replicate multiple tables from a source database to multiple destination databases in real-time, using customized SQL statements. It supports OLEDB/ODBC compliant databases and features logging and scheduling functionalities.
One of the best things about Replicator is that it allows for duplication between any OLEDB/ODBC compliant databases - no need for specific utilities for a particular database. Instead, Replicator relies on issuing SQL statements (select, insert, and update) against both the source and target databases.
And if you're worried about configuring the software, don't be. Before executing, Replicator will find an XML-based settings file on your computer to read all the configuration parameters. This makes things easy and straightforward for the user.
Replicator also utilizes transactional operations in all queries to keep source and target databases in a consistent state. Plus, it offers fully customizable queries for both source and target databases. This means you can tailor your queries to suit your specific needs.
After each execution, Replicator produces comprehensive log files with easy-to-read statistics. And if you want more detailed information, you have the option of verbose mode outputs in a log file.
Finally, Replicator could be scheduled to run periodically using either a Windows scheduler or its internal scheduling mechanism. This makes it easier to manage and automate your data replication tasks. Overall, Replicator is a robust and reliable software that simplifies data replication for users of all levels.
Version 1.0: N/A