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

  • different instance or just a different database in the same instance? – James Anderson Aug 19 '14 at 13:54
  • Have you considered putting them in the same instance? Does the data really need to be redundant? – Aaron Bertrand Aug 19 '14 at 13:58
  • so i have got a web based application and the CRM applicaiton both have separate schemas but some data fields needs to be integrated – Hakan Zim Aug 19 '14 at 14:06
  • And you cant move the web app DB to the CRM instance? I understand if there is some invalidation of support issue but it would be much better as you wouldn't need to use linked servers to communicate between the instances – James Anderson Aug 19 '14 at 14:11
  • Sorry i misunderstood your question it is the same instance but different database – Hakan Zim Aug 19 '14 at 14:18

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.