Schema Compare for SQL Server
Compare the schemas of two SQL Server databases, review the differences, manage the synchronization script, and run it - xSQL Schema Compare makes it easy to manage changes in the database.
Compare the schemas of two SQL Server databases, review the differences, manage the synchronization script, and run it - xSQL Schema Compare makes it easy to manage changes in the database.
Compare the schemas of two SQL Server databases, review the differences, manage the synchronization script, and run it - xSQL Schema Compare makes it easy to manage changes in the database.
Overview
Lights
Requirements
xSQL Schema Compare for SQL Server runs on Windows operating systems that have .NET framework 4.6 or higher installed.
Resources
Robust comparison mechanism - carefully designed and extensively tested, the main mechanism for comparing and synchronizing schemes is efficient, easily configurable and scalable. Based on this, schema comparison supports local SQL Server from 2005 to 2019 and Azure SQL Database.
Efficient GUI - the graphical user interface of xSQL Schema Compare for SQL Server is designed to accelerate - a context-sensitive ribbon of action, action dashboards with clear descriptions, and context-sensitive menus provide multiple, intuitive, fast, and easy paths to complete the database schema comparison synchronization tasks in the shortest possible time. The results of the comparison are displayed in a well-organized manner in a highly customizable window, making it easier to see where the differences are and what it would take to send database schema changes from one database to another.
One-click re-comparison - xSQL Schema Compare for SQL Server maintains a history of comparison sessions. A session is a persistent environment that contains all data related to a comparison operation, including databases and their credentials, comparison options, script options, execution options, types of objects included or deleted, individual objects included or deleted, and more. It allows the end user to repeat a schema comparison of the database with a single click. Application options control how sessions are sorted and the maximum number of sessions that persist.
Customizable comparison sessions - comparing database objects is not simple, the answer to the question "is object1 equal to object2?" is not a clear cut yes or no, it depends. For example, two tables can be considered equal if we ignore column grouping, but not equal if we consider grouping, two stored procedures can be considered equal if we ignore the case of characters, but they can be different if we consider the case of characters, two indexes can be considered equal if we ignore the fill factor, but maybe different when we consider the fill factor. XSQL Schema Compare for SQL Server exposes more than 100 comparison options that give the user complete control over the comparison engine.
Comparison between versions and synchronization - you can perform a schema comparison operation between the SQL Azure v11/v12 databases and all local SQL Server databases; the engine will compare the relevant objects for both sides of the comparison. The generated synchronization scripts are version-specific - for example, if you move changes from a SQL Server 2012 database to a SQL Server 2014 database, the synchronization script will be a script that supports SQL Server 2014 and vice versa.
Standardized and secure scripts - The database change script, generated based on schema comparison results, is grouped into a large transaction to ensure that changes to the database schema occur in its entirety or do not occur. For each object affected by the change, scripts are organized into clearly defined sections, settings are set properly, and errors are logged and handled.
Schema snapshots - not only allow you to maintain a history (audit trail) of schema changes, but also provide a very efficient and secure way to roll back schema changes when needed. Simply compare the database in question with the snapshot of yourself, taken just before the changes and generate the script to roll back the changes.
Standalone comparison and synchronization - The included command-line utility allows users to schedule schema comparison and synchronization operations through the Windows Task Scheduler, sql server scheduler. A step-by-step wizard helps you create and manage the configuration files used by the command, hiding their complexity and generating consistent, always-up-to-date xml files.
System requirements:
CPU: 1.8 GHz dual core processor
RAM: 2 GB
HDD / SSD: 50 GB of free space on the main drive
Operating system: Microsoft Windows 8 32-bit, Microsoft Windows 7 32-bit and Microsoft Windows Vista 32-bit
Resolution: 1024×768
You don't know what software you need or you haven't found what you were looking for? We have a team ready to help you choose the right software for your company.