dotnet-db-migrate 2.1.0

A .NET Core Global Tool to deploy changes to SQL databases using DbUp.

dotnet tool install --global dotnet-db-migrate --version 2.1.0
This package contains a .NET Core Global Tool you can call from the shell/command line.

A CLI that adds and migrates database migrations for MS SQL and PostgreSQL.

Quick Start

Installation

dotnet tool install -g dotnet-db-migrate

Example Usage

$ dotnet db add-migration "AddContactsTable"
Added migration script ./20200520180400_AddContactsTable.sql

You would then add the SQL for the migration.

eg, for PostgreSQL.

CREATE EXTENSION pgcrypto;
CREATE TABLE contacts(
  id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
  name TEXT,
  email TEXT
);

Then you can execute the migration using the following command,

$ dotnet db migrate "Server=localhost;Port=5432;Database=db-migrate;User Id=postgres;Password=password;" -p psql`
Master ConnectionString => Host=localhost;Port=5432;Database=db-migrate;Username=postgres;Password=********
Created database db-migrate
Beginning database upgrade
Checking whether journal table exists..
Journal table does not exist
Executing Database Server script '20200520180400_AddContactsTable.sql'
Checking whether journal table exists..
Creating the "schemaversions" table
The "schemaversions" table has been created
Upgrade successful

A CLI that adds and migrates database migrations for MS SQL and PostgreSQL.

Quick Start

Installation

dotnet tool install -g dotnet-db-migrate

Example Usage

$ dotnet db add-migration "AddContactsTable"
Added migration script ./20200520180400_AddContactsTable.sql

You would then add the SQL for the migration.

eg, for PostgreSQL.

CREATE EXTENSION pgcrypto;
CREATE TABLE contacts(
  id UUID PRIMARY KEY DEFAULT gen_random_uuid(),
  name TEXT,
  email TEXT
);

Then you can execute the migration using the following command,

$ dotnet db migrate "Server=localhost;Port=5432;Database=db-migrate;User Id=postgres;Password=password;" -p psql`
Master ConnectionString => Host=localhost;Port=5432;Database=db-migrate;Username=postgres;Password=********
Created database db-migrate
Beginning database upgrade
Checking whether journal table exists..
Journal table does not exist
Executing Database Server script '20200520180400_AddContactsTable.sql'
Checking whether journal table exists..
Creating the "schemaversions" table
The "schemaversions" table has been created
Upgrade successful

Dependencies

This package has no dependencies.

Version History

Version Downloads Last updated
2.1.0 132 5/20/2020
1.0.0 375 9/13/2018