Cake.SqlTools

Cake Build addin for executing sql scripts against a database

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

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.