Do you know the best tools for updating database schemas?

Last updated by Toby Churches [SSW] 6 months ago.See history

In the fast-evolving world of software development, it's crucial for your database deployment process to be as efficient and reliable as your application updates. With the advent of .NET 8, there are several modern tools and methods that can help you achieve this seamlessly.

  • Entity Framework Core Migrations: EF Core Migrations has become the de facto standard for managing database schema changes. It offers robust, integrated support for versioning and deploying database changes, making it the preferred choice for both new and existing projects.
  • DAC Support For SQL Server Objects and Versions (.dacpac files): Still relevant for SQL Server database management, particularly in complex deployment scenarios.

These methods are outdated and lack the comprehensive features required for modern database schema management, With no ability to validate that the database hasn't been tampered with:

  • SQL Deploy (This is the suggested tool if you are not using Entity Framework Code First)
  • DbUp + SQL verify
  • Navicat for MySQL
  • DataGrip
  • SQL Management Studio + OSQL (Free and roll your own)
  • Visual Studio + SQL Server Data Tools (Formerly Data Dude) + Deploy (post-development model)
  • Red Gate SQL Compare + Red Gate SQL Packager (post-development model)
We open source. Powered by GitHub