Simple database change management
C# PowerShell Pascal Other
Latest commit 15ef33c Mar 18, 2016 @ericdc1 ericdc1 Fix for issue #16
TestData command does not log to db table
[usd_AppliedDatabaseTestDataScript]

README.md

AliaSQL

What is AliaSQL?

AliaSQL is a command line tool for database deployments. It is a drop in replacement for Tarantino with some additional features.

How do I get started?

Check out the getting started guide.

Check out the wiki for some background information.

Read the blog posts here and here.

There is also a C# runner as of version 1.4. Read about it here https://github.com/ClearMeasure/AliaSQL/wiki/C%23-runner

Where can I get it?

First, install NuGet.

We recommend starting with the AliaSQL Kickstarter that creates Create, Update, Everytime, and TestData folders for your SQL scripts and provides a Visual Studio runner. To get started, create an empty C# console app then install AliaSQL.Kickstarter from the package manager console:

PM> Install-Package AliaSQL.Kickstarter

To get the the AliaSQL.exe tool by itself install AliaSQL from the package manager console:

PM> Install-Package AliaSQL

To get the the c# runner install AliaSQL.Core from the package manager console:

PM> Install-Package AliaSQL.Core

The latest compiled version can be found here: https://github.com/ClearMeasure/AliaSQL/raw/master/nuget/content/scripts/AliaSQL.exe

What else needs done?

  • More unit tests need written around Baseline, TestData, Update, and Everytime
  • There are likely some additional things in SQL scripts that will fail when running in a transaction. More detail on this in the getting started guide.