Hello !

Does anybody know about a good tool which help maintaining the database of an application ?

I'm working on an application which uses a database (Microsoft Sql Server).

When a development requires to change something in the database (e.g., structure, data migration...), we create a script (Transact-SQL script) and add it into our revision control tool (subversion - that tool also contains our code). Each script must add a line in a log table to keep a trace of all the scripts that have been ran into a database.

In order to build a database for our application, one needs to run all scripts ordered by their creation date.

I'm not really happy with this technique notably because it make application migration a bit hard. If we want to install a new version of the application somewhere, e.g., migrate from version 1.3 to 2.1, we must get all the scripts between these two versions. Then run them and ensure that everything is done in a transaction...

For sure we could built home-made tools to help but I wonder if some tools already exists to do that kind of job.