Upgradier

A minimalist approach for updating multiple databases concurrently to a version based in conventions.

Declare a place to store de Source databases in json format. You can mix databases of different providers (actually SqlServer, MySql and PostgreSql).

Store batches in .sql files on Disk, Web Server, Aws S3, Azure Blob, or custom IBatchStrategy.

Optionally use a cache implementing IBatchCacheManager to not hit the server when each batch is requested.

• Prerequisites
• Quick start

Prerequisites

• .NET SDK 8.0 or later

Quick start

• Install Upgradier.Core
• Install the required database engines:
  • Upgradier.DatabaseEngines.SqlServer
  • Upgradier.DatabaseEngines.PostgreSql
  • Upgradier.DatabaseEngines.MySql
• Install aditional batch strategies:
  • Upgradier.BatchStrategies.Aws
  • Upgradier.BatchStrategies.Azure

Create UpdateBuilder with options:

//Microsoft.Extensions.Logging.ILogger logger ...

BlobContainerClient blobContainerClient = ... // Optional use Azure

UpdateBuilder updateBuilder = new UpdateBuilder()
    .WithSourceProvider(options => new FileSourceProvider("c:\\my_files\\sources.json", options.Logger, options.Environment))
    .WithFileBatchStrategy("c:\\my_files\\batches")
    .WithCacheManager(options => new FileBatchCacheManager("c:\\my_files\\cache", options.Logger, options.Environment))
    .WithAzureBlobBatchStrategy(blobContainerClient)
    .AddSqlServerEngine()
    .AddMySqlServerEngine()
    .AddPostgreSqlServerEngine()
    .WithLogger(logger)
    .WithEnvironment("Dev");

Build to create the UpdateManager:

UpdateManager updateManager = updateBuilder.Build();

Update the databases:

IEnumerable<UpdateResult> updateResults = await updateManager.UpdateAsync();