ApexSQL Data Diff 2012 R3 – Product update alert

ApexSQL Data Diff 2012 R3 has been released

Type: Maintenance release

About ApexSQL Data Diff: ApexSQL Data Diff is a SQL Server data comparison and synchronization tool which detects data differences and resolves them without errors. It can compare and sync live databases and native or natively compressed database backups and generate comprehensive reports on the detected differences.

August 13, 2013

SQL Solution center round-up – July 5th, 2013

In the latest SQL Solution center articles we focused on SQL Server database auditing techniques and recovery options

Here is the aggregated summary for the past two weeks:

July 12, 2013

SQL Server data comparison customized for performance – vertical filtering and Comparison options

As the previous post indicated, we will focus now on vertical filtering and comparison options.

ApexSQL Data Diff also provides the ability to choose only specific columns to be analyzed aka vertical filtering. By default, all columns are analyzed. You can choose which columns to analyze by selecting the object containing those columns clicking on the appropriate Columns field, and deselecting the columns you want to exclude.

July 11, 2013

SQL Server data comparison customized for performance – the data cache location and Object filter

Comparison and synchronization of SQL Server database data from different data sources can be very time and resource demanding. It is highly dependant on hard drive writing speed, network bandwidth, memory size and speed, CPU speed, and the size of the data. Therefore, ApexSQL Data Diff, a SQL tool for data comparison, incorporates some options that could help you get better performance and increase comparison speed.

July 9, 2013

SQL Solution center round-up – June 21st, 2013

In the past two weeks we had some interesting SQL Solution Center articles describing SQL Server topics – each described as a problem (or a challenge) users may encounter with data recovery. Here is the aggregated summary:

July 5, 2013

ApexSQL Data Diff has gone PRO

We’ve now released two versions of ApexSQL Data Diff – Developer and Professional

What’s the difference?

ApexSQL Data Diff Professional has the following additional features:

  • Support for native or natively compressed database backups
  • Pre and post-synchronization scripts
  • Command Line Interface (CLI)
March 20, 2013

ApexSQL Data Diff 2012 R2 – Product update alert

ApexSQL Data Diff 2012 R2 has been released

Type: Maintenance release

About ApexSQL Data Diff: ApexSQL Data Diff is a SQL Server data comparison and synchronization tool which detects data differences and resolves them without errors. It can compare and sync live databases and native or natively compressed database backups and generate comprehensive reports on the detected differences. For more information, visit the ApexSQL Data Diff product page

March 19, 2013

ApexSQL Data Diff 2012 data comparison performance improvement

ApexSQL constantly improves its tools by revising and optimizing their code and introducing new features/options. Regarding ApexSQL Data Diff 2012 vs ApexSQL Data Diff 2011, there have been significant performance improvements while using both approaches. Source code was modified and no major changes in behavior/GUI/options have been made. Also, new options were introduced that changed the tool’s behavior. The newly added options are Show equal rows, Use checksum for large values comparison and selective database re-comparison logic; their impact on ApexSQL Data Diff performance will be described later

March 11, 2013