June 26, 2008 at 11:56 am
For the various SQL 2005 databases that I have to wrangle with, some of them require that I perform refreshes of data from Production to Development. In the past, I typically just restore a backup from Production to Development.
The problem comes about when I am working on changes to tables, adding new tables, and adding new fields in Development.
Thoughts on if replication (snapshot) would be the best choice?
Both servers are 2005.
June 26, 2008 at 12:59 pm
I don't think replication will work if you start making changes to the target database. I could be wrong about that, but I'm pretty sure it doesn't really allow that.
When you're making changes to a dev copy of the database, you should have a script that can make all your changes for you. That way, you keep the script, restore a fresh copy from production to dev, run the script, and you're ready to go with fresh data. That's how I always do it, anyway.
That way, when you're ready to push all the changes out to production, you should be able to just run that same script on the production database, and be good to go (after doing the usual backups, and making sure you have an undo script, etc.).
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
June 26, 2008 at 1:13 pm
So do you use a restore as well then run your scripts from DDL statements after the restore?
June 26, 2008 at 2:21 pm
Yes. Save the script, restore the production database to the dev environment, run the script on it. Up-to-date data, and if the script fails to run correctly, then you know it will fail in the move from dev to production before you try doing that.
- Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
Property of The Thread
"Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon
June 26, 2008 at 2:25 pm
Excellent.
Thank you.
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply