Database synchronization serves to keep one or several databases up to date with each other's data changes. Based on pre-created triggers
DBSync tool provides an opportunity to populate Data Warehouses with the most recent changes in near real-time.
Below DBConvert Team would like to present you a new approach of real-time synchronization algorithm developed and implemented in DBSync tools.
It is quite simple and does not require any developer-level technical skills because all preparations are limited by users’ customizations in the program.
Advantages of the trigger-based synchronization mechanism:
Requirements for trigger-based real-time database synchronization
- Effectiveness for large dataset volumes. If you have a large database ( > 2 Gb) you can notice that not the whole record set is processed
during synchronization. The only recently appeared updates would be reflected in your destination database.
- Fast speed synchronization. Processing altered records according to pre-created triggers the tool synchronizes databases in times faster.
Synchronization without triggers for 1,000,000 records database
(Insert/Update/Drop sync options are ON)
Synchronization with active triggers for 1,000,000 records database
The table above shows test results for the time needed for synchronization of a standard normalized database (middle-sized, approximately
for 1,000,000 records) with Insert/Update/Drop records. According to the presented data you can easily admit the significant benefit of
trigger-based instant synchronization feature performed in DBSync products.
- Near real-time synchronization. It became possible due to previous items #1 and #2. We call it this way because the trigger-based sync
system allows running sync sessions as often as you need. If the record was modified you can run sync session immediately (or by Scheduler) and the imported
data will always "win" over the data in the existing record that is being imported into.
- Simple configuration. Even if you have no any programming, engineering or technical education you can easily make the real-time sync system work with the help of sync options available on Customization stage.
- At the moment the trigger-based sync mechanism works only in one direction – from source to destination for one run. Absolutely evident, that if you create service sessions for ‘from destination to source’ case you will be able to synchronize in both directions launching sessions in the needed order.
- You should have direct access to source and to destination database server with privileges for creation triggers and tables.
- Trigger-based synchronization can work only for tables with Primary Key
Once adjusted synchronization sessions with triggers is the guarantee for well-organized system functionality. So, for that we need to enlighten the most important details in the illustrated manual with the purpose to show the exact options need to be activated.
The process of configuration involves 2 general stages and an extra stage for the case when you decide to cancel real-time synching and to clean your source & target databases.
Follow the manual: