Magazine Template

Request Quote

REDGATE SQL Compare is the industry standard for comparing and deploying SQL Server database schemas quickly and accurately.

71% of the Fortune 100 use SQL Compare to compare SQL Server databases because it's relentlessly tested, easy to use, creates flawless deployment scripts, and saves time.

Whether you need to deploy changes or explore the differences between two SQL Server databases, SQL Compare helps you do the job quickly, simply, and with zero errors.

What can I compare, synchronize, and deploy?

• 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)

Features in SQL Compare :

1. New - Linux command-line support (beta)a
2. Compare and deploy changes to SQL Server database schemas (from dev, to test, to production)
3. New - Support for Temporal Tables
4. Compare two SQL Server databases, synchronize, and deploy from within SSMS
5. Automatically create error-free deployment scripts
6. Generate T-SQL scripts that update one SQL Server database to match the schema of another
7. Save deployment scripts for later use
8. Automatically create error-free synchronization scripts
9. Comparison and deployment of large databases
10. New - -Choose how to examine differences: SQL View or Summary View
11. Migrate individual schema differences, a selection of them, or all of them
12. Build sophisticated rules to selectively limit what to deploy
13. Deploy individual schema differences, a selection of them, or all of them
14. Support for reading encrypted database objects
15. Fine-grained filtering of database objects
16. Troubleshoot database differences
17. Dependency checking, so objects are scripted in the correct order for updates
18. Warnings about anything you need to be aware of before deploying SQL Server schemas
19. Save schema snapshots for audit and roll-back purposes
20. New - Improved HTML report generation detailing database differences
21. Troubleshoot database differences and explore schema changes to see what's going on in development
22. New - Support for Retention Tables
23. New - Azure Active Directory authentication
24. New - Support for SQL Graph
25. New - Securely save database and server login details
26. New - Support for connections to SQL Server instances on Linux
27. Run deployments from the command line*
28. Automatically output a database into individual object creation scripts
29. Deploy a live database from a set of SQL object scripts
30. Restore just a single object (or selection of objects) from a backup file

For details, please contact us.