Question Locked

MSSQL TRIGGER

0 helpful
1 reply
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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.

1 reply

This discussion is closed to new replies.