I have got a SQL application which needs to be merged with a new CRM applicaiton. so data coming into the source tables, then triggers push certain fields into the Staging table with a flag '0' and then CRM application job picks up from staging table and sets the flag to '1'.
same is true if the data for the same field is initiated from the CRM and needs to go into my application.
All well and good.
Now considering 100s of transactions per minute is the above solution workable. i can think of other alternatives like
SIS data replication service broker (limited knowledge) etc