I have a MSSQL database linked to a remote MySQL database. I have a few tables that I needed to be keep updated. The sync only goes one way from MSSQL >> MYSQL.
I need to set it up so that when a record is either deleted, updated or inserted into those tables in MSSQL the same is done in the table on MYSQL.
I would like to use a trigger, so it becomes a real-time sync.
Anyone got any suggestions or help?
SPECIFICS
I can access the MySQL db via OPENQUERY(PORTAL,’SELECT * FROM ContactBase;’)
the table in both databases is ContactBase.
