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