SQL Server 2005, real Time Data Integration using Service Broker... PLEASE HELP
Hi All, I want to transfer the data from one Database "A" to another Database "B" (both are on different servers). such that only new data inserted/modified, should transfer. Data will always transfer in one direction. from A to B. **NOTE :** 1) Both Databases are of SQL 2005, 2) i can not change the schema of Database A (from where data will come) 3) i can not use Triggers. **MY Findings Till Now :** After going through various sites I found that in SQL 2008 we can use "Change tracking" mechanism with "Service Broker". But this is not possible with SQL 2005. Whereas in SQL 2005, we can implement "Service Broker" with "Event Notification". (I dont know whether it is correct way or not). I prefer using Service broker as i want to implement something that is asynchronous... Please help me out if any of you has implemented such solution... Thanks
Can you please stop editing your question to bump it. People will offer help if they can, without you insisting that it is urgent.
Have you looked at Replication? This may be a more viable and easier technology to setup than Service Broker and or Notification (which has been dropped from SQL 2008).
No we can not go for replication.... Other thing is using Triggers through a linked server, but the problem is that frequently fails... Do you have any Idea of doing Track Changes (one we do in SQL 2008) in SQL 2005?
