New xSQL Schema Compare - version 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.

xSQL Schema Compare supports SQL Server 2014, 2012, 2008/2008R2, and 2005 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 version 5, click here.

Highlights


  • 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 for SQL Server 2012, SQL Server 2008 and SQL Server 2005

Requirements


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: 4.0
  • Release Date: November 14, 2012
    Current Version
  • Version Number: 5.1.0.0
  • Release Date: December 08, 2014

Features


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 all editions of SQL Server 2012, SQL Server 2008 and SQL Server 2005.

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 Server 2012 databases, SQL Server 2008 databases and SQL Server 2005 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 2005 database to a SQL Server 2008 database the synch script will be a SQL Server 2008 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.

Pricing
Starting from: $349
Order
Best Value
Consider Silver Subscription instead. It contains:
Order
Additional Information
Testimonials
  • ...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.
    i3solutions