ApexSQL Diff 2017 – Product update alert

ApexSQL Diff 2017 has been released

About ApexSQL Diff: ApexSQL Diff is a SQL Server and Azure SQL database comparison and synchronization tool which detects differences between database objects and resolves them without errors. It compares and synchronizes live databases, native or natively compressed database backups, database snapshots, scripts in source control and script folders and generates comprehensive reports on the detected differences.

For more information visit the ApexSQL Diff product page

About this release:

Enhancements:

• SQL Server Integration Services package comparison
• Ignore lock escalation property of tables option
• Create snapshot of destination database before synchronization
• Create rollback script for destination database before synchronization
• Create script folder backup for destination script folder or source control before synchronization
• XML export customization options:
  • Type:
    • Include different objects
    • Include equal objects
    • Include only source objects
    • Include only destination objects
  • Selection:
    • Include only checked objects
  • Details:
    • Include DDL scripts of checked objects
• Export schema comparison differences to SQL script and a database table
• Script difference panel options:
  • Change colors
  • Increase/Decrease font size
  • Find
  • Word wrap
• CLI switches:
  • Logging level [/log] with four levels:
    • Errors
    • Warnings
    • All
    • None
  • Play sound upon finished operation [/be]
  • Return error code on equal results [/rece]
  • XML export customization options [/xeo and /xeo2]
  • Create snapshot of destination database before synchronization [/csnp]
  • Destination snapshot file name [/sfn]
  • Create rollback script for destination databases before synchronization [/crbs]
  • Destination rollback script file name [/rsfn]
  • Create script folder backup for destination script folder or source control before synchronization [/bsf]
  • Destination script folder backup path [/bsfp]
  • Comparison summary output [/cso]
  • Synchronization warnings output [/wao]
  • Synchronization summary output [/suo]
  • Differential backup set [/bs1 and /bs2]
  • Integration services:
    • SSIS package store packages [/isps1 and /isps2]
    • Package files [/pfs1 and /pfs2]
    • SQL Server packages [/ssp1 and /ssp2]
    • SSISDB catalog packages [/sdbp1 and /sdbp2]
    • SSIS project file [/sspr1 and /sspr2]
• CLI no differences detected return code [102]

Improved quality:

• 32 bugs and known issues fixed

See also:
Release notes
Download