December 21, 2011 at 8:29 am
Is there a better way to manage any schema changes like updates to table definition etc that happen on weekly basis, so that we can sych them up with Prod and maintain a regular up to date Database Schema script in case of Restore. I am not talking about Backing up database for restore but only the Database Schema Script maintenance.
December 21, 2011 at 8:55 am
Try something like Team Foundation Server; or any of the other source control versions out there. They're invaluable.
_____________________________________________________________________
Disclaimer - The opinions expressed by the mouth are not necessarily those of the brain
December 21, 2011 at 9:00 am
You can also use something like RedGate's Datbase Compare to compare schema differences and script the changes. There are competing products that do the same thing.
Those are very valuable when it comes to migrating changes from Dev to Test, Test to QA, and QA to Prod (or whatever sequence your shop uses).
- 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
December 21, 2011 at 12:13 pm
I explored Red Gate. My concern is more about how to maintain a proper sequence of scripts ...what goes when... if we have many drop columns and add columns its hard to maintain the sequence of the scripts to be run in case of restore.
December 21, 2011 at 12:28 pm
WangcChiKaBastar (12/21/2011)
I explored Red Gate. My concern is more about how to maintain a proper sequence of scripts ...what goes when... if we have many drop columns and add columns its hard to maintain the sequence of the scripts to be run in case of restore.
For that, I maintain a DDL trigger that captures any object modifications in the database. Log them in sequence, and you can query then in sequence to build a sequential list of DDL scripts to run.
- 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
Viewing 5 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply