Productivity Tools

Tools written by an IT business manager, a passionate developer.

DBUp – to be updated

DBUp is a package which manages database updates. DBUpPT adds additional functionality to DBUp like creating the database and log table.

To use it please reference package with the package manager console

Install-Package DBUpPT

Next create Console application and in the main add following code:

 string serverName = "ServerName";
 string dbName = "DatabaseName";

 DBUp dBUp = new DBUp("gc");
 Assembly assembly = Assembly.GetExecutingAssembly();
 dBUp.PerformUpdate(serverName, dbName, assembly, false)

Next add Scripts Folder and create inside sql scripts which you want to execute. In the properties of the script please select Embedded resource

When application will start, DBUpPT will:

Close Bitnami banner