Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Data Transfer between two Databases

Unanswered Data Transfer between two Databases

  • Friday, January 20, 2012 3:55 PM
     
     
    Sign In to Vote
    1

    Hello Friends,

     

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

     

All Replies

  • Saturday, January 21, 2012 7:12 PM
     
     
    Sign In to Vote
    0

    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

    Thank you

     
  • Saturday, January 21, 2012 7:34 PM
     
     
    Sign In to Vote
    0

    yes..

    Please see the link

    http://msdn.microsoft.com/en-us/library/bb839483.aspx

    VT

    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 AM
     
     
    Sign In to Vote
    0
    How 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
     
     
    Sign In to Vote
    0

    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