About this project

DbDelta is a tool designed to compare the schemas of two Microsoft SQL Server databases, identify differences, and generate dependency-ordered T-SQL migration scripts to synchronize the target database with the source. It supports SQL Server 2016+ and Azure SQL DB. Key capabilities include: - Schema Comparison: Computes differences between live databases across 13 object kinds. - Script Generation: Produces self-contained, transactional T-SQL scripts with error handling and rollback capabilities. - Deployment: Allows applying scripts via the tool's own interface, sqlcmd, or SSMS. - Reporting: Generates self-contained HTML and JSON reports detailing schema differences. - Multiple Interfaces: Provides both a desktop GUI built with Avalonia 11 and a CLI with verbs for compare, report, script, and apply. - Project Management: Supports connection management and project persistence using .dbd XML files.