DotNetBrightener.DataAccess.DataMigration 2024.0.13.8-preview

This is a prerelease version of DotNetBrightener.DataAccess.DataMigration.
There is a newer version of this package available.
See the version list below for details.
dotnet add package DotNetBrightener.DataAccess.DataMigration --version 2024.0.13.8-preview
                    
NuGet\Install-Package DotNetBrightener.DataAccess.DataMigration -Version 2024.0.13.8-preview
                    
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="DotNetBrightener.DataAccess.DataMigration" Version="2024.0.13.8-preview" />
                    
For projects that support PackageReference, copy this XML node into the project file to reference the package.
<PackageVersion Include="DotNetBrightener.DataAccess.DataMigration" Version="2024.0.13.8-preview" />
                    
Directory.Packages.props
<PackageReference Include="DotNetBrightener.DataAccess.DataMigration" />
                    
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 DotNetBrightener.DataAccess.DataMigration --version 2024.0.13.8-preview
                    
#r "nuget: DotNetBrightener.DataAccess.DataMigration, 2024.0.13.8-preview"
                    
#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 DotNetBrightener.DataAccess.DataMigration@2024.0.13.8-preview
                    
#: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=DotNetBrightener.DataAccess.DataMigration&version=2024.0.13.8-preview&prerelease
                    
Install as a Cake Addin
#tool nuget:?package=DotNetBrightener.DataAccess.DataMigration&version=2024.0.13.8-preview&prerelease
                    
Install as a Cake Tool

Data Migration Library for .NET Core Applications

© 2024 DotNet Brightener

Versions

Package Version
DotNetBrightener.DataAccess.DataMigration NuGet Version
DotNetBrightener.DataAccess.DataMigration.Mssql NuGet Version
DotNetBrightener.DataAccess.DataMigration.PostgreSql NuGet Version
dotnet-dnb-datamigration NuGet Version

Overview

Data Migration Library is a simple library to help you manage your data migration in your .NET Core application. It provides a simple way to define your migration classes and run them in your application.

Not all applications can use DACPAC for managing database schema and data changes. Especially DACPAC does not work with other databases such as MySQL, PostgreSQL, etc. This library is designed to help you manage your data migration in your application.

Installation

Install using Package Reference

dotnet add [YOUR_PROJECT_NAME] package DotNetBrightener.DataAccess.DataMigration

If you need to data migration with SQL Server, install the following package: DotNetBrightener.DataAccess.DataMigration.Mssql

dotnet add [YOUR_PROJECT_NAME] package DotNetBrightener.DataAccess.DataMigration.Mssql

For PostgreSQL, install the following package: DotNetBrightener.DataAccess.DataMigration.PostgreSql

dotnet add [YOUR_PROJECT_NAME] package DotNetBrightener.DataAccess.DataMigration.PostgreSql

Usage

Register to Service Collection
// var _connectionString = "<your_connection_string>";

// If you use SQL Server
services.EnableDataMigrations()
        .UseSqlServer(_connectionString);

// If you use PostgreSQL
services.EnableDataMigrations()
        .UseNpgsql(_connectionString);

// if you want to auto detect all migration classes
services.AutoScanDataMigrators();

// if you want to manually register migration classes
services.AddDataMigrator<MyMigration>();

Define your migration classes

using DotNetBrightener.DataAccess.DataMigration;

[DataMigration("<your_migration_id>")]
public class MyMigration : IDataMigration
{
    // You can use Dependency Injection for injecting your services
    private readonly IMyService _myService;

    public MyMigration(IMyService myService)
    {
        _myService = myService;
    }

    public async Task MigrateData()
    {
        // Your migration code here
        await _myService.DoSomethingToMigrateData();
    }
}

Roadmap

  • Initial Release
  • Add Support for SQL Server
  • Add Support for PostgreSQL
  • CLI tool for creating migration class

CLI Tool

You can now install the cli tool from Nuget: dotnet-dnb-datamigration

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 was computed.  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 was computed.  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 (2)

Showing the top 2 NuGet packages that depend on DotNetBrightener.DataAccess.DataMigration:

Package Downloads
DotNetBrightener.DataAccess.DataMigration.Mssql

Package Description

DotNetBrightener.DataAccess.DataMigration.PostgreSql

Package Description

GitHub repositories

This package is not used by any popular GitHub repositories.

