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
• Support for Azure SQL Database
• Support for PostgreSQL
• Support for MySQL
• Support for MariaDB

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

Troubleshooting

An unexpected error has occurred

If you see this message on macOS, it means your system is configured to block unsigned applications.

Since SQL Schema Compare is not yet a signed application, macOS will prevent it from running by default.

To fix this, open your Terminal and run the following command:

xattr -cr /Applications/SQL\ Schema\ Compare.app

Note: If you installed the app in a different directory, adjust the path accordingly.

License

GPL-3.0