Re: MySQL insert/update to SQL Server

[Peter Brawley]

The simplest way to do that in MySQL might be ...

1, have a MySQL export table, say

mysqlexports(id int unsigned primary key auto_increment, ts timestamp, targettable char(64), xmlcode text )

2, for each table for which you need to do this, write a Trigger that populates mysqlexports

3, write an app or a SQL Server Integration script to grab those xml blocks and do with them what needs to be done.