Schema Compare for SQL Server - version 9.5

Compare the schemas of two SQL Server databases, review differences, generate synchronization script and execute it - xSQL Schema Compare makes database change management easy.

Schema compare supports SQL Server 2017, 2016, 2014, 2012, 2008/2008R2, and 2005, Microsoft Azure databases v11 & v12 and it is available for FREE as a fully functional Lite Edition (see the "Editions" below for details).

For a list of the new and improved features included in the version 9 of the schema comparison, click here.


  • Fast, effortless, and safe SQL Server database schema compare and synchronization
  • SQL Server cross version schema comparison and synchronization
  • Highly customizable schema compare and synchronization sessions
  • Generate ready-to-deploy database change scripts
  • Standardized, version specific synchronization scripts
  • Transactional execution of the change script
  • Schema snapshots to preserve change history
  • Command Line utility for unattended database schema comparison and synchronization
  • One-click re-compare
  • Support on-premise SQL Server 2005-2017 and Azure v11/v12


xSQL Schema Compare for SQL Server runs on Windows operating systems that have the .NET framework 4.0 installed.

Version Information

    Major Version
  • Version Number: 9.5
  • Release Date: February 03, 2018
    Current Version
  • Version Number:
  • Release Date: January 24, 2019


Robust Comparison Engine - completely redesigned utilizing the experience gathered from over 30 thousand installations, and extensively tested for over a year, the new, platform agnostic, core database schema comparison and synchronization engine is very efficient, easily configurable, and scalable. Built on top of the core comparison engine, the SQL Server schema comparison and synchronization module supports on-premise SQL Server 2017, 2016, 2014, 2012, 2008/2008R2, 2005 and Azure v11 & v12.

Efficient GUI - the graphical user interface of the xSQL Schema Compare for SQL Server has been designed for speed - a context sensitive ribbon, action panels with clear descriptions and context sensitive menus provide multiple, intuitive, quick and easy paths for completing the database schema comparison and synchronization tasks in the minimum amount of time possible. The comparison results are displayed in a well organized manner on a highly customizable window making it very easy to see where the differences are and what it would take to push database schema changes from one database to the other.

One-click re-compare - xSQL Schema Compare for SQL Server maintains a comparison session history. A session is a persisted environment that contains all the data related to a comparison operation including databases and the respective credentials, comparison options, scripting options, execution options, included or excluded object types, included or excluded infividual objects and many more. It allows the end-user to repeat a database schema comparison with a single click. Application options control the way sessions are sorted and the max number of sessions that are persisted.

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 maybe be considered equal if we ignore the column collation but not equal if we consider collation, two stored procedures may be considered equal if we ignore character case but may be different if we consider the character case, two indexes may be considered equal if we ignore the fill factor but maybe different when we consider the fill factor etc. xSQL Schema Compare for SQL Server exposes over one hundred comparison options that give the user complete control over the comparison engine.

Cross version comparison and synchronization - you can perform a schema compare operation between SQL Azure v11/v12 databases and all on-premise SQL Server databases; the engine will compare the objects that are relevant for both sides of the comparison. The generated synchronization scripts are version specific – for example, if moving changes from a SQL Server 2012 database to a SQL Server 2014 database the synch script will be a SQL Server 2014 compliant script and vice versa.

Safe, standardized scripts - the database change script, that is generated based on the results of the schema compare, is wrapped into one big transaction to ensure that the database schema changes will either happen in their entirety or not happen at all. For every object that is affected by the change the scripts are organized in clearly defined sections, the set settings are properly initialized and the errors are logged and handled.

Schema snapshots - allow you to not only maintain a history (audit trail) of the schema changes, but they also provide a very efficient and safe way for reversing schema changes when necessary. Simply compare the database in question with the snapshot of itself, taken right before the changes were made and generate the script for reversing changes.

Unattended comparison and synchronization - the included xSQL Schema Compare Command Line utility allows the user to schedule schema compare and synchronization operations via the Windows Task Scheduler, SQL Server scheduler etc.

Starting from:  $399
Best Value
Consider Silver Subscription - SQL Server Tools instead. It contains:
Additional Information
  • ...The speed, ease of use and most importantly, the support when there's an issue, make this suite my product of choice...
    Brenton G.
    ASPGUY-Independent Consulting, TX
  • These are great products and people should be aware of their potential. I have been using these tools for a long time and they have made my job a whole lot easier.
    Neil K.
    Mid-Hudson Regional Information Center
  • I love your xSQL Object and I'm going to recommend it to others.
    Omer A.
    Infopark Software & Consultancy
  • Love the comparison bundle. We recommend it to all our clients.
    Scott S.