Manages database schema updates by persisting what schema updates occur on the database in a Version table. See https://github.com/mhedgpeth/DatabaseUpgrader for more information on how the utility works.
Windows platforms with SQL Server installed
| Key | Type | Description | Default |
|---|---|---|---|
| ['database_upgrader']['cache_path'] | String | where to cache the database upgrader files | database_upgrader within the chef file cache directory |
| ['database_upgrader']['cache_archive'] | String | where the archive file that contains the DatabaseUpgrader.exe should be copied to | DatabaseUpgrader.zip inside of the cache_path |
| ['database_upgrader']['install_directory'] | String | where the database upgrader should be installed | DatabaseUpgrader inside of the cache_path |
On your application cookbook, use the resource:
include_recipe 'database_upgrader' # to ensure that it's installed
database_upgrader_checked "make sure database is up to date" do
connection_string 'Server=(local);Database=test;Integrated Security=SSPI'
scripts_directory 'C:\\temp\\scripts'
application_version '1.2.3.4'
endAuthor:: Michael Hedgpeth (mhedgpeth@gmail.com)