Results 1 to 6 of 6
  1. #1
    Join Date
    Aug 2004
    Location
    STL
    Posts
    45

    Unanswered: Keeping 2 DBs in 'synch'

    Hi all, here are my goals: Have the same DB on two different stand-alone computers, and keep them up-to-date from each other.

    Basically a user would input to a DB for a week. Then every week or two, update the other stand alone DB with the new input. The DB would be exactly the same.

    What are my options for this? I'd like it as easy as possible! Are there any software packages that deal with this type of transfer, etc.? Thank you!

  2. #2
    Join Date
    Nov 2004
    Location
    on the wrong server
    Posts
    8,835
    Provided Answers: 6
    Replication but this can get complicated depending on your scenario.

    Is there any data entry going on with the second server or is it just standby or back up?

    If the data entry is only happening on one server you can set up a simple snapshot replication scheme or you can push the data over using data transformation services and there is a somewhat flexible wizard for this.

    Again, you are only doing data entry at one end you can always run a backup from one DB and restore to another.

    If however you are doing data entry on both ends, merge replication is the way to go.

    And finally in the SQL Server 2005 beta there is something called database mirroring which keeps two SQL Servers in sync by taking a snapshot and applying the trans log from one to the other and the copy monitors the production server and if it goes down your mirrored server picks right up where the production server left off.

    many options. much to ponder.
    “If one brings so much courage to this world the world has to kill them or break them, so of course it kills them. The world breaks every one and afterward many are strong at the broken places. But those that will not break it kills. It kills the very good and the very gentle and the very brave impartially. If you are none of these you can be sure it will kill you too but there will be no special hurry.” Earnest Hemingway, A Farewell To Arms.

  3. #3
    Join Date
    Aug 2004
    Location
    STL
    Posts
    45
    Thank you for your insight.

    Yes, only one DB would be used for entry, the other for 'backup' and viewing. Maybe what would be best, is what would be easiest for a advanced end user to operate? (As in, running/backing and transferring the data atleast to us)

    .... or if I could automate some of these tasks in vb.net 03 ?...

  4. #4
    Join Date
    Nov 2004
    Location
    on the wrong server
    Posts
    8,835
    Provided Answers: 6
    Replication you can make run automatically and forever by setting the subscription to never expire. No one would have to do anything until something changed.

    Data Tansformation Services you can also schedule as a job to run automatically and this may be easier to set up and trouble shoot than replication.

    Don't do the backup and restore. Requires certain rights an end user should'nt have and I would let an end user do any of this stuff.

    If you do not want to make it automatic I have some VB6 code that fires off DTS without using the command shell. Sorry I do not have the .Net for it. STill stuck in the stone ages.
    “If one brings so much courage to this world the world has to kill them or break them, so of course it kills them. The world breaks every one and afterward many are strong at the broken places. But those that will not break it kills. It kills the very good and the very gentle and the very brave impartially. If you are none of these you can be sure it will kill you too but there will be no special hurry.” Earnest Hemingway, A Farewell To Arms.

  5. #5
    Join Date
    Jun 2003
    Location
    Ohio
    Posts
    12,592
    Provided Answers: 1
    An automated backup and restore is probably easiest to implement and manage, considering your limited requirements.
    If it's not practically useful, then it's practically useless.

    blindman
    www.chess.com: "sqlblindman"
    www.LobsterShot.blogspot.com

  6. #6
    Join Date
    Aug 2004
    Location
    STL
    Posts
    45
    Thanks again for the information.

    Are there some good examples, guides, etc. to get me started on an automated backup and restore method? I'm not sure where to begin!!!

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •