x

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
more ▼

asked Jul 30 '10 at 05:41 AM in Default

prasoon gravatar image

prasoon
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 '10 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 '10 at 06:16 AM

WilliamD gravatar image

WilliamD
25.8k 17 19 41

(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 '10 at 06:33 AM

prasoon gravatar image

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

New code box

There's a new way to format code on the site - the red speech bubble logo will automatically format T-SQL for you. The original code box is still there for XML, etc. More details here.

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

SQL Server Central

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

Topics:

x1933
x13

asked: Jul 30 '10 at 05:41 AM

Seen: 1352 times

Last Updated: Aug 04 '10 at 11:07 PM