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...


more ▼

asked Jul 30, 2010 at 05:41 AM in Default

avatar image

2 1 1 2

Can you please stop editing your question to bump it. People will offer help if they can, without you insisting that it is urgent.

Aug 03, 2010 at 05:10 AM WilliamD
(comments are locked)
10|1200 characters needed characters left

2 answers: sort voted first

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).

more ▼

answered Jul 30, 2010 at 06:16 AM

avatar image

26.2k 18 38 48

(comments are locked)
10|1200 characters needed characters left

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?

more ▼

answered Aug 02, 2010 at 06:33 AM

avatar image

2 1 1 2

(comments are locked)
10|1200 characters needed characters left
Your answer
toggle preview:

Up to 2 attachments (including images) can be used with a maximum of 524.3 kB each and 1.0 MB total.

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

SQL Server Central

Need long-form SQL discussion? SQLserverCentral.com is the place.



asked: Jul 30, 2010 at 05:41 AM

Seen: 1859 times

Last Updated: Aug 04, 2010 at 11:07 PM

Copyright 2018 Redgate Software. Privacy Policy