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
<PackageReference Include="MTS.DBMigrator.SQLServer" Version="1.0.73" />
<PackageVersion Include="MTS.DBMigrator.SQLServer" Version="1.0.73" />
<PackageReference Include="MTS.DBMigrator.SQLServer" />
paket add MTS.DBMigrator.SQLServer --version 1.0.73
#r "nuget: MTS.DBMigrator.SQLServer, 1.0.73"
#:package MTS.DBMigrator.SQLServer@1.0.73
#addin nuget:?package=MTS.DBMigrator.SQLServer&version=1.0.73
#tool nuget:?package=MTS.DBMigrator.SQLServer&version=1.0.73
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 | Versions 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. |
-
net10.0
- Microsoft.AspNetCore.Http.Abstractions (>= 2.3.13)
- Microsoft.Data.SqlClient (>= 7.1.1)
- Microsoft.Extensions.DependencyInjection (>= 10.0.13)
- Microsoft.Extensions.Logging.Abstractions (>= 10.0.13)
- Microsoft.SqlServer.SqlManagementObjects (>= 181.37.1)
- MTS.DBMigrator.Abstractions (>= 1.0.73)
- System.Security.Cryptography.Pkcs (>= 10.0.13)
-
net8.0
- Microsoft.AspNetCore.Http.Abstractions (>= 2.3.13)
- Microsoft.Data.SqlClient (>= 7.1.1)
- Microsoft.Extensions.DependencyInjection (>= 10.0.13)
- Microsoft.Extensions.Logging.Abstractions (>= 10.0.13)
- Microsoft.SqlServer.SqlManagementObjects (>= 181.37.1)
- MTS.DBMigrator.Abstractions (>= 1.0.73)
- System.Security.Cryptography.Pkcs (>= 10.0.13)
-
net9.0
- Microsoft.AspNetCore.Http.Abstractions (>= 2.3.13)
- Microsoft.Data.SqlClient (>= 7.1.1)
- Microsoft.Extensions.DependencyInjection (>= 10.0.13)
- Microsoft.Extensions.Logging.Abstractions (>= 10.0.13)
- Microsoft.SqlServer.SqlManagementObjects (>= 181.37.1)
- MTS.DBMigrator.Abstractions (>= 1.0.73)
- System.Security.Cryptography.Pkcs (>= 10.0.13)
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 |