Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Cumulative Patches?

Author  Topic 

denis_the_thief
Aged Yak Warrior

596 Posts

Posted - 2011-06-17 : 13:30:58
Does anyone know or have any experience with creating cumulative Patches?

We make Database steps for Releases for things like Table Structure changes, Stored Procedures etc...

We seem to make so many steps (ie scripts) and it is a chore keeping track of which ones were applied where. It would be great if there was some way to create Cumulative Patches.

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-06-17 : 13:45:56
We handle it by versioning the database. So we have a table that contains the version number, and then we have a batch file that knows what scripts to apply based upon the version number. I can't share that batch file with you since it's proprietary, however it's enough to to create one.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

denis_the_thief
Aged Yak Warrior

596 Posts

Posted - 2011-06-17 : 14:03:01
thanks
Go to Top of Page
   

- Advertisement -