Languages

Database versioning

Database versioning is quite dificult issue, which must be solved in almost every software-development companies. Goal is to maintain synchronization between database structure   There are more ways, how to achieve do this, but generally it belongs is one of following category:

  • one database shared between all developers
  • each developer has his own database

The first way is simplier, but there are lot of problems with synchronization of developers, and when moving database to production environment. Better way is to maintain scripts for updating database, which can each developer run on it's our instance. DatAdmin offers powerful tool, which can help with this task.

This tool can:

  • maintain versioned database model (table and object definitions, table static data)
  • generate upgrade and downgrade scripts
  • generate C# class, which creates and upgrades database (it uses version onformation stored in database)

Database versioning is contained only in Ultimate edition.