metadata backup

  • Hi

    Our database is backed up everynight. If the current database is modified (constraints,table definitions etc) is it possible to just refresh the metadata (constraints , table definitions) only from backup with out touching the data.

    If yes how can this be done.

    Thanks

  • No

  • Michael Valentine Jones (10/16/2009)


    No

    Well, not quite true - download SQL Compare Professional (Redgate). You can then use the backup file to perform a schema comparison and use the script generated to update (synchronize) between the backup file and your database.

    Or, just do the comparison between the two databases and synchronize that way.

    If for whatever reason you don't want to use Redgate's tools, then you could look at the tools provided by ApexSQL or Quest.

    But, if you want something native - then Michael's answer is absolutely true 😀

    Jeffrey Williams
    “We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

    ― Charles R. Swindoll

    How to post questions to get better answers faster
    Managing Transaction Logs

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply