ApexSQL Analyze release notes

Enhancements:

• SQL Server 2019 support

Fixes:

• Depending columns for SQL view objects are not show in the Dependencies panel
• ”Login failed for user” error is encountered when using the Active Directory - Integrated authentication in SQL Server Management Studio and when the Show dependencies command is initiated from the right-click context menu in Object Explorer
• SQL Server Management Studio stops working when the Show dependencies command is selected from the right-click menu in Object Explorer on a database without required permissions

Enhancements:

• SQL Server Management Studio integration support
• Visual Studio integration support
• Show column dependencies option is added under the View tab
• Diagrams can be exported as DOCX, PDF and XML
• EMF file fomat is added when diagram is exported as an image
• Print option is added under the Home tab
• Object style customization is added under the Options window
• External database analysis option is added in the project options under the External databases tab
• Update all objects from the schema option is added under the Home tab
• Show/hide constraints option is added under the View tab
• Include system objects option is added under the General tab in the Options window
• Show dependencies for the snapshot option is added in the project options
• Project options window is added for creating a new project

Fixes:

• Different values for constraints are shown in the Object browser of ApexSQL Analyze and in SQL Server Management Studio’s Object Explorer
• Saved project file can’t be opened with a double-click on it
• Toggling user type items on and off in the analyzed diagram displays inconsistent behavior when a related schema with the same name exists

Changes:

• The application has been split into three editions - Azure, Standard and Professional
• Diagram now allows customization of dependency depth

Changes:

• Software Transaction Agreement is added as a new step in the installation wizard and updated in accordance with https://www.quest.com/legal/sta.aspx

Enhancements:

• Active Directory support for:
  • Integrated authentication
  • Password authentication
  • Universal with MFA support authentication

Fixes:

• Unable to switch between ApexSQL Analyze and any other opened application when the full-screen mode is used
• The object selection is changed when the selected region is exported with the Export as part option
• Analyzed diagram is shown when nothing is checked in the Object browser panel
• Unreferenced objects are hidden when the saved project is loaded
• The PNG format does not support black background

Changes:

• The application now requires Microsoft .NET framework 4.7.2

Fixes:

• The Extend evaluation button does not open default e-mail client when clicked and the application is opened in the Community edition
• Missing information message when the Extend evaluation button is clicked and there is no default e-mail client
• "Object reference not set to an instance of an object" error message is encountered when a project file is opened

Enhancements:

• SQL Server 2019 CTP 2.0 support
• Improved application installer with a dark theme

Fixes:

• "Object reference not set to an instance of an object" error is encountered when a saved project is opened
• Wrong project file extention .axde is shown in the Open projects dialog

Fixes:

• "Loading object and dependencies failed" error is encountered when the Connect button is clicked in the Connect to SQL Server window for SQL Server 2017 version: 14.0.1000.169
• "Loading object and dependencies failed" error is encountered when the Connect button is clicked in the Connect to SQL Server window to connect to the AdventureWorks2016CTP3 database
• Clicking the Help button in the Resources tab leads to a missing web page
• "Object reference is not set to an instance of an object" error message is shown when analyzing a database that contains a syntax error
• "Object reference not set to an instance of an object" error is encountered when selecting an object and clicking the "Show script" button
• The silent installation is stopped when the application needs to automatically download and install .NET Framework, even when the /verysilent switch is used
• The application repeatedly asks for the activation key when it is started on an Amazon EC2 instance after the virtual machine resources were deallocated and allocated again

Features:

• 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
• Supports SQL Server 2005 or higher, Azure SQL Database and Amazon RDS for SQL Server
• Analyze graphical SQL objects dependencies
• Customize and manipulate dependency diagrams
• View dependency type and level details
• View dependency lists and tables
• Show/hide unreferenced objects
• Inverted selection of objects
• Show SQL object scripts
• Export dependency diagrams to BMP, JPEG and PNG formats
• GUI themes