Results 1 to 2 of 2
  1. #1
    Join Date
    Apr 2012

    Lightbulb Unanswered: Export Import Script

    I would like export db "A" into db "B",

    I would like to run it at late night automatically, is thr any procedure or script for the same?????


  2. #2
    Join Date
    Feb 2004
    In front of the computer
    Provided Answers: 54
    The answer is the ever popular "it depends". If you do a nightly backup of "A", I'd suggest that you restore the backup into "B" and call it good. If the databases are on the same server, there isn't even any cleanup after the restore. If the databases are on different servers, then you need to fix any issues with credentials (logins, users, etc).

    In theory, theory and practice are identical. In practice, theory and practice are unrelated.

Posting Permissions

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