Doink.ChangeLog 0.4.0

ChangeLog

Generate liquibase changeLogs for mssql

Features

• Generate liquibase stored procedure changelogs in folder
• Generate seed changelogs from existing tables
• Generate changelog of specific db objects
• Show diff between databases

Limitations and Notes

• This is build for Microsoft SQL Server only for now.
• Not focusing on features like creating changelogs for tables that liquibase is already able to do.

Installation

Install directly from nuget.

dotnet tool install --global Doink.ChangeLog

Update

dotnet tool update --global Doink.ChangeLog

Uninstall

dotnet tool uninstall --global Doink.ChangeLog

How to use

Great now you should have changelog command available.

# Hello World
changelog

# Show all available commands
changelog -h

# Init changeLog.yml file with example sql server connection strings.
changelog init

# Update connection strings with your details. 
# I like to use something like: https://www.aireforge.com/tools/sql-server-connection-string-generator

# Validate connection
changelog validate

# List diff between connections with type User Table
changelog diff -t U

# Generate liquibase changeSet to seed the People table data
changelog seed -n People

# Generate liquibase changeSet for specific item
changelog generate -n storedProcedureName

# Update stored procedures changeSets in folder from database. -d option will make no changes
changelog update -d

# New interactive mode added to select only items you want to change
changelog update -i