Databator v0.1 is available

by Vlad 9. February 2010 11:47

Databator is a tool I’m working on that enables you to manage the versioning of your database based on the method described here.

This first version allows you to:

  • Create an project for a new or existing database
  • Add versioned changes to the database
  • Use command line scripts to update, backup or restore the database (handy for Continuous Integration builds)
  • Conciliate your changes with those made by tour team mates
  • Work in branches and then merge your changes

The final scope of this tool will include:

  • Integration with SVN
  • Synchronization with Visual Studio Database projects (.dbp)
  • Apply or Rollback your updates directly from the UI
  • History for each DB Object (just like code files)
  • Helpers for creating update scripts (specific cases)
  • Automatic rollback script generation (specific cases)

I recommend that you check the Getting Started Guide to get an idea about how this tool can help you optimize your database versioning.

You can download Databator v0.1 from here: Databator0.1.zip (982.01 kb)

Tags: , ,
Categories: Databator | SQL
E-mail | Kick it! | DZone it! | del.icio.us
Permalink | Comments (3) | Post RSSRSS comment feed

Comments

Victor Grigoriu
Victor Grigoriu Romania on 2/10/2010 1:44:30 AM

Cu ce baze de date știe să lucreze scula asta a matale? Ar putea, să zicem, să scrie niște tabele cu aceeași structură și în SQL CE și în SQL 2008?

Vladimir Horbovanu
Vladimir Horbovanu Mexico on 2/10/2010 5:36:32 PM

I've used the versioning method with SQL 2000, 2005 and 2008 so far.
For SQL 2000, there are slight differences in the scripts (.sql and .bat), for compatibility reasons - I could include a target database version in the tool.
I haven't used SQL CE - but I see you can run scripts with something similar to sqlcmd - http://sqlcecmd.codeplex.com/ - so with the appropriate command line scripts it should work.
You probably will have to keep separate backups though (i.e. a SQL 2008 backup cannot be used to restore a SQL 2000 database).
In all cases, the change scripts that you add must be compatible with the target database - it works fine for backward compatible versions like 2005 vs 2000.

trackback
Geek # on 7/29/2010 9:19:44 PM

VS 2010 Database projects - treat your database as code

VS 2010 Database projects - treat your database as code

Add comment




  Country flag

biuquote
  • Comment
  • Preview
Loading