xSQL Data Compare for SQL Server

By xSQL Software Free

Developer's Description

xSQL Data Compare for SQL Server is a tool for comparing and synchronizing the data in two SQL Server databases. You can use it for data migration, auditing, replication verification, populating development databases with production data. Some of the features include: 1) Full support for SQL Server 2019, SQL Server 2017, SQL Server 2016, SQL Server 2014, SQL Server 2012, SQL Server 2008R2, SQL Server 2008 , SQL Server 2005, and SQL Server 2000; 2) Cross version comparison - compare databases on different SQL Server versions; 3) One-click re-compare - complete comparison configuration stored in session allows for a one click re-compare; 4) Custom mapping rules feature allows the user to customize the way database objects are paired together. Mapping rules include: "Schema mapping rules" that determine how the schemas are mapped; "Name mapping rules" that determine how the object names are mapped; and "Data mapping rules" that determine how data types are mapped; 5) Custom comparison keys - need to compare tables or views but they are showing as non-comparable because there is no primary key or unique indexes defined on them? Once xSQL Data Compare for SQL Server has analyzed the schema it will allow you to define a unique key (any combination of the fields of that table) to use for the comparison. The rows are paired based on the selected key. 6) Command Line utility - the included, highly configurable command line utility allows you to schedule comparison and synchronization operations via the Windows Task Scheduler, SQL Server Scheduler. 7) Handling large databases - custom built algorithms handle serialization of both data rows and script fragments as needed ensuring strict control of the memory utilization. 8) Script execution engine - the proprietary, intelligent script execution engine ensures that very large t-sql scripts including scripts for binary columns and large text columns are executed successfully while providing continuous progress information and allowing you to safely interrupt the script if necessary.

Full Specifications

What's new in version 11.0

Version 11.0:
  • Support for SQL Server 2019 (also supports SQL Server versions from 2000 to 2016)
  • Support for SQL Azure databases
  • Support for Azure Active Directory Authentication

General

Release March 22, 2020
Date Added March 22, 2020
Version 11.0

Operating Systems

Operating Systems Windows 10, Windows 2003, Windows Vista, Windows, Windows Server 2016, Windows 2000, Windows 8, Windows Server 2008, Windows 7, Windows XP
Additional Requirements .NET Framework 4.0

Popularity

Total Downloads 1,095
Downloads Last Week 0
Report Software

Related Software

xSQL Script Executor

Free
xSQL Script Executor

2007 Office System Driver: Data Connectivity Components

Free
2007 Office System Driver: Data Connectivity Components

Microsoft Access 2010 Runtime (32-bit)

Free
Microsoft Access 2010 Runtime (32-bit)

Microsoft SQL Server 2008 Express (64-bit)

Free
Microsoft SQL Server 2008 Express (64-bit)

Best VPN Services for 2020

Best for privacy

3 months free with 1-year plan

Best for customer support

$39.99 for the first 12 months

Best for zero logs

$4.87.99/months for a 1-year plan

Best money-back guarantee

$2.99/months for a 3-year plan