DotNetBrightener.DataAccess.DataMigration 2024.0.14.5

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

// Install DotNetBrightener.DataAccess.DataMigration as a Cake Tool
#tool nuget:?package=DotNetBrightener.DataAccess.DataMigration&version=2024.0.14.5                

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. 
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
2024.0.14.6-rc-243031001 121 10/29/2024
2024.0.14.6-rc-243030701 82 10/29/2024
2024.0.14.6-rc-242840501 81 10/10/2024
2024.0.14.6-rc-242820305 76 10/8/2024
2024.0.14.6-rc-242771401 174 10/3/2024
2024.0.14.6-rc-242770501 83 10/3/2024
2024.0.14.6-rc-242770201 87 10/3/2024
2024.0.14.6-rc-242761801 79 10/2/2024
2024.0.14.6-rc-242761601 91 10/2/2024
2024.0.14.6-rc-242761501 76 10/2/2024
2024.0.14.6-rc-242761401 86 10/2/2024
2024.0.14.6-rc-242760701 95 10/2/2024
2024.0.14.6-rc-242751002 81 10/1/2024
2024.0.14.6-rc-242750901 90 10/1/2024
2024.0.14.6-rc-242750502 81 10/1/2024
2024.0.14.6-rc-242750201 82 10/1/2024
2024.0.14.6-rc-242741501 79 9/30/2024
2024.0.14.6-rc-242730701 106 9/29/2024
2024.0.14.6-preview-2730501 73 9/29/2024
2024.0.14.6-preview-2701501 113 9/26/2024
2024.0.14.6-preview-2620901 138 9/18/2024
2024.0.14.6-preview-2570701 85 9/13/2024
2024.0.14.6-preview-2510703 152 9/7/2024
2024.0.14.6-preview-2480501 109 9/4/2024
2024.0.14.6-preview-2430401 123 8/30/2024
2024.0.14.6-preview-242730701 83 9/29/2024
2024.0.14.6-preview-2421703 91 8/29/2024
2024.0.14.6-preview-2421701 91 8/29/2024
2024.0.14.6-preview-2420901 89 8/29/2024
2024.0.14.6-preview-2390101 104 8/26/2024
2024.0.14.6-preview-2381603 119 8/25/2024
2024.0.14.6-preview-2341601 137 8/21/2024
2024.0.14.6-preview-2321602 130 8/20/2024
2024.0.14.6-preview-2190801 148 8/6/2024
2024.0.14.6-preview-2041501 97 7/22/2024
2024.0.14.6-preview-1920603 141 7/10/2024
2024.0.14.6-preview-1920301 106 7/10/2024
2024.0.14.6-preview-1911302 97 7/9/2024
2024.0.14.6-preview-1901001 108 7/8/2024
2024.0.14.6-preview-1900901 90 7/8/2024
2024.0.14.6-preview-1900801 89 7/8/2024
2024.0.14.6-preview-1860304 92 7/4/2024
2024.0.14.5 153 7/1/2024
2024.0.14.5-preview-1811601 97 6/29/2024
2024.0.14.5-preview-1810501 114 6/29/2024
2024.0.14.5-preview-180132 114 6/28/2024
2024.0.14.5-preview-180131 106 6/28/2024
2024.0.14.5-preview-180121 90 6/28/2024
2024.0.14.4 116 6/27/2024
2024.0.14.4-preview-8 101 6/27/2024
2024.0.14.4-preview-7 103 6/27/2024
2024.0.14.3 116 6/21/2024
2024.0.14.1 114 6/6/2024
2024.0.14.1-preview 97 6/6/2024
2024.0.14-preview-1 100 6/6/2024
2024.0.13.8-preview 103 6/6/2024
2024.0.13.1-preview-0146 101 6/6/2024
2024.0.13-preview-1 91 6/6/2024
2024.0.12.15803-preview-03 104 6/6/2024
2024.0.12.15608 114 6/4/2024
2024.0.12.15515 170 6/3/2024
2024.0.12.15220 103 5/31/2024
2024.0.12.15220-alpha31-240... 82 5/31/2024
2024.0.12.14911 133 5/28/2024
2024.0.12.14910-alpha28-240... 99 5/28/2024
2024.0.12.14823 107 5/27/2024
2024.0.12.14522-alpha7-2405... 111 5/24/2024
2024.0.12.14514-alpha6-2405... 98 5/24/2024
2024.0.12.14511 130 5/24/2024
2024.0.12.14314 146 5/22/2024
2024.0.12.14114 146 5/20/2024
2024.0.12.12815 148 5/7/2024
2024.0.12.12814 112 5/7/2024
2024.0.12.12721 133 5/6/2024
2024.0.12.12702 122 5/5/2024
2024.0.12.12622 152 5/5/2024
2024.0.12.12514 127 5/4/2024
2024.0.12.12512 127 5/4/2024
2024.0.12.12510 131 5/4/2024
2024.0.12.12420 95 5/3/2024
2024.0.12.12319 88 5/2/2024
2024.0.12.12319-rc-2405021801 66 5/2/2024
2024.0.12.12318 86 5/2/2024