SQL Schema Compare TiCodeX
winget install --id=TiCodeX.SQLSchemaCompare -e The Swiss Army Knife of Database Schema Comparison for Microsoft SQL, mySQL and PostgreSQL which runs on Windows, Linux and macOS systems.
SQL Schema Compare is a comprehensive database schema comparison and synchronization tool designed to streamline the process of identifying and managing differences between database schemas across multiple platforms. It supports Microsoft SQL Server (including Azure SQL Database), MySQL, MariaDB, and PostgreSQL, making it an essential utility for database administrators, developers, and DevOps professionals working with diverse environments.
Key Features:
- Multi-platform Support: Runs seamlessly on Windows, Linux, and macOS systems.
- Cross-database Compatibility: Supports schema comparison and synchronization for MS-SQL Server (2008+), Azure SQL Database, PostgreSQL (9+), MySQL (5.6+), and MariaDB (5.5+).
- Localized Interface: Available in English, German, and Italian.
- Automated Script Generation: Automatically creates full database creation scripts and migration scripts for seamless schema updates.
- Secure Credential Management: Safely stores server and database login details for secure access.
- Powerful Filtering: Filters database objects using customizable rules to focus on specific changes or components.
- Cross-platform Compatibility: Enables comparison and synchronization across different operating systems and databases.
Audience & Benefit:
Ideal for database administrators, developers, and DevOps teams working with multiple database platforms. SQL Schema Compare empowers users to efficiently compare schemas, automate migration processes, and maintain consistency across development, testing, and production environments. Its ability to generate accurate migration scripts saves time and reduces errors, while its secure credential management ensures compliance with best practices for data security.
Installable via winget, SQL Schema Compare provides a robust solution for database schema management in modern, multi-platform workflows.
README
SQL Schema Compare
Description
The swiss army knife for database schema comparison and synchronization which runs on multiple OS and supports multiple databases.
TiCodeX SQL Schema Compare runs on Windows, Mac and Linux and connects to Microsoft SQL (MS-SQL), mySQL and PostgreSQL. In addition, Azure SQL and MS-SQL on Amazon RDS is supported.
Features
Supported OS & Languages
- Runs on Windows, Linux and MacOS
- Localized in English, German and Italian
Supported Databases
- Support for MS-SQL Server 2008 and higher
- Support for Azure SQL Database
- Support for PostgreSQL 9 and higher
- Support for MySQL 5.6 and higher
- Support for MariaDB 5.5 and higher
Features
- Compare changes between two SQL Database schemas (as example from development to test to production)
- Automatically create full db create scripts
- Automatically generate the db migration script
- Securely save database and server login details
- Support for connections to MS-SQL Server running on Linux
- View database differences and explore schema changes to see what's going on
- Possibility to filter database objects with powerful filtering rules
Screenshots
