Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
Author |
Topic |
hakansukar
Starting Member
2 Posts |
Posted - 2014-08-19 : 09:56:13
|
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 likeSIS data replication service broker (limited knowledge) etc |
|
tkizer
Almighty SQL Goddess
38200 Posts |
Posted - 2014-08-19 : 12:41:48
|
I would recommend transactional replication if the data changes were needed in another database. Since they are local, triggers should be fine.Tara KizerSQL Server MVP since 2007http://weblogs.sqlteam.com/tarad/ |
|
|
|
|
|