dotnet-db-migrate 2.2.2

dotnet tool install --global dotnet-db-migrate --version 2.2.2
This package contains a .NET tool you can call from the shell/command line.
dotnet new tool-manifest # if you are setting up this repo
dotnet tool install --local dotnet-db-migrate --version 2.2.2
This package contains a .NET tool you can call from the shell/command line.
#tool dotnet:?package=dotnet-db-migrate&version=2.2.2
The NuGet Team does not provide support for this client. Please contact its maintainers for support.
nuke :add-package dotnet-db-migrate --version 2.2.2
The NuGet Team does not provide support for this client. Please contact its maintainers for support.

Pier 8 DB Tools

Build Status NuGet

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

Contributing

This is an open-source project. I request your participation through issues and pull requests!

License

dotnet-db-migrate is licensed under MIT. Refer to LICENSE for more information.

There are no supported framework assets in this package.

Learn more about Target Frameworks and .NET Standard.

This package has no dependencies.

Version Downloads Last updated
2.2.2 135 11/9/2021
2.2.1 126 11/9/2021
2.2.0 131 11/9/2021
2.1.0 318 5/20/2020
1.0.0 610 9/13/2018