DotNetBrightener.DataAccess.DataMigration 2025.0.3

There is a newer prerelease version of this package available.
See the version list below for details.
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.  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.4-preview-299 105 5/31/2025
2025.0.4-preview-298 91 5/30/2025
2025.0.4-preview-296 129 5/30/2025
2025.0.4-preview-295 139 5/29/2025
2025.0.4-preview-293 141 5/26/2025
2025.0.4-preview-292 137 5/26/2025
2025.0.3 115 2/10/2025
2025.0.3-preview-288 111 2/10/2025
2025.0.2 125 1/21/2025
2025.0.2-preview-278 95 1/21/2025
2025.0.2-preview-277 103 12/16/2024
2025.0.1-rc-243301701 369 11/25/2024
2024.0.14.6 113 11/25/2024
2024.0.14.6-rc-243031001 187 10/29/2024
2024.0.14.6-rc-243030701 106 10/29/2024
2024.0.14.6-rc-242840501 99 10/10/2024
2024.0.14.6-rc-242820305 93 10/8/2024
2024.0.14.6-rc-242771401 190 10/3/2024
2024.0.14.6-rc-242770501 99 10/3/2024
2024.0.14.6-rc-242770201 101 10/3/2024
2024.0.14.6-rc-242761801 98 10/2/2024
2024.0.14.6-rc-242761601 108 10/2/2024
2024.0.14.6-rc-242761501 91 10/2/2024
2024.0.14.6-rc-242761401 104 10/2/2024
2024.0.14.6-rc-242760701 118 10/2/2024
2024.0.14.6-rc-242751002 101 10/1/2024
2024.0.14.6-rc-242750901 115 10/1/2024
2024.0.14.6-rc-242750502 96 10/1/2024
2024.0.14.6-rc-242750201 107 10/1/2024
2024.0.14.6-rc-242741501 94 9/30/2024
2024.0.14.6-rc-242730701 125 9/29/2024
2024.0.14.6-preview-2730501 91 9/29/2024
2024.0.14.6-preview-2701501 133 9/26/2024
2024.0.14.6-preview-2620901 154 9/18/2024
2024.0.14.6-preview-2570701 98 9/13/2024
2024.0.14.6-preview-2510703 167 9/7/2024
2024.0.14.6-preview-2480501 124 9/4/2024
2024.0.14.6-preview-2430401 137 8/30/2024
2024.0.14.6-preview-242730701 97 9/29/2024
2024.0.14.6-preview-2421703 104 8/29/2024
2024.0.14.6-preview-2421701 103 8/29/2024
2024.0.14.6-preview-2420901 100 8/29/2024
2024.0.14.6-preview-2390101 114 8/26/2024
2024.0.14.6-preview-2381603 130 8/25/2024
2024.0.14.6-preview-2341601 152 8/21/2024
2024.0.14.6-preview-2321602 145 8/20/2024
2024.0.14.6-preview-2190801 171 8/6/2024
2024.0.14.6-preview-2041501 108 7/22/2024
2024.0.14.6-preview-1920603 156 7/10/2024
2024.0.14.6-preview-1920301 126 7/10/2024
2024.0.14.6-preview-1911302 111 7/9/2024
2024.0.14.6-preview-1901001 123 7/8/2024
2024.0.14.6-preview-1900901 105 7/8/2024
2024.0.14.6-preview-1900801 107 7/8/2024
2024.0.14.6-preview-1860304 110 7/4/2024
2024.0.14.5 171 7/1/2024
2024.0.14.5-preview-1811601 118 6/29/2024
2024.0.14.5-preview-1810501 131 6/29/2024
2024.0.14.5-preview-180132 138 6/28/2024
2024.0.14.5-preview-180131 123 6/28/2024
2024.0.14.5-preview-180121 108 6/28/2024
2024.0.14.4 136 6/27/2024
2024.0.14.4-preview-8 117 6/27/2024
2024.0.14.4-preview-7 117 6/27/2024
2024.0.14.3 132 6/21/2024
2024.0.14.1 133 6/6/2024
2024.0.14.1-preview 110 6/6/2024
2024.0.14-preview-1 110 6/6/2024
2024.0.13.8-preview 113 6/6/2024
2024.0.13.1-preview-0146 111 6/6/2024
2024.0.13-preview-1 103 6/6/2024
2024.0.12.15803-preview-03 117 6/6/2024
2024.0.12.15608 133 6/4/2024
2024.0.12.15515 185 6/3/2024
2024.0.12.15220 125 5/31/2024
2024.0.12.15220-alpha31-240... 92 5/31/2024
2024.0.12.14911 153 5/28/2024
2024.0.12.14910-alpha28-240... 109 5/28/2024
2024.0.12.14823 132 5/27/2024
2024.0.12.14522-alpha7-2405... 122 5/24/2024
2024.0.12.14514-alpha6-2405... 115 5/24/2024
2024.0.12.14511 148 5/24/2024
2024.0.12.14314 165 5/22/2024
2024.0.12.14114 168 5/20/2024
2024.0.12.12815 167 5/7/2024
2024.0.12.12814 131 5/7/2024
2024.0.12.12721 151 5/6/2024
2024.0.12.12702 137 5/5/2024
2024.0.12.12622 170 5/5/2024
2024.0.12.12514 146 5/4/2024
2024.0.12.12512 144 5/4/2024
2024.0.12.12510 147 5/4/2024
2024.0.12.12420 112 5/3/2024
2024.0.12.12319 107 5/2/2024
2024.0.12.12319-rc-2405021801 84 5/2/2024
2024.0.12.12318 101 5/2/2024