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,
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...
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).
answered Jul 30 '10 at 06:16 AM
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?
answered Aug 02 '10 at 06:33 AM