June 7, 2011 at 6:33 am
Are there any GREAT Change Management Tools for SQL 2005/2008 R2 ?
With abilities to
Schema change automation, Impact analysis of application upgrades on customizations,
Tracking production and remediation
Oracle has one…how come Microsoft didn’t come up with native CM pack for SQL?
June 7, 2011 at 9:24 am
Visual Studio 2010 Team System (VSTS includes Visual Studio and Team Foundation Server) is Microsoft's CM offering but their approach is a bit different from Oracle's. VS 2010 can take a snapshot of an existing database schema and model it as an XML file. That XML model can then be versioned in TFS and used to compare against a database to to generate a diff/change script that you can then deploy.
VSTS is not free though, exactly the opposite, it is very expensive to outfit an entire team, but it has tons of features and tries to encompass the entire SDLC.
For data comparisons I prefer versioning my hand-written DML scripts in any old version control system but if you have the type of shop where that's not an option you can look into something like Red Gate Data Compare to generate change scripts that will push data from one environment to another.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
June 7, 2011 at 9:31 am
Thank you for the info.....
However, it does sound toooooo cumbersome.
All we need is an ability to track schema\option\config changes with all the change detailes
And ability to fall bck to the original state.
June 7, 2011 at 9:47 am
VSTS does what you want...quite easily...but it sounds like you miss Oracle 🙂
Good luck!
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply