Sql tools addin for Cake
C# PowerShell Batchfile
Switch branches/tags
Nothing to show
Clone or download
Fetching latest commit…
Cannot retrieve the latest commit at this time.
Permalink
Failed to load latest commit information.
build/scripts
nuspec
src
test
.gitattributes
.gitignore
LICENSE
README.md
ReleaseNotes.md
appveyor.yml
build-skip-restore.bat
build-skip-test.bat
build.bat
build.cake
build.ps1
cake.config

README.md

Cake.SqlTools

Cake Build addin for executing sql scripts against a database

Build status

cakebuild.net

Join the chat at https://gitter.im/cake-build/cake

Table of contents

  1. Implemented functionality
  2. Referencing
  3. Usage
  4. Example
  5. Plays well with
  6. License
  7. Share the love

Implemented functionality

  • Execute a query against a database
  • Contains a provider for MS Sql, MySql and PostgreSQL

Referencing

NuGet Version

Cake.SqlTools is available as a nuget package from the package manager console:

Install-Package Cake.SqlTools

or directly in your build script via a cake addin directive:

#addin "Cake.SqlTools"

Usage

#addin "Cake.SqlTools"

Task("Execute-Sql-Query")
    .Description("Execute a Sql query against a database.")
    .Does(() =>
{
    ExecuteSqlQuery("CREATE DATABASE Test", new SqlQuerySettings()
    {
        Provider = "MsSql",
        ConnectionString = "blah"
    });
});

Task("Execute-Sql-File")
    .Description("Execute a Sql query  against a database, from the contents of a file.")
    .Does(() =>
{
    ExecuteSqlFile("./Scripts/Restore-DB.sql", new SqlQuerySettings()
    {
        Provider = "MsSql",
        ConnectionString = "blah"
    });
});

RunTarget("Execute-Sql-Query");

Example

A complete Cake example can be found here.

TroubleShooting

  • Please be aware of the breaking changes that occurred with the release of Cake v0.22.0, you will need to upgrade Cake in order to use Cake.SqlTools v0.1.0 or above.

Plays well with

If your looking for a way to trigger cake tasks based on windows events or at scheduled intervals then check out CakeBoss.

License

Copyright (c) 2015 - 2016 Phillip Sharpe

Cake.SqlTools is provided as-is under the MIT license. For more information see LICENSE.

Please be aware that MySql.Data uses the GNU public LICENSE.

Share the love

If this project helps you in anyway then please ⭐️ the repository.