MSSQL TRIGGER - TechRepublic
Question
August 19, 2008 at 02:45 PM
bigg-media

MSSQL TRIGGER

by bigg-media . Updated 17 years, 11 months ago

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.

This discussion is locked

All Comments