Post reply

Restore from backup and not loose existing objects-any help appreciated!!!

  • November 25, 2008 at 8:52 am

    #124975

    I have an issue when restoring a database from a backup.

    I restore production data onto my local machine and run my scripts against the latest data from the backup. But since the production database does not have the stored procedures i am running, i keep having to recreate them all the time.

    Does anyone know of a way to avoid this situation or a workaround?

    Thanks..

  • November 25, 2008 at 9:13 am

    #903218

    Not until you deploy the scripts to production.

    Script the restore along with your procs and make it one thing to run .

  • November 25, 2008 at 10:54 am

    #903315

    Thanks Steve, that seems to be the only option, i have to validate al of what i am doing against "real" data before i can move it into dev or production environments.

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

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