-
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 !
Tag Archives: DbUpdater
SQL Azure Notes
My invitation code for SQL Azure CTP finally arrived. I had been waiting for this.
You can create a database in from the SQL Azure Management page, shown above.
After you have created the database, of course, you can use DbUpdater with your SQL Azure databases. Here is the command-line :
DbUpdater.exe ..\SqlScripts /server:”tcp:SERVER.ctp.database.windows.net” /db:DATABASE /user:”USER@SERVER” /password:PASSWORD /confirm:true
And you [...]
Using NHibernate With SQLite in DbUpdater
DbUpdater (version 1.3 onwards) can be used with sqlite3.
Review the files included in DbUpdater-sqlite3.zip
1. DbUpdater.exe.config must be modified. Note changes to the following keys – exe-file, exe-args, dialect, driver_class, connetion_string.
2. SchemaVersion.hbm.xml must be modified. The ‘class’ attributes value for the ‘generator’ of ‘id’ must be changed to ‘identity’. No other changes are needed here.
3. \SqlScripts\schema-version-table.sql [...]
DbUpdater on SourceForge
By popular demand, DbUpdater is now up on the sourceforge. Latest download (v1.2) is now available from there.
Share This
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 [...]
Database Schema Version Control Tool
It is essential to treat database schema as source code and apply all the norms and best practices applicable to it. From what I hear and read, database schema version control is non-existent in too many projects.
Various techniques to accomplish version control of database schemas have been discussed and published. Martin [...]
Posted in C#, database, freeware, sql, version-control Also tagged best practices, change, code, database, database schema, Databases, DBMS, Design, Download, Evolutionary, free tool, MSSQL, NHibernate, process, schema, schema version, SchemaVersionsLog, Scripts, sql, sql scripts, table, tool, version, version control tool, version-control, Versioning 4 Comments
Using DbUpdater with MySql