About

This project provides very straightforward and elegant way to keep track on database schema and data changes. There is no need to execute all database scripts each time you are updating a product. You don’t need to re-run all scripts with every update. The project is designed to automatically detect your current version and run only new scripts with no need to re-run all previous. This is a very easy, suitable and fast option that might significantly reduce deployment time, so you don’t need to put additional efforts to update your app and can do it quickly without major impact on your customers.

How to

After package is installed you will find the new folder called Scripts in the solution. There are two files inside the folder: create.sql and update.sql. create.sql contains script that creates empty database and table with database version information. update.sql has dummy example how to write version changes.

Note: Before running the application go to script files preferences and change compile type to Content.

Rules and suggestions for successful versioning

• Each version script should start from: --##23, where 23 is a version number. Version number is incremental.
• It’s prohibited to change script in previouse versions in case it was already used in production or by other developers as these changes will not re-apply to those who already has newer version of database. Write required database changes in the next version.
• New version must have higher number than previouse. Otherwise it will be skipped.
• You can modify create.sql according to current state of database or remove database creation if you want to start versioning existing database but do not touch Version table. It is required to store history of database updates.
• Clear update.sql before start using it and write your own script following the example.

Example

In the application startup on in the installer or whenewer you need you can perform database update like this:

var connectionString = $"Data Source=(local);Initial Catalog={databaseName};Integrated Security=True";
var databaseManager = new DatabaseManager(connectionString);
if (!databaseManager.Exists()) {
    databaseManager.Create();
}
databaseManager.Update();

Enjoy!