Database versioning

Do you need to solve database versioning? It could be a big problem – but now here is database versioning of DATADMIN. Except from database versioning you can use it for data admin and data synchronization tasks!

Database versioning - motivation

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 good database versioning, but generally it belongs is one of following category:

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

The first way od database versioning 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.

Database versioning in DatAdmin

DatAdmin helps you with following database versioning tasks:

• 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)

We use this database versioning in our company for several databases (the biggest (on MS SQL) have over 100 versions and about 90 tables, also some views, stored procedures and functions).

Try this product for free, download DATADMIN and than get trial license for database versioning.

Online database versioning tool

JenaSoft published also modern web based database versioning tool, called Online Data Modeler. This powerful tool cooperates with DatAdmin, you can share database models between DatAdmin and Online Data Modeler.