Friday, January 20, 2012 3:55 PM
I have a small doubt. I was using Service Broker between two different databases on two different servers. Its working excellent.
My question is if both the databases are on same server and i have servicebroker in both of those databases... is it possible to transfer data from one database to other using this service broker.??
Saturday, January 21, 2012 7:12 PM
I am using SSIS packages to transfer the data between two different databases onn two different servers. I am looking for options to make it Real Time Sync. I am looking into Service Broker. Can you please how you are achieving this and Pros and Cons
Saturday, January 21, 2012 7:34 PM
Please see the link
Please mark answered if I've answered your question and vote for it as helpful to help other user's find a solution quicker
Tuesday, January 24, 2012 8:39 AMHow would you detect the changes happended in one database and send those changes/messages to the other database? Can you please elaborate?
Wednesday, February 01, 2012 3:10 PM
I tried this couple of months back.we used the service brokers for two databases on the same server.there should not be any problem.
Vinay Valeti| If you think my suggestion is useful, please rate it as helpful. If it has helped you to resolve the problem, please Mark it as Answer