Triggers in use for real-time database synchronization

Stage II

Triggers in use

When triggers are created and in the source database some changes appeared e.g. some records are inserted/deleted/updated you can perform synchronization run for triggers execution. This basic session will be executed repeatedly for each time when you need to synchronize your databases. Your destination database will be updated based on created triggers and records from

History_store table keeping your source database changes.

When the session is fulfilled History_store table is cleaned. It becomes ready for the next database changes saving.

Configuration for session 2

Sync log should be the following:

		Process started.
		Source database:-- MySQL database --
		Host: 192.168.0.78
		Port: 3306
		User: dmsoft
		Password: Yes
		Database: testSuperBase
		CharSet: utf8
		Use SSH: No
		Use SSL: No

		Destination database:-- MSSQL database --
		Host: 192.168.0.78
		Port: 1433
		User: sa
		Password: Yes
		Database: Test_trigger_1
		CharSet: utf8

		Connecting to the source database.
		Connecting to the destination database.
		Table 'Children' exists. Skipping creation.
		Table 'Cities' exists. Skipping creation.
		Table 'DMSoft' exists. Skipping creation.
		Table 'Jobs' exists. Skipping creation.
		Table 'Students' exists. Skipping creation.
		Synchronizing data in table 'Children'.
		Synchronizing data in table 'Cities'.
		Synchronizing data in table 'DMSoft'.
		Synchronizing data in table 'Jobs'.
		Synchronizing data in table 'Students'.
		Closing connections.
		Process completed successfully.
		Total time elapsed - 00:00:02