SqlDump

Simple SQL Server database dumper. Shipped as source-only NuGet package.

Installing

• Package Manager: Install-Package SqlDump.Sources
• .NET command line: dotnet add package SqlDump.Sources

Example

private void GenerateBackupScript(string connectionString, string outputFile)
{
    var dumper = new SqlDumper.Dumper(connectionString);
    dumper.IgnoredTableNames = new[] { "__EFMigrationsHistory", "sysdiagrams" };
    using (var writer = File.CreateText(outputFile))
    {
        dumper.Dump(writer);
    }
}

See result

Options

Property	Type	Default Value	Note
StatementsInTransaction	int	1000	0 - do not use BEGIN TRANSACTION
RowsInStatement	int	100	1 - separate INSERT for each row of data
UseGoStatements	bool	true	true - add GO after each 'COMMIT' (after each INSERT, if transactions are not explicitly used)
IgnoredTableNames	string[]?	null	List of tables that will not be included in the dump

Support for sql_variant type

Support for the sql_variant type is still very limited and requires setting the RowsInStatement to 1.

Lecacy System.Data.SqlClient

Add SQL_CLIENT_LEGACY to project defines.

ProgressChanged Event

    dumper.ProgressChanged += (sender, e) =>
    {
        if (e.RowsDumped == 0)
        {
            logWriter.WriteLine($"Dumping {e.SchemaName}.{e.TableName}...");
        }
        if (e.RowsDumped > 0 && (e.IsCompleted || e.RowsDumped % 10000 == 0))
        {
            logWriter.WriteLine($"{e.RowsDumped} rows dumped...");
        }
        if (e.IsCompleted)
        {
            logWriter.WriteLine($"The table {e.SchemaName}.{e.TableName} has been dumped");
        }
    };