SQLDumper

Dump your MSSQL database into file or stream using F# library or .NET CLI tool.

Using F# library

Installation

If you want to install this package manually, use usual NuGet package command

Install-Package SQLDumper

or using Paket

paket add SQLDumper

Usage

Library is rather simple:

open SQLDumper

SQLDumper.init "myconnectionstring"
|> SQLDumper.useGoStatements true // default
|> SQLDumper.statementsInTransaction 1000 // default
|> SQLDumper.rowsInStatement 100 // default
|> SQLDumper.ignoreTables ["ignore1";"ignore2"] // empty by default
|> MSSQL.dumpToFile "path/to/file.sql"

If you prefer using TextWriter from BCL, you can use MSSQL.dumpToWriter function.

Using .NET CLI tool

Installation

To install .NET tool use this command

dotnet tool install SQLDumper.Tool

Usage

Again, this CLI tool is rather simple:

USAGE:
    sqldump (-h | --help)
    sqldump <connectionstring> <outputfile> [options]

OPTIONS [options]:
    -h --help                          Shows help
    --usego <bool>                     Use GO statements [default: True]
    --statements <number>              Number of statements in transaction [default: 1000]
    --rows <number>                    Number of rows in transaction [default: 100]
    --ignore <tables>                  Tables to ignore when doing SQL dump (use comma for more tables separation)

Kudos 👏

Thanks to @ArtemAvramenko for his SqlDump C# library used as reference project for this library.