November 25, 2008 at 8:52 am
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
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
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 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply
This website stores cookies on your computer.
These cookies are used to improve your website experience and provide more personalized services to you, both on this website and through other media.
To find out more about the cookies we use, see our Privacy Policy