MTS.DBMigrator.SQLServer 1.0.73

dotnet add package MTS.DBMigrator.SQLServer --version 1.0.73
                    
NuGet\Install-Package MTS.DBMigrator.SQLServer -Version 1.0.73
                    
This command is intended to be used within the Package Manager Console in Visual Studio, as it uses the NuGet module's version of Install-Package.
<PackageReference Include="MTS.DBMigrator.SQLServer" Version="1.0.73" />
                    
For projects that support PackageReference, copy this XML node into the project file to reference the package.
<PackageVersion Include="MTS.DBMigrator.SQLServer" Version="1.0.73" />
                    
Directory.Packages.props
<PackageReference Include="MTS.DBMigrator.SQLServer" />
                    
Project file
For projects that support Central Package Management (CPM), copy this XML node into the solution Directory.Packages.props file to version the package.
paket add MTS.DBMigrator.SQLServer --version 1.0.73
                    
#r "nuget: MTS.DBMigrator.SQLServer, 1.0.73"
                    
#r directive can be used in F# Interactive and Polyglot Notebooks. Copy this into the interactive tool or source code of the script to reference the package.
#:package MTS.DBMigrator.SQLServer@1.0.73
                    
#:package directive can be used in C# file-based apps starting in .NET 10 preview 4. Copy this into a .cs file before any lines of code to reference the package.
#addin nuget:?package=MTS.DBMigrator.SQLServer&version=1.0.73
                    
Install as a Cake Addin
#tool nuget:?package=MTS.DBMigrator.SQLServer&version=1.0.73
                    
Install as a Cake Tool

MTS.DBMigrator.SQLServer

SQL Server implementation of the MTS migration abstractions, targeting .NET 8, 9, and 10. Uses Microsoft.Data.SqlClient and SQL Management Objects (SMO).

Install

dotnet add package MTS.DBMigrator.SQLServer

Usage

Define migrations derived from MigrationBase<TContext>, then supply a context, migration collection, and logger:

using MTS.DBMigrator.Abstractions;
using MTS.DBMigrator.SQLServer;

var context = new MigrationContext
{
    ConnectionString = connectionString,
    Assembly = typeof(Program).Assembly
};
var migrator = new Migrator<MigrationContext>(context, migrations, logger);
await migrator.ExecuteMigration(cancellationToken);

Construct the migrations using the same context. Eligible scripts run in version order; the runner tracks script IDs, hashes, timestamps, and versions in __DBMigrator, and skips previously recorded IDs. Execution updates the migration status and rethrows failures.

Use an account with permissions to execute the migration SQL and maintain the history table. Migration scripts execute through a separate SMO connection from the history transaction; do not assume all schema changes will roll back with the history transaction.

The package explicitly references a patched System.Security.Cryptography.Pkcs version to override vulnerable transitive versions. Live database execution requires an integration environment and is not covered by the repository's current unit tests.

License

Licensed under the MIT License. See the included LICENSE.txt. Dependencies retain their own licences.

Product Compatible and additional computed target framework versions.
.NET net8.0 is compatible.  net8.0-android was computed.  net8.0-browser was computed.  net8.0-ios was computed.  net8.0-maccatalyst was computed.  net8.0-macos was computed.  net8.0-tvos was computed.  net8.0-windows was computed.  net9.0 is compatible.  net9.0-android was computed.  net9.0-browser was computed.  net9.0-ios was computed.  net9.0-maccatalyst was computed.  net9.0-macos was computed.  net9.0-tvos was computed.  net9.0-windows was computed.  net10.0 is compatible.  net10.0-android was computed.  net10.0-browser was computed.  net10.0-ios was computed.  net10.0-maccatalyst was computed.  net10.0-macos was computed.  net10.0-tvos was computed.  net10.0-windows was computed. 
Compatible target framework(s)
Included target framework(s) (in package)
Learn more about Target Frameworks and .NET Standard.

NuGet packages

This package is not used by any NuGet packages.

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last Updated
1.0.73 86 10/15/2026
1.0.72 86 10/15/2026
1.0.71 144 9/8/2026
1.0.69 129 9/4/2026
1.0.68 119 9/4/2026
1.0.67 131 9/4/2026
1.0.66 130 9/2/2026
1.0.64 117 9/1/2026
1.0.63 142 8/17/2026
1.0.59 157 6/2/2026
1.0.57 144 5/22/2026
1.0.56 144 5/6/2026
1.0.55 136 5/6/2026
1.0.50 322 1/15/2024
1.0.49 255 1/12/2024
1.0.48 283 1/4/2024
1.0.47 253 1/4/2024
1.0.46 321 10/18/2023
1.0.45 222 10/17/2023
1.0.44 285 7/26/2023
Loading failed