-
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 !
Category Archives: sql
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 [...]
Also posted in code, database, opensource Tagged database, DbUpdater, sql, sqlite NHibernate 8 Comments
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 [...]
Also posted in C#, database, freeware, version-control Tagged best practices, change, code, database, database schema, Databases, DBMS, DbUpdater, 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