Database Upgrade Manager - OverviewDuring a recent project there arose an ongoing need for rolling out updates to the database structure and stored procedures as client demands changed and evolved. An easy method of getting these updates out to clients was required without the need to create and test an executable for each update.Some of the stored procedures contained valuable IP - sending the scripts out as clear text presented an increased risk (an ambitious DBA can extract the clear text version of encrypted stored procedures and functions from SQL Server - however that does require intent and they are covered by copyright and license agreement at that stage). The Database Upgrade Manager allows the application name, version and default database name to be specified in a configuration file. An XML file is used to manage the scripts that are to be run. The scripts can be grouped into database transactions - this allows, for example, a block of scripts to be run based on a configuration option, where the first script in the block checks the configuration option and if not configured fails the transaction. Processing can then continue at the next transaction block. Configuration Details Version History Download Technical RequirementsThe Database Upgrade Manager requires .NET 2.0 or higher to be installed and works against a SQL Server 2005 or 2008 database.The freeware version does not support encryption of the scripts and requires the XML script control file to be manually created. For more information, support or to request enhancements please email info@equinoxsoftware.co.nz Screen Shots 
|
