Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Sync
- Thread starter digatle
- Start date
I'm sure there is a dirty way of doing it. Maybe a trigger on the MS SQL table that writes out, to a text file?, the type of action, ie. Add/Del/Update that occured on the table along w/ the data elements that were added/updated. Then the MySQL could pick that file up and process the change to its table.
I do not believe there is a connection type for processing transaction from a SQL Server DB to a MySQL DB. But I may be mistaken.
Thanks
J. Kusch
I do not believe there is a connection type for processing transaction from a SQL Server DB to a MySQL DB. But I may be mistaken.
Thanks
J. Kusch
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question