See the version list below for details.
dotnet tool install --global dbup-cli --version 1.1.0
dotnet new tool-manifest # if you are setting up this repo dotnet tool install --local dbup-cli --version 1.1.0
nuke :add-package dbup-cli --version 1.1.0
DbUp Command Line Interface
This project is inspired and based on DbUp project. This is how the project is described by its authors:
DbUp is a .NET library that helps you to deploy changes to SQL Server databases. It tracks which SQL scripts have been run already, and runs the change scripts that are needed to get your database up to date. from official documentation
And it does exactly that and does it well, except that it supports not only SQL Server, but some other databases too. This is a great project that helps you a lot when you want to deploy database changes to your server and you are a developer. Because it is mere a library and this is your responsibility to create an exe to run it. Of course, you can use PowerShell, but it is for fans only. Though it is pretty simple but in every new project you have to create a new exe to deploy changes and after fifth project it become little annoying.
However, what if you are not a developer? Or you are a lazy developer who don't want to do the same thing in every new project? You can use DbUp-CLI that is already do it.
The tool has almost all the features the DbUp has, but without a single line of code, so I do not list them here, just the features of the tool itself.
- Almost all of the DbUp features
- Cross platform (dotnet core needed)
- Easy to install - can be installed as dotnet global tool
- Minimum command line options
- Uses a configuration file to store deploy options, so you can put it along with your SQL scripts under your favorite source control system
- Uses YAML format for configuration file to improve human readability
- Quick start:
- Creates a configuration file with default options for you
- Default configuration is suitable for the most cases, so you should set only a connection string to your database to run the first migration
- The configuration file contains all options with default values and brief explanation
- Getting Started
- Configuration File
- Command Line Options Reference
- Original DbUp Documentation
- MS SQL Server
- 2019-04-11 - 1.1.0 - PostgreSQL support
- 2019-03-25 - 1.0.1 - Initial version (DbUp 4.2)
|Product||Versions Compatible and additional computed target framework versions.|
|.NET||net5.0 was computed. net5.0-windows was computed. net6.0 was computed. net6.0-android was computed. net6.0-ios was computed. net6.0-maccatalyst was computed. net6.0-macos was computed. net6.0-tvos was computed. net6.0-windows was computed. net7.0 was computed. net7.0-android was computed. net7.0-ios was computed. net7.0-maccatalyst was computed. net7.0-macos was computed. net7.0-tvos was computed. net7.0-windows was computed.|
|.NET Core||netcoreapp2.1 is compatible. netcoreapp2.2 was computed. netcoreapp3.0 was computed. netcoreapp3.1 was computed.|
This package has no dependencies.
1.1.0 PostgreSQL support
1.0.1 Initial version (DbUp 4.2)