ApexSQL Data Diff 2016 R2 – Product update alert

ApexSQL Data Diff 2016 R2 has been released

Type: Medium feature, major fix release

About ApexSQL Data Diff: ApexSQL Data Diff is a SQL Server data comparison and synchronization tool that detects data differences and resolves them without errors. It compares and synchronizes live databases and native or natively compressed backups and generates comprehensive reports on the detected differences.

For more information, visit the ApexSQL Data Diff product page

About this release:

Enhancements:

• SQL Server 2016 support
• Schema mapping
• Save project as batch
• Improved HTML reports
• Help to HTML switch
• Ignore new objects switch
• Silent switch
• Return error codes switch
• 17 new CLI return error codes
  • Invalid switch
  • Duplicated switch
  • Missing argument
  • Missing a dependent switch
  • Value out of range
  • Invalid file path
  • Invalid project file
  • Unsupported edition
  • Invalid activation key
  • Trial has expired
  • Connection timeout
  • Connection failed
  • Operation canceled
  • Application error
  • Execution error
  • Execution timeout
• Improved output messages:
  • Comparison summary
  • Warnings output
  • Synchronization summary
  • Changes output
• Enhancements in previously supported Azure SQL Database V12 object types:
  • Tables:
    • ON keyword
    • TEXTIMAGE_ON
    • column_definition
      • NOT FOR REPLICATION
      • ROWGUIDCOL
    • column_constraint, computed_column_definition, table_constraint
      • FILLFACTOR
      • ON
      • NOT FOR REPLICATION
    • index_option
      • PAD_INDEX
      • FILLFACTOR
      • ALLOW_ROW_LOCKS
      • ALLOW_PAGE_LOCKS
      • DATA_COMPRESSION
      • ON PARTITIONS
  • Views:
    • WITH ENCRYPTION

Improved quality:

• 36 bugs and known issues fixed

See also:
Release notes
Download