Friday, February 22, 2013

xSQL Builder v4 with support for SQL 2012 released

We just released version 4 of xSQL Builder for SQL Server. The new version is built on top of the new, much more efficient and robust database schema compare API that was released on November of last year. Here is what’s new on xSQL Builder v4:
  • Improved performance thanks to the new schema compare API
  • Support for a new optimized schema snapshot definition
  • Full support for SQL Server 2012, SQL Server 2008 and SQL Server 2005
  • New C# template built for Visual Studio .NET 2010
  • New command line module for generating executable packages from the command line
You can download the new version from our site at:
Important: if you are running a licensed old version of xSQL Builder and your license was purchased before February 21, 2013 then you might want to hold off on installing the new version until you have made the decision to upgrade since the new version overwrites the old and your license does not support the new version. Of course you can always try the new version on a different machine.

Friday, February 8, 2013

Installing xSQL Comparison Bundle on Windows 8

When installing our comparison tools (SQL Schema Compare and SQL Data Compare) on a Windows 8 machine the installation may fail with the message “SQL Server Comparison Bundle v4 Setup Wizard ended prematurely because of an error” (see screen shot below).

Cause: by default on a Windows 8 machine only .NET Framework 4.5 is enabled whereas previous versions of the .NET Framework are not enabled.  

Solution: enable .NET Framework 3.5 (this includes .NET 3 and .NET 2) on your machine. To do this go to Control Panel / Programs / Programs and Features / Turn Windows Features on or off and then check the “.NET Framework 3.5.1” checkbox and click OK (the machine needs to be connected to the Internet while this is being done. After enabling .NET Framework 3.5.1 re-run the installation of xSQL Comparison Bundle and it should install without a problem.

Wednesday, February 6, 2013

SQL Server Comparison bundle - new build available

A new build of the SQL Server Comparison Bundle is available for download. The changes implemented are relatively minor however, we recommend that if you are using version 4.x of the tools you download and install this new build, which:
  • Fixes an issue with the GUI scaling on different resolution/DPI settings (both, schema and data compare).
  • Fixes an issue with user membership to roles (schema compare).
  • Fixes a bug related to the order of the included columns in an index (schema compare).
  • Adds two new command line options for the data compare where clauses, allowing you to set different filters on each table/view on the pair (data compare).