DbUpdater

Version Aware Database Schema Deployment

Download : DbUpdater v 1.4 (License:GNU General Public License version 3 (GPLv3))

Copyright © 2008 : Ash Tewari
www.tewari.info

DbUpdater is a free tool that
helps you implement the database schema version control system
described by K. Scott Allen in this set of articles :

Three rules for database work
The Baseline
Change Scripts
Views, Stored Procedures and the Like
Branching and Merging

Usage :

First read the articles listed above. The file prefix for change
scripts is “db”, by default. You can change it in the config file.
DbUpdater supports the baseline script as well as post-scripts.
Make sure the database you are going to put under version control is already created.
Specify the connection string in the DbUpdater.exe.config file. Use the connection_string parameter.
You can use %ServerName%, %DbName%, %UserName% and %Password%
place-holders. You will specify the values for these in the commandline
parameters of DbUpdater.exe.
Make sure that the “exe-file” value in the config file is pointing to the program you want to use to execute sql scripts.
Use “exe-args” value to specify commandline parameters for the
program specified in “exe-file”. %SqlFile% placeholder will be used at
runtime to pass the sql script file to the program.
Here is a sample commandline to run DbUpdater – DbUpdater.exe SqlScripts /server:(local)\SQLEXPRESS /db:TestDb /confirm:true. “SqlScripts” is the name of the folder where the change scripts are placed (relative to the current directory).
To test drive the program create a database named “TestDb” in the “(local)\SQLExpress” instance and use the included sample-command-line.bat to run DbUpdater. Review the contents of included “SqlScripts” folder.

SQLite is now supported in DbUpdater (from version 1.3 onwards). See this post for details – using-nhibernate-with-sqlite-in-dbupdater .

Other Resources :

Evolutionary Database Design

Bulletproff Sql Change Scripts Using INFORMATION_SCHEMA Views

–

Related posts

My name is Ash Tewari. I have been developing software for over 10 years. I enjoy interacting with the members of software development community and very interested in sharing perspectives and insights with others. In my free time, I like to experiment with new tools, techniques, technology and concepts. In the process, I sometimes create something useful too !
Pages
Recent Posts
Recent Comments
- Banana Scrum Tool on Scrum Tools
- Maxim Antonov on Database Schema Version Control Tool
- Chipeau on Scrum Tools
- Scrum Software on Scrum Tools
- vik on WPF – LINQ to SQL Sample
- tremeur balbous on Scrum Tools
- sezam20 on Scrum Tools
- Scrum Tool on Scrum Tools
- BhaaL on ReSharper vs CodeRush + Refactor Pro
- tewari on Using NHibernate With SQLite in DbUpdater
- Using DbUpdater with MySql on DbUpdater
- tewari on Using NHibernate With SQLite in DbUpdater
- David Ridgway on ReSharper vs CodeRush + Refactor Pro
- Adam Feldman on Scrum Tools
- Pranay on Using NHibernate With SQLite in DbUpdater

DbUpdater

Version-aware sql schema deployment : DbUpdater (sql server, mysql, sqlite, oracle and more ...) FREE !
Topics

.NET AdventureWorks C# career change code CodeCamp Comparison control database DataBinding DbUpdater demo Download free tool job LINQ ListView log4net mapping MSSQL mvvm NHibernate output path presentation RollingFileAppender sample scrum Share Silverlight sql startup directory SVN tips tool Tools TortoiseSVN version-control Windows WPF WPF-LINQ xaml xml xpath xslt
Categories
- AOP
- blog
- books
- C#
- career
- career advice
- code
- database
- freeware
- Kids
- LINQ
- log4net
- Notes
- opensource
- plugin
- psychology
- sql
- tips
- Uncategorized
- version-control
- wordpress
- WPF
- xaml
Archives
Search

Twitter Updates
follow me on Twitter
Notes

Using DbUpdater with MySql
DbUpdater can be used with mysql. Here are the files you need to jumpstart the integration – DbUpdater-MySql.zip 1. You might need to change the path to mysql.exe in mysql-exec.bat. 2. Modify values in mysql-sample-command-line.bat. Make sure mysql.data.dll is placed in GAC or in the same directory as DbUpdater.exe. Connector binaries can be downloaded from here - http://dev.mysql.com/downloads/connector/net/6.1.html (0)

Online Backup Solution
Finalized online backup solution : JungleDisk. I can run it on all of my machines without paying extra. I get to keep the ownership of my data – by using my own Amazon S3 storage. Backed up all family photos – all 30 GBs. Feeling good (0)

Switched to Thematic
I have switched to Thematic theme on this blog over the weekend. I created a child theme after playing around with the customization hooks. I added a widgetized area below main asides, did some css modifications and created a three column, flexible layout just the way I wanted. I am so glad I switched to Thematic. ThemeShaper forums are very helpful. These articles were just what I needed to get started : How to make a child theme for WordPress and How I used a WordPress Child Theme To Redesign My Blog. (0)
BookShelf
Planned books:
- ASP.NET MVC in Action by Jeffrey Palermo, Ben Scheirman, Jimmy Bogard
Current books:
- Pragmatic Thinking and Learning: Refactor Your Wetware (Pragmatic Programmers) by Andy Hunt
- Working Effectively with Legacy Code by Michael Feathers
Recent books:
- How I Got Published: Famous Authors Tell You in Their Own Words by Ray White
- Pro WPF: Windows Presentation Foundation in .NET 3.0 by Matthew MacDonald
- Programming Windows Presentation Foundation by Chris Sells, Ian Griffiths
- Advanced MVVM by Josh Smith
View full Library

Close

Social Web
E-mail