Version Downloads Last Updated
2025.0.6-preview-369 0 8/27/2025
2025.0.6-preview-368 0 8/27/2025
2025.0.6-preview-334 114 8/18/2025
2025.0.6-preview-333 68 7/27/2025
2025.0.6-preview-332 438 7/24/2025
2025.0.6-preview-331 441 7/24/2025
2025.0.6-preview-328 440 7/24/2025
2025.0.6-preview-327 277 7/21/2025
2025.0.6-preview-326 279 7/21/2025
2025.0.6-preview-325 191 7/20/2025
2025.0.6-preview-324 187 7/20/2025
2025.0.6-preview-322 188 7/20/2025
2025.0.6-preview-321 191 7/19/2025
2025.0.6-preview-320 191 7/19/2025
2025.0.6-preview-319 118 7/17/2025
2025.0.6-preview-317 114 7/17/2025
2025.0.6-preview-316 116 7/17/2025
2025.0.6-preview-315 120 7/17/2025
2025.0.6-preview-314 121 7/17/2025
2025.0.6-preview-313 124 7/17/2025
2025.0.6-preview-312 127 7/16/2025
2025.0.5 150 7/10/2025
2025.0.5-preview-307 79 7/5/2025
2025.0.4 77 7/5/2025
2025.0.4-preview-305 84 7/4/2025
2025.0.4-preview-304 145 7/1/2025
2025.0.4-preview-299 124 5/31/2025
2025.0.4-preview-298 106 5/30/2025
2025.0.4-preview-296 142 5/30/2025
2025.0.4-preview-295 153 5/29/2025
2025.0.4-preview-293 154 5/26/2025
2025.0.4-preview-292 152 5/26/2025
2025.0.3 139 2/10/2025
2025.0.3-preview-288 124 2/10/2025
2025.0.2 136 1/21/2025
2025.0.2-preview-278 106 1/21/2025
2025.0.2-preview-277 116 12/16/2024
2025.0.1-rc-243301701 382 11/25/2024
2024.0.14.6 126 11/25/2024
2024.0.14.6-rc-243031001 200 10/29/2024
2024.0.14.6-rc-243030701 120 10/29/2024
2024.0.14.6-rc-242840501 111 10/10/2024
2024.0.14.6-rc-242820305 106 10/8/2024
2024.0.14.6-rc-242771401 204 10/3/2024
2024.0.14.6-rc-242770501 110 10/3/2024
2024.0.14.6-rc-242770201 116 10/3/2024
2024.0.14.6-rc-242761801 110 10/2/2024
2024.0.14.6-rc-242761601 120 10/2/2024
2024.0.14.6-rc-242761501 103 10/2/2024
2024.0.14.6-rc-242761401 117 10/2/2024
2024.0.14.6-rc-242760701 131 10/2/2024
2024.0.14.6-rc-242751002 114 10/1/2024
2024.0.14.6-rc-242750901 128 10/1/2024
2024.0.14.6-rc-242750502 109 10/1/2024
2024.0.14.6-rc-242750201 119 10/1/2024
2024.0.14.6-rc-242741501 108 9/30/2024
2024.0.14.6-rc-242730701 136 9/29/2024
2024.0.14.6-preview-2730501 100 9/29/2024
2024.0.14.6-preview-2701501 145 9/26/2024
2024.0.14.6-preview-2620901 168 9/18/2024
2024.0.14.6-preview-2570701 109 9/13/2024
2024.0.14.6-preview-2510703 180 9/7/2024
2024.0.14.6-preview-2480501 140 9/4/2024
2024.0.14.6-preview-2430401 151 8/30/2024
2024.0.14.6-preview-242730701 110 9/29/2024
2024.0.14.6-preview-2421703 118 8/29/2024
2024.0.14.6-preview-2421701 118 8/29/2024
2024.0.14.6-preview-2420901 114 8/29/2024
2024.0.14.6-preview-2390101 126 8/26/2024
2024.0.14.6-preview-2381603 142 8/25/2024
2024.0.14.6-preview-2341601 164 8/21/2024
2024.0.14.6-preview-2321602 160 8/20/2024
2024.0.14.6-preview-2190801 182 8/6/2024
2024.0.14.6-preview-2041501 118 7/22/2024
2024.0.14.6-preview-1920603 168 7/10/2024
2024.0.14.6-preview-1920301 143 7/10/2024
2024.0.14.6-preview-1911302 123 7/9/2024
2024.0.14.6-preview-1901001 132 7/8/2024
2024.0.14.6-preview-1900901 118 7/8/2024
2024.0.14.6-preview-1900801 120 7/8/2024
2024.0.14.6-preview-1860304 120 7/4/2024
2024.0.14.5 184 7/1/2024
2024.0.14.5-preview-1811601 131 6/29/2024
2024.0.14.5-preview-1810501 142 6/29/2024
2024.0.14.5-preview-180132 147 6/28/2024
2024.0.14.5-preview-180131 135 6/28/2024
2024.0.14.5-preview-180121 118 6/28/2024
2024.0.14.4 147 6/27/2024
2024.0.14.4-preview-8 128 6/27/2024
2024.0.14.4-preview-7 131 6/27/2024
2024.0.14.3 145 6/21/2024
2024.0.14.1 143 6/6/2024
2024.0.14.1-preview 122 6/6/2024
2024.0.14-preview-1 120 6/6/2024
2024.0.13.8-preview 125 6/6/2024
2024.0.13.1-preview-0146 122 6/6/2024
2024.0.13-preview-1 115 6/6/2024
2024.0.12.15803-preview-03 128 6/6/2024
2024.0.12.15608 144 6/4/2024
2024.0.12.15515 198 6/3/2024
2024.0.12.15220 137 5/31/2024
2024.0.12.15220-alpha31-240... 104 5/31/2024
2024.0.12.14911 167 5/28/2024
2024.0.12.14910-alpha28-240... 120 5/28/2024
2024.0.12.14823 145 5/27/2024
2024.0.12.14522-alpha7-2405... 135 5/24/2024
2024.0.12.14514-alpha6-2405... 127 5/24/2024
2024.0.12.14511 160 5/24/2024
2024.0.12.14314 176 5/22/2024
2024.0.12.14114 182 5/20/2024
2024.0.12.12815 182 5/7/2024
2024.0.12.12814 142 5/7/2024
2024.0.12.12721 161 5/6/2024
2024.0.12.12702 149 5/5/2024
2024.0.12.12622 181 5/5/2024
2024.0.12.12514 160 5/4/2024
2024.0.12.12512 155 5/4/2024
2024.0.12.12510 159 5/4/2024
2024.0.12.12420 124 5/3/2024
2024.0.12.12319 119 5/2/2024
2024.0.12.12319-rc-2405021801 95 5/2/2024
2024.0.12.12318 112 5/2/2024