DotNetBrightener.DataAccess.DataMigration 2025.0.3

dotnet add package DotNetBrightener.DataAccess.DataMigration --version 2025.0.3
                    
NuGet\Install-Package DotNetBrightener.DataAccess.DataMigration -Version 2025.0.3
                    
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="2025.0.3" />
                    
For projects that support PackageReference, copy this XML node into the project file to reference the package.
<PackageVersion Include="DotNetBrightener.DataAccess.DataMigration" Version="2025.0.3" />
                    
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 2025.0.3
                    
#r "nuget: DotNetBrightener.DataAccess.DataMigration, 2025.0.3"
                    
#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.
#addin nuget:?package=DotNetBrightener.DataAccess.DataMigration&version=2025.0.3
                    
Install DotNetBrightener.DataAccess.DataMigration as a Cake Addin
#tool nuget:?package=DotNetBrightener.DataAccess.DataMigration&version=2025.0.3
                    
Install DotNetBrightener.DataAccess.DataMigration 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 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. 
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.3 103 2/10/2025
2025.0.3-preview-288 105 2/10/2025
2025.0.2 116 1/21/2025
2025.0.2-preview-278 87 1/21/2025
2025.0.2-preview-277 93 12/16/2024
2025.0.1-rc-243301701 322 11/25/2024
2024.0.14.6 106 11/25/2024
2024.0.14.6-rc-243031001 183 10/29/2024
2024.0.14.6-rc-243030701 102 10/29/2024
2024.0.14.6-rc-242840501 93 10/10/2024
2024.0.14.6-rc-242820305 87 10/8/2024
2024.0.14.6-rc-242771401 186 10/3/2024
2024.0.14.6-rc-242770501 94 10/3/2024
2024.0.14.6-rc-242770201 97 10/3/2024
2024.0.14.6-rc-242761801 93 10/2/2024
2024.0.14.6-rc-242761601 104 10/2/2024
2024.0.14.6-rc-242761501 87 10/2/2024
2024.0.14.6-rc-242761401 100 10/2/2024
2024.0.14.6-rc-242760701 113 10/2/2024
2024.0.14.6-rc-242751002 92 10/1/2024
2024.0.14.6-rc-242750901 105 10/1/2024
2024.0.14.6-rc-242750502 92 10/1/2024
2024.0.14.6-rc-242750201 101 10/1/2024
2024.0.14.6-rc-242741501 90 9/30/2024
2024.0.14.6-rc-242730701 120 9/29/2024
2024.0.14.6-preview-2730501 84 9/29/2024
2024.0.14.6-preview-2701501 126 9/26/2024
2024.0.14.6-preview-2620901 151 9/18/2024
2024.0.14.6-preview-2570701 95 9/13/2024
2024.0.14.6-preview-2510703 164 9/7/2024
2024.0.14.6-preview-2480501 118 9/4/2024
2024.0.14.6-preview-2430401 132 8/30/2024
2024.0.14.6-preview-242730701 93 9/29/2024
2024.0.14.6-preview-2421703 100 8/29/2024
2024.0.14.6-preview-2421701 99 8/29/2024
2024.0.14.6-preview-2420901 97 8/29/2024
2024.0.14.6-preview-2390101 111 8/26/2024
2024.0.14.6-preview-2381603 127 8/25/2024
2024.0.14.6-preview-2341601 145 8/21/2024
2024.0.14.6-preview-2321602 138 8/20/2024
2024.0.14.6-preview-2190801 168 8/6/2024
2024.0.14.6-preview-2041501 105 7/22/2024
2024.0.14.6-preview-1920603 153 7/10/2024
2024.0.14.6-preview-1920301 121 7/10/2024
2024.0.14.6-preview-1911302 105 7/9/2024
2024.0.14.6-preview-1901001 120 7/8/2024
2024.0.14.6-preview-1900901 100 7/8/2024
2024.0.14.6-preview-1900801 100 7/8/2024
2024.0.14.6-preview-1860304 106 7/4/2024
2024.0.14.5 167 7/1/2024
2024.0.14.5-preview-1811601 112 6/29/2024
2024.0.14.5-preview-1810501 127 6/29/2024
2024.0.14.5-preview-180132 130 6/28/2024
2024.0.14.5-preview-180131 117 6/28/2024
2024.0.14.5-preview-180121 102 6/28/2024
2024.0.14.4 131 6/27/2024
2024.0.14.4-preview-8 112 6/27/2024
2024.0.14.4-preview-7 112 6/27/2024
2024.0.14.3 128 6/21/2024
2024.0.14.1 126 6/6/2024
2024.0.14.1-preview 104 6/6/2024
2024.0.14-preview-1 105 6/6/2024
2024.0.13.8-preview 110 6/6/2024
2024.0.13.1-preview-0146 106 6/6/2024
2024.0.13-preview-1 96 6/6/2024
2024.0.12.15803-preview-03 113 6/6/2024
2024.0.12.15608 125 6/4/2024
2024.0.12.15515 180 6/3/2024
2024.0.12.15220 117 5/31/2024
2024.0.12.15220-alpha31-240... 89 5/31/2024
2024.0.12.14911 145 5/28/2024
2024.0.12.14910-alpha28-240... 106 5/28/2024
2024.0.12.14823 123 5/27/2024
2024.0.12.14522-alpha7-2405... 118 5/24/2024
2024.0.12.14514-alpha6-2405... 106 5/24/2024
2024.0.12.14511 142 5/24/2024
2024.0.12.14314 161 5/22/2024
2024.0.12.14114 161 5/20/2024
2024.0.12.12815 161 5/7/2024
2024.0.12.12814 124 5/7/2024
2024.0.12.12721 143 5/6/2024
2024.0.12.12702 132 5/5/2024
2024.0.12.12622 164 5/5/2024
2024.0.12.12514 141 5/4/2024
2024.0.12.12512 139 5/4/2024
2024.0.12.12510 143 5/4/2024
2024.0.12.12420 108 5/3/2024
2024.0.12.12319 101 5/2/2024
2024.0.12.12319-rc-2405021801 76 5/2/2024
2024.0.12.12318 96 5/2/2024