Results 1 to 2 of 2
  1. #1
    Join Date
    Dec 2001
    Posts
    9

    Unanswered: Syncing DB Structure

    I have 2 databases with corresponding history databases.
    As the system is under development, the 2 databases are changing in structure i.e the table structure(new tables as well as changes to existing ones) and indexes will change every week.
    What is the best solution to replicate the changes on the history database.

    Regards,

    Ashutosh

  2. #2
    Join Date
    Feb 2004
    Location
    In front of the computer
    Posts
    15,579
    Provided Answers: 54
    Backup and restore? Maybe log shipping?

    -PatP

Posting Permissions

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