Simple database change management
C# PowerShell Pascal Other
Pull request Compare This branch is even with ClearMeasure:master.
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
images
lib
nuget
source
.gitignore
README.md
build.bat
build_and_package.bat
database-diff.bat
database-rebuild.bat
database-testdata.bat
database-update.bat
default.ps1
license.txt
open_solution.bat
schema_compare.ps1

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.