ApexSQL Compare release notes

Fixes:

• The add-in icons disappear in SQL Server Management Studio 2012 and 2014 when installed in parallel with any other ApexSQL add-in product released after January 22, 2018

Features:

• Integrated file editor
• Save as batch feature is added under the Save button from the Home tab
• High DPI and 4K resolution support
• Applied concepts of Visual Language Dictionary for Visual Studio for iconography, imagery, colors, menus, fonts, formatting and other GUI elements
• CLI switches:
  • Set the file size type for the files that will be ignored with the /ignore_bigger_than switch [/fst]:
    • Byte
    • KB
    • MB
    • GB
    • TB
    • Default [dft] - MB
  • Set the author name for the comparison report [/auth]
  • Set the legal information for the comparison report [/leg]

Fixes:

• Compared files are shown as equal, if the line ending of the compared files is different than Microsoft Windows
• HTML tags are overlapping in exported HTML report making it unreadable when two HTML files are compared
• The Export to HTML option does not work when two database objects are compared
• "Error on loading configuration file: C:\Users\UserName\AppData\Local\Temp\MergeDiff.Configuration.xml" error is encountered when any combination of CLI switches is executed
• A blank HTML report is generated through the CLI, when database objects are used for the comparison
• Missing the line numbers in HTML report
• Incorrect checkbox positioning for different lines in the comparison preview window when the Check all left or Check all right buttons are clicked
• Missing the option to choose whether to integrate to Windows Explorer or not, in the integration step of the installation wizard
• Horizontal scroll bar does not work in the HTML report if it's resized, so that status bar with difference number goes over the horizontal scroll bar
• SQL Server Management Studio stops working when any system user is right-clicked in Object Explorer and loaded for comparison
• SQL Server Management Studio stops working when the Check all left button is clicked
• "The process cannot access the file 'C:\FileName.txt'" error is encountered when the drop-down list for recent files is opened to select different file that is currently opened, after comparing two files
• "Both sides need to have loaded files in order to generate the merged script" message is shown upon starting the New comparison and previous comparison was closed without saving the merge script in SQL Server Management Studio
• The Show last opened project option is not loading the last opened project upon starting the application
• Merged script has inconsistent line ending if the Word wrap option is not checked upon the opening of merged script
• The add-in theme color in SQL Server Management Studio and Visual Studio is changed to white theme when default options are loaded in the Options dialog
• “The file does not exist or it has been removed” message is shown when trying to delete a path under the File compare dialog
• "ApexSQLCompare_InstPackage" warning message is shown in Visual Studio 2017 during the unistallation of the application
• “Compared folder are equal” message is shown when editing current project and the Cancel button is clicked
• The path from the previously loaded scripts stays in the dropdown box even if new scripts are loaded from the Object Explorer pane
• The Browse button for the Export folder under the Output tab in the Options window doesn't open the default specified path
• Changed project options are remembered when the Cancel button is clicked while editing the current project
• Changed options in the Options window are remembered when the Cancel button is clicked

Changes:

• CLI switches /username1 and /username2 are now /user1 and /user2 respectively

Fixes:

• "Microsoft SQL Server Management Studio 17 is not installed. Please install this version to integrate into" message is shown in the add-in integration step of the installation wizard when SQL Server Management Studio 17.4 is installed
• The choosen highlight color for differences is not applied in both panels when the OK button is clicked in the Difference highlights window
• Incorrect procedures are compared when choosing procedures with the same name, but different schemas from the same database for the comparison

Features:

• Supports SQL Server Management Studio 2012 integration and higher
• Supports Visual Studio 2010 integration and higher
• Supports Windows Explorer integration
• Supports SQL Server 2005 and higher
• Supports Azure SQL Database
• Supports SQL Server on Amazon RDS
• Supports file and folder comparison
• Compare SQL Server objects directly from SQL Server Management Studio and Visual Studio
• Two-way comparison and merge
• Three comparison modes:
  • Character
  • Line
  • Block
• Syntax highlighting for 9 languages:
  • C#
  • C++
  • HTML
  • JavaScript
  • PostgreSQL
  • Python
  • T-SQL
  • Visual Basic
  • XML
• Ignore options for the comparison process:
  • Ansi options
  • Authorization
  • Collation
  • Comments
  • Constraint names
  • Filegroups
  • Indexes
  • Lock escalation
  • Permissions
  • With encryption
• Export comparison results into HTML report
• Command line interface
• GUI themes