News

Apr 08, 2014
xSQL Builder V5 with support for SQL Server 2014
A new version of xSQL Builder with support for SQL Server 2014 is now available for download. xSQL Builder 5 includes:
  • SQL Server 2014 support - full support for SQL Server 2014;
  • Entity filters - you can now use define object name filters to include/exclude whole sets of objects int he comparison and synchronization process
  • Filegroup mapping - support for filegroup mapping;
  • Bug fixes - fixes an issue with T-SQL scripts containing extended characters.

Mar 10, 2014
xSQL Comparison Bundle 5 with support for SQL Server 2014
Just released xSQL Comparison Bundle 5 with full support for SQL Server 2014. The new version of xSQL Schema Compare and xSQL Data Compare include the following new and improved features:
  • SQL Server 2014 support: full support for SQL Server 2014 including all new and improved SQL Server 2014 objects such as memory-optimized filegroups, memory-optimized tables, hash and range indexes, columnstore indexes, memory-optimized table types, natively-compiled stored procedures, primary and secondary selective xml indexes, Xml index and namespace paths, etc. Now xSQL Schema Compare provides full support for all SQL Server Editions from SQL Server 2005 to SQL Server 2014 whereas xSQL Data Compare provides full support for all SQL Server Editions from SQL Server 2000 to SQL Server 2014.
  • New comparison options: in xSQL Schema Compare you can now choose to include or exclude database filegroups and memory-optimized tables from the comparison and synchronization, whereas in xSQL Data Compare you can now choose to include or exclude from the comparison memory-optimized tables and columnstore tables.
  • Filegroup mapping: xSQL Schema Compare version 5 introduces filegroup mappings feature that allows you to easily handle complex database comparison scenarios involving databases with different filegroup structures.
  • Improved workspace: consistent look, feel and functionality in both comparison tools the xSQL Schema Compare and the xSQL Data Compare; new coloring scheme for comparison sessions allowing you to better organize the comparison sessions in the workspace; separate tab for schema snapshots etc.

You can download the new version of the xSQL Comparison Bundle here...

Jan 13, 2014
xSQL Documenter 4.8 released
New xSQL Documenter version 4.8 is now available for download. The new version includes the following new/improved features:
  • support for SQL Server 2012
  • Improved diagrams with GraphViz
  • ability to exclude synonyms and sequences in Oracle

Aug 07, 2013
New builds for xSQL Schema Compare and xSQL Builder
New builds, xSQL Schema Compare build version 4.0.8.0, and xSQL Builder build version 4.0.3.0 are now available for download. The new builds include the following fixes:
  • issue related to some specific data type conversion, such as varchar(max) to image, char/varchar to float/real (applies to Schema and Builder
  • issue related to dependencies between a full-text index and the unique key/index associated with it (applies to Schema and Builder)
  • issue related to parsing of SQL Server multi-line comments in the object definition (applies to Schema and Builder)
  • error triggered by foreing keys with the same name created on different tables (schema only)
  • issue with the serialization of user-defined data type binding to rules and stand-alone defaults (schema only)
  • minor UI improvements (Schema and Builder)

Jun 03, 2013
New xSQL Comparison Bundle build available
New builds, xSQL Schema Compare build version 4.0.6.0, and xSQL Data Compare build version 4.0.8.0 are now available for download. The new builds add support for saving workspace to custom files and loading workspaces from custom files, fix a small issue with the comparison results grid in Data Compare, fix an error that occurred when database name contains unicode characters, and fix an error related to the columns that participate in an index

May 03, 2013
New build of xSQL Schema Compare available
New xSQL Schema Compare build version 4.0.5.0 is available for download. The new build fixes a scripting issue related to database compatibility mode

Apr 29, 2013
New builds availabe for Schema, Data, Builder and Executor
New builds are available for download for the following tools:
  • xSQL Schema Compare version 4.0.4.5
  • xSQL Data Compare version 4.0.7.5
  • xSQL Builder version 4.0.2.0
  • Script Executor version 3.6.0.0
The new builds add support for the subscription license and fix various minor bugs

Mar 29, 2013
xSQL Builder version 4.0.1.5 is available
A new build for xSQL Builder, version 4.0.1.5, is available for download. The new build fixes a synchronization issue when the target database is in single-user mode, and also contains some minor fixes in the schema compare API

Feb 21, 2013
xSQL Builder 4 with support for SQL Server 2012 released
xSQL Builder 4 with support for SQL Server 2012 is now available for download. Following are some of the new and improved features that version 4 brings:
  • SQL Server 2012 support - full support for SQL Server 2012, SQL Server 2008 and SQL Server 2005. SQL Server 2000 is no longer supported, however, xSQL Builder v3.5 will continue to be available on request for users that might still be using SQL Server 2000.
  • New comparison engine - completely redesigned database schema compare engine is faster, more efficient, and scalable all attributes that are inherited by the new xSQL Builder.
  • New C# template - the new xSQL Builder C# template that allows the user to customize the deployment package is built for VS.NET 2010.
  • New command line module - a new module for generating executable packages via the command line.
  • Optimized schema snapshot - the new xSQL Builder supports a new and highly optimized schema snapshot definition.

You can download the new version of the xSQL Builder here...

Jan 24, 2013
xSQL Data Compare new build version 4.0.7.0 is available
xSQL Data Compare build 4.0.7.0 adds two new command line options for the data compare "where clauses", and fixes an issue with the UI scaling in different resoultions

Nov 14, 2012
xSQL Schema Compare for SQL Server version 4 released
Today we are announcing the release of the fourth generation of our database schema comparison and synchronization tool, xSQL Schema Compare for SQL Server previously known as xSQL Object. The new version benefits from over 8 years of experience with database compare tools and over 30 thousand installations worldwide. Following are some highlights of what's new in this version:
  • SQL Server 2012 support - version 4 of xSQL Schema Compare for SQL Server supports SQL Server 2012, SQL Server 2008 and SQL Server 2005. SQL Server 2000 is no longer supported.
  • New comparison engine - completely redesigned database schema compare engine is faster, more efficient, easily configurable and scalable.
  • Efficient GUI - the completely redesigned graphical user interface is more intuitive, more responsive, better organized, and much easier to use. There is practically zero learning time required.
  • One-click re-compare - xSQL Schema Compare for SQL Server automatically saves all the configuration settings related to a comparison session and allows the user to repeat that comparison in the future with a single click.
  • New dependency algorithm - Discovering the object dependencies and building a dependency graph is important but what we do with those dependencies is even more important. The new proprietary dependency algorithm implements precise dependency actions for a multitude of dependency scenarios.
  • Highly configurable - over one hundred options give the user total control over the comparison and synchronization of the database schemas.
  • Improved comparison results - the new comparison results grid provides for grouping of objects based on type, status, schema etc.; filtering based on comparison results; drill down on tables and views to quickly identify what might be different; and more.
  • Enhanced logging - extensive logging for API errors, UI errors and the script execution.

More details about this release can be found here... and you can download the new version of the xSQL Schema Compare for SQL Server here...

Feb 14, 2012
Script Executor now supports SQL 2012
A new build of Script Executor with support for SQL Server 2012 is now available for download.

Feb 12, 2012
xSQL Documenter 4.5 released
xSQL Documenter v4.5 is available for download now. The new version includes the following new features and updates:
  • Support for SSRS in SharePoint Integrated mode.
  • Support for Informix 9.
  • Support for exclusion lists in SSRS (Microsoft Report Server)
  • Support for fetching permissions objects in Oracle.
  • Support for fetching dependencies between objects in different schemas in Oracle.
  • Support for drawing data model diagrams with GraphViz.
  • Improved performance when excluding a large number of objects.
  • Added textboxes for delimiters in the GUI.
  • Bug fix: exclude indexes if parent table is also excluded.
  • Bug fix for DB2 if can't get pagesize.
  • Bug fix: fixed a bug for Oracle where functions weren't being returned unless DocumentProcedure was set TRUE.
  • SSIS fix: take server name from file path for DTSX files if the path is UNC.

Oct 06, 2011
Oracle Data Compare released
The much anticipated Oracle Data Compare tool for comparing and synchronizing data in two Oracle databases has been released. Built on top of a robust, proven data comparison and synchronization platform the Oracle Data Compare is slated to become the tool of choice for Oracle Database Administrators and Oracle Developers across the World. Oracle Data Compare features include:
  • Cross version support: Oracle Data Compare supports Oracle 9i, Oracle 10g, Oracle 11g and can compare and synchronize data across those versions.
  • Proven platform: Oracle Data Compare is built on top of our proprietary Universal Data Comparison™ platform that has been in production on thousands of computers for over 5 years.
  • Modern GUI: intuitive, elegant, efficient, the graphical user interface reflects the latest standards in user interface design.
  • Support for tables and views: In addition of comparing tables Oracle Data Compare provides for comparing views as well, both regular views and materialized views.
  • Oracle Data Type support: both simple and complex data types are supported. Large-object fields (LOB) are properly scripted even when they reach or exceed Oracle inline restrictions for such fields.
  • Custom mapping feature: gives you total control on how the tables and views from both databases being compared are paired together.
  • Custom Comparison keys: Oracle Data Compare allows you to define your own custom comparison keys based on any combination of available fields. The comparison keys are used to pair the rows from both sides.
  • View differences: a flexible comparison results grid makes it easy and efficient to see the color coded data differences.
  • Safe synchronization scripts: Oracle Data Compare generates safe, transactional synchronization scripts that allow you to synchronize in either direction.
  • Robust Script Execution Engine: no script is too large for Oracle Data Compare - the proprietary script execution engine ensures that large scripts including scripts for LOB fields are executed successfully and efficiently.
You can download the new version here...

Jul 06, 2011
xSQL Data Compare for SQL Server Version 4 released
We have just released a brand new, completely re-worked version of our xSQL Data Compare for SQL Server. Coming 7 years after the release of the very first version of xSQL Data Compare, the new version 4 reflects a wealth of accumulated experience and a countless amount of comments and suggestions we have received from our users during those years. Here is what's new in version 4 of SQL Server Data Compare:
  • New comparison engine - robust, highly efficient comparison engine compares millions of rows faster while tightly controlling resource utilization.
  • New modern GUI: the graphical user interface has been completely reworked to reflect the latest standards in user interface design.
  • Workspace: an improved, simplified workspace that provides for a one click re-compare eliminating the hassle of repeatedly configuring comparison sessions.
  • Improved memory management: eliminates any database size limitations due to memory constraints. Custom built algorithms handle serialization of both data rows and script fragments as needed.
  • Error handling: non-critical errors are registered and reported but do not stop the data comparison operations.
  • Enhanced functionality: many new options have been added like the ability to compare views, ability to compare databases with different collations, variable transaction size etc.
  • Mapping Rules: allow the user to customize the way the database objects are paired together. Mapping rules include schema mapping, object name mapping and data type mapping.
  • Key validation: in addition of the data type compatibility the new SQL Server Data Compare provides for validating the uniqueness of the selected comparison key.
  • Improved Scripting: especially for binary fields and large text fields. The script for large fields is generated in fragments of a predefined size and sent to SQL Server one block at a time.
You can download the new version here...

Nov 09, 2010
xSQL Documenter V4 released and new build of xSQL Builder available
Just released xSQL Documenter V4 with the following new features/enhancements:
  • Support for Microsoft Integration Server 2005/2008, Teradata 13 and SQLite;
  • Enhanced Extended Property Editor to support more platforms and support for comments on procedure parameters;
  • A new "columns" section for table valued functions showd what columns they return (SQL Server only);
  • Deterministic, schema bound and inline properties for functions were added (SQL Server only);
  • Ability to suppress object dependencies on schemas (SQL Server only);
  • Ability to specify max number of threads in GUI (the equivalent of the command line switch /threads);
  • Support for replacing tabs with spaces in DDL;
  • Scripting of users, logins, and roles for SQL Server;
  • Support for connecting to Oracle using ODBC;
  • More details in the foreign keys section for SQL Server;
  • Specify sample rows from tables separately from sample rows for views since views can be very "expensive";
  • Ability to order sample rows;
You can download the new version here...

The new build of xSQL Builder improves the handling of the backup files when the users chooses the "Create destination database from a backup" option and also comes with a new and improved install mechanism. You can download the new build here...

Aug 18, 2010
A new build of xSQL Data Compare is available for download
The new build of xSQL Data Compare introduces two small changes that should not affect the majority of the users:
  • A bug fix for very large Sql Server numeric values that trigger an overflow exception when converted to .NET native type (decimal in this case).
  • An enhancement related to the way values of the type hierachyId are handled. The hierarchyId values will be scripted and synchronized even when they are not well constructed.
You can download the new build here...

May 26, 2010
xSQL Database Comparison tools version 3.5 with support for SQL Server 2008 R2 released
We have just published version 3.5 of our database comparison tools, xSQL Object and xSQL Data Compare now with support for SQL Server 2008 R2. Following is the complete list of changes:
  • Support for SQL Server 2008 R2
  • The passwords for SQL Server connections are now encrypted and stored in the workspace file thus eliminating the need to enter the password each time the xSQL comparison tools are launched
  • Fixes the discrepancies between the name in the object definition and the name in the system catalog. This enhancement addresses an issue caused when the sp_rename procedure is used to rename objects with sql definition such as procedures, views, functions and triggers. The procedure sp_rename in these cases changes only the name in the sys catalog, but it does not change the name in the object's definition. This particular problem manifests itself mostly on SQL Server 2000 databases.
  • A new schema options named "Include objects with invalid dependencies" replaces the previous option named "Include views with invalid dependencies"; in addition to views this option now affects stored procedures, functions and triggers.
  • Trial expiration issue on Windows Vista and Windows 7 with UAC on. The enhancement addresses an issue with early expiration of xSQL Object and xSQL Data Compare trial period on Windows Vista and Windows 7 when the UAC is turned on - it guarantees that both tools will be fully functional with no restriction for the duration of the trial period. After the trial, the ../products will revert to Lite edition.
  • Some enhancements and bug fixing in the command line utilities including a newly added error code that tracks script execution errors.
  • A fix to stored procedure multi-line comments.
  • An enhancement in the way xSQL Data Compare handles identity columns. Explicit updates of the identity columns are no longer supported and will trigger data warnings.
You can download the new version here...

May 10, 2010
New build of xSQL Database Version Control available for download
[DISCONTINUED] A new build of xSQL Version Control (xSQLVC) for SQL Server is now available for download. The new build simplifies the configuration steps while giving you more choices on how you wish to copy the master development database from the master server to your local machine - in addition of the backup and restore option you can now copy all or part of the database via SQL Scripts. You can read more about xSQLVC here... [DISCONTINUED]

Mar 15, 2010
xSQL Database Version Control released
[DISCONTINUED] We are happy to announce the release of xSQL Version Control (xSQLVC) for SQL Server. xSQLVC is the SQL source control utility you have been waiting for - it allows teams of developers to work worry-free on their local copies of the database while ensuring that all changes that they make are automatically documented and propagated throughout the development team - your development team synchronized.

xSQL Database Version Control allows users to:
  • Get a copy of the master development database onto their machine.
  • Auto generate database change scripts that can be checked in to the master.
  • Get changes that other developers may have checked in.
  • Maintain a complete history of database changes.
  • Organize database change scripts into releases.
  • Rollback changes if and when necessary.
  • View who has done what changes to the database, when and why.
  • Focus on development instead of consuming the energy managing database changes.
  • Supports SQL Server 2008/2005/2000
You can read more about xSQLVC here... [DISCONTINUED]

Jan 24, 2010
xSQL Profiler 1.7 released
A new version of xSQL Profiler including new features and improvements is now available for download. This new version includes:
  • ability to load the trace data directly to the central repository from a network share without having to go through the monitored servers temp db;
  • ability to set different polling intervals for each server for a given trace;
  • option to set server level traces reducing the number of traces that will need to be started on the monitored server when database level filtering is applied

Jan 12, 2010
xSQL Profiler 1.6 released
A new version of xSQL Profiler including new features and improvements is now available for download. This new version includes:
  • ability to load the trace data directly to the central repository from a network share without having to go through the monitored servers temp db;
  • ability to set different polling intervals for each server for a given trace;
  • option to set server level traces reducing the number of traces that will need to be started on the monitored server when database level filtering is applied

Feb 23, 2009
Script Executor 3 with support for SQL Server and MySQL released
We are very excited to announce the release of Script Executor 3 with support for SQL Server and MySQL. Script Executor provides for deploying multiple Sql Scripts against multiple target servers/databases.

Script Executor allows the user to:
  • Organize target databases into logical database groups.
  • Organize Sql Scripts into logical script containers that can be nested similarly to the windows folder structure.
  • Map script containers to databases groups indicating that all scripts in the given container should be executed against all databases on that group.
  • Tweak the mapping by including /excluding certain scripts and databases from the group mapping.
  • Execute all the selected scripts against all the selected databases based ont he mapping with one click.
  • Get a comprehensive execution report with details on the execution of each script.
  • View the result sets from all queries in one integrated interface.
  • Save the deployment package configuration for future use.
  • Generate self-contained executable that can be shipped to the end user who can now deploy the scripts to the target databases without any software or database knowledge.
  • Supports SQL Server 2008/2005/2000 and MySQL 5.0/5.1
You can read more about Script Executor here...

Nov 12, 2008
xSQL Documenter 2.0 released
We are very happy to announce the release of xSQL Documenter 2.0 that adds support for Sybase's SQL Anywhere, support for columns level dependencies and more.

New in this release:
  • Support for SQL Server 2008
  • Support for Sybase SQL Anywhere 10.0 and up
  • Adds a "choose objects" page in the GUI where you can specify what object types you want to document.
  • Support for all DBMS platforms in the "exclude objects" GUI. Previously this GUI supported only SQL Server.
  • Support for arbitrary HTML in database comments – see /pt command line switch.
  • Analysis Server: support for XML comments in MDX scripts. This enables documentation of calculated members.
  • Support for cross database and cross server dependencies (through linked servers)
  • Support for column dependencies (which columns of which table a stored procedure selects or updates.
  • SQL Server: support for XML comments on objects that don't have their DDL stored on the server, such as tables. This is implemented with extended properties.
  • SQL Server: add extended properties filter. Using this you can restrict by name the extended properties that are fetched by xSQL Documenter.
You can read more about xSQL Documenter here...

Oct 06, 2008
Multiple releases - xSQL Tools now support SQL Server 2008
October 6 marks a major release event for xSQL Software tools. A new version with full support for SQL Server 2008 was released for the following tools:
  • xSQL Object
  • xSQL Data Compare
  • xSQL SDK
  • xSQL Builder
  • RSS Reporter
  • xSQL Object Search
  • xSQL Script Executor

With this new version you can now work with databases from three generations of SQL Server: SQL Server 2000, SQL Server 2005 and SQL Server 2008. Some of the new and enhanced features introduced by this new version of our database comparison and synchronization tools include:
  • Support for all new or enhanced data types such as geography, geometry, hierarcgyID etc.
  • Support for the table level change tracking feature introduced by SQL Server 2008.
  • Data compression support for tables, primary key constraints, unique constraints and indexes.
  • Support for the enhanced full-text catalogs and indexes.
  • Support for Remote Service bindings for Service Broker.
  • Improved object dependency handling.

Sep 17, 2008
xSQL Profiler 1.5 released
We are excited to announce the release of a new version of xSQL Profiler which in addition of significant performance and other improvements on the core it includes custom query templates that allow the user to gain invaluable insight from the trace data that the xSQL Profiler collects. With the click of button you can now see which queries are bogging a particular server down because of CPU consumption, I/O traffic, Reads or Writes. xSQL Profiler Supports SQL Server 2008, SQL Server 2005 and SQL Server 2000 all editions and continues to be free for up to two SQL Server instances.  more »

May 20, 2008
xSQL Profiler released
xSQL Profiler is an easy to install, easy to use, agent-less SQL Server monitoring tool that can be utilized for performance, auditing and compliance related tasks. Monitor multiple SQL Servers from one central location - choose SQL Servers and databases you want to monitor, define precise traces to trace exactly what you need, nothing more nothing less, schedule the traces and forget it - xSQL Profiler takes care of the rest.  more »

Mar 04, 2008
xSQL Documenter released
Comprehensive, uniform, and easily navigable database documentation for all your applications. Generates documentation in HTML and CHM format; supports all major database management systems: SQL Server, Oracle, DB2, MySQL, Informix IDS, Sybase ASE, PostgreSQL, Access, VistaDB, ENEA Polyhedra; can run as a console application; documentation can be branded; supports XML comments added to your objects and a lot more »

Dec 06, 2007
Free service released: Check Your SQL Server Security
CheckSQL.com is free web based service that performs some basic security checking on an IP address that you provide. It first attempts to open a TCP/IP connection on the default SQL Server port on the given IP address - if your server is not listening on the default port and/or, in the case of SQL Server 2005, is installed with a named instance the service will not be able to establish a connection and therefore the testing will stop; if it is able to establish a TCP/IP connection it will then check for the SQL Server version you have installed and will let you know if you have not installed the latest service pack; lastly, it will attempt to log in using a very small set of commonly used usernames and passwords (ex: sa / password) and if it succeeds it will let you know.

Sep 24, 2007
Free tools released: xSQL Script Executor and xSQL Object Search
xSQL Object Search is a free tool that provides for locating database objects by checking their names and/or definition against a search criteria. You can search on one or multiple databases simultaneously, select from various search options, search for all or specific objects types, export the results to output files and more.

Sep 14, 2007
xSQL Bundle receives highest marks and praise from SSWUG
We just received word that Stephen Wynkoop, Microsoft SQL Server MVP and SSWUG founder, has conducted a professional review of our SQL Server database compare and synchronization bundle. We were naturally excited and worried when we first got it but as we carefully read through it excitement and joy would best describe the feelings of the team - Stephen had been duly impressed with our schema and data compare products and had given them the highest rating possible in all aspects of the review, overall score, installation, usage and real-World usefulness. You can read Stephen's review here...

Sep 01, 2007
xSQL Builder 1.0 released
A new tool is now available to the efficiency-minded database administrators and software developers – xSQL Builder for SQL Server. Built on top of the xSQL Software's robust comparison and synchronization platform it provides for generating self-contained executable packages that can then be deployed as stand-alone applications or as part of a bigger deployment solution.
The source code of the C# classes that contain the compare and synchronize code that will run on the client machine is included with the package thus providing for the un-restricted customization possibilities.  more »

Jul 16, 2007
New RSS Reporter for SQL Server V2.0 released
Now with support for ad-hoc query feeds as well as database size and space allocation feeds.
New in this release
  • Ad-hoc query feeds – you can generate RSS feeds containing the output of a T-SQL query. Write the query, choose the field(s) you want to use as the feed item title, number of fields you want to display across a row and click save – the feed is automatically generated for you and is ready for consumption.
  • Database info feeds – you can now conveniently monitor database size and space usage through a simple RSS feeds delivered right to your device of choice.
 more »

Jun 18, 2007
RSS Reporter for SQL Server released
We are very excited to announce the release of an innovative new tool for SQL Server database administrators, the RSS Reporter. No more cluttering your mailbox with hundreds of SQL Server notifications, no more digging through those emails to get the information you need, no more missed important notifications... You can now, in minutes, generate standard RSS feeds that contain all the information you need for monitoring SQL Server jobs running on multiple servers. You can then subscribe to those feeds and read them from any connected device - clean, simple, and standard.  more »

Apr 16, 2007
New version 2.5 with command line utilities
We are happy to announce the release of version 2.5 of our xSQL Bundle which now includes a Command Line utility for scheduled, unattended SQL Server database schema and data comparison and synchronizations.
New in this release:
  • xSQL Object Command Line utility, easily configurable via the xSQL Object interface, that allows you to schedule database schema comparison and synchronization operations via the Windows Task Scheduler, SQL Server scheduler etc.
  • xSQL Data Compare Command Line utility, easily configurable via the xSQL Object interface, that allows you to schedule database schema comparison and synchronization operations via the Windows Task Scheduler, SQL Server scheduler etc.
  • Comparison wizards for quick comparisons and synchronizations in both xSQL Object and xSQL Data Compare.
  • Comparison session that allows you to save all the selections you have made during a comparison like the types of objects to be included in the comparison, comparison options you have selected etc. Once saved you can load the session at any time and perform the exact same comparison without having to go through the comparison configuration steps again.
  • Object counts that are now displayed next to each object type in the left panel object tree provide a quick "view" of the size of the database.
  • You can now launch Query Analyzer or SSMS right from the xSQL Object's and xSQL Data Compare's synchronization script window with one click.

Enhanced and improved:
  • To better accommodate the large number of SQL 2005 object types, the object tree on the left panel of the workspace has been organized in groups similar to the way they are organized in SSMS.
  • Navigation through schema snapshots to find what you are looking for is a lot easier - before adding the snapshot to the workspace you can now see the date when the snapshot was taken, the database, the server and the SQL Server version.
  • Database scripting functionality has been completely revamped to better handle very large scripts - it runs in asynchronous mode, the memory usage is capped and it provides progress information while executing.
  • Scripting of Xml Schema Collection object has been improved to display as a properly formatted Xml file.
  • The scripts can now be saved in one of the following encoding types: ANSI (default), ASCII, Unicode, UTF7 and UTF8. You can easily change the encoding type by modifying the value for the scriptFileEncoding key in the xSQLObject.exe.config file
  • Support for bulk insert scripts has been enhanced to allow the user to define custom field and row terminators to ensure that the bulk insert will not fail even when the data in a field contains the terminators commonly used for such purpose.
  • File group "translation" allows for synchronization of databases with different file group structures.
  • For each object type the number of objects found equal, different, only on the left or only on the right is now displayed next to each object type header in the comparison results grid.
  • From the comparison results window you can quickly create a Command Line configuration file.
  • The side to side object script panels on the lower section of the comparison results window can now scroll together or independently - you can "link" or "un-link" the panels from the right-click (context) menu.
  • Comparison results Print/Preview functionality has been improved significantly with the introduction of a table of content that provides a summary of the comparison results, object filtering etc.
  • Schema filters are easier to set now through a much more intuitive interface.
  • xSQL Data Compare comes with a few new options like "regional settings", "bulk file configuration" etc.
  • A separate where clause can now be defined for each table on a pair.
  • Execution of data synchronization script has been enhanced to better handle very large scripts, provide progress information and allow the user to safely cancel the execution at any time during the process.