none
How to use 2 DataBase at a time and Update simultaneously in two diffrent locations. RRS feed

  • Question

  • Hi !

    I am a web based Software Developer using ASP.NET with C# and SQL2000. I require to install  two databse in diffrent location. It should Update simultaneously.
    • Moved by eryang Wednesday, September 23, 2009 8:26 AM (From:.NET Base Class Library)
    Sunday, September 20, 2009 3:13 PM

Answers

  • Are those databases within same network domain? If yes, you can use Distributed Transaction Coordinator (.NET Enterprise Services) to commit data as single transaction into multiple databases
    Val Mazur (MVP) http://www.xporttools.net
    • Marked as answer by Yichun_Feng Friday, September 25, 2009 2:35 AM
    Wednesday, September 23, 2009 10:41 AM
    Moderator

All replies

  • The easiest would be to set up replicated databases.

    Another easy way to do it is to make the update stored procedures write to the two databases at the same time.
    MCP
    • Proposed as answer by webJose Wednesday, September 23, 2009 4:47 AM
    Sunday, September 20, 2009 4:17 PM
  • Are those databases within same network domain? If yes, you can use Distributed Transaction Coordinator (.NET Enterprise Services) to commit data as single transaction into multiple databases
    Val Mazur (MVP) http://www.xporttools.net
    • Marked as answer by Yichun_Feng Friday, September 25, 2009 2:35 AM
    Wednesday, September 23, 2009 10:41 AM
    Moderator