Wednesday, 26 August 2020

5 Ways To Manage Database Schema Changes in .NET

 5 Ways To Manage Database Schema Changes in .NET

Most useful applications these days store some data in some storage. Sometimes this storage is a relational database with a well-defined schema. This schema might evolve with time, requiring production databases to be updated. In some cases, this is a rare occasion and perhaps can be done manually. However, if a company follows an agile approach and is trying to deliver new releases continuously, then these manual updates can quickly become too much of a headache even for experienced DBAs.

Luckily, this problem is not new at all, so there are tools to help with that. Most of my career I have been developing with .NET, so I will only discuss tools that make sense for .NET developers.

 

1. SQL Server Data Tools

2. Entity Framework Migrations

3. Fluent Migrator

4. RoundhousE

5. DbUp

No comments:

Post a Comment