SQL Compare is the fastest way to compare and deploy SQL Server schemas. You can quickly find and fix errors and create deployment scripts.
SQL Compare is an industry standard that allows you to compare and deploy SQL Server database schemas quickly.
71% of Fortune 100 companies use SQL Compare to compare SQL Server databases. This is because SQL Compare is constantly tested and proven reliable, simple to use, saves time, and creates flawless deployment scripts.
SQL Compare makes it easy to compare two SQL Server databases and make changes.
Red Gate SQL Compare Great Features:
- SQL Server 2008, 2012, 2014, 2016, 2017, 2019, SQL Azure, & SQL Server on Amazon RDS databases, including Temporal Tables
- Snapshots of the schema
- Backup files (both native SQL Server & Redgate SQL Backup Pro)
- Folders of SQL scripts (for source control)
- Linux command-line support (beta)
- Compare and deploy changes to SQL Server database schemas (from dev, to test, to production)
- Support for Temporal Tables
- Compare two SQL Server databases, synchronize, and deploy from within SSMS
- Automatically create error-free deployment scripts
- Generate T-SQL scripts that update one SQL Server database to match the schema of another
- Save deployment scripts for later use
- Automatically create error-free synchronization scripts.
- Comparison and deployment of large databases
- Choose how to examine differences: SQL View or Summary View
- Migrate individual schema differences, a selection of them, or all of them
- Build sophisticated rules to limit what to deploy selectively
- Deploy individual schema differences, a selection of them, or all of them
- Support for reading encrypted database objects
- Fine-grained filtering of database objects
- Troubleshoot database differences
- Dependency checking, so objects are scripted in the correct order for updates.
- Warnings about anything you need to be aware of before deploying SQL Server schemas
- Save schema snapshots for audit and roll-back purposes
- Improved HTML report generation detailing database differences
- Troubleshoot database differences and explore schema changes to see what's going on in the development
- Support for Retention Tables
- Azure Active Directory authentication
- Support for SQL Graph
- Securely save database and server login details
- Support for connections to SQL Server instances on Linux
- Run deployments from the command line
- Automatically output a database into individual object creation scripts
- Deploy a live database from a set of SQL object scripts
- Restore just a single object (or selection of objects) from a backup file
- Deployments automatically detected and displayed in SQL Monitor
- Command-line automation on a build server with SQL Change Automation