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)
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?
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.