ApexSQL Analyze release notes

Fixes:

• 211654: "Could not load file or assembly 'Microsoft.Identity.Client'" error is encountered when trying to connect to the Azure server with Active Directory - Universal with MFA type of authentication
• 211716: Couldn't connect to the targeted database in the case when using Azure Active Directory - Password authentication type while database name is typed in connection controls
• 211717: Couldn't connect to the targeted database in the case when using Azure Active Directory - Integrated authentication type while database name is typed in connection controls

Changes:

• The activation model is switched to Subscription
• The application does not support integration into SQL Server Management Studio 2012, 2014, and 2016 versions
• The application does not support integration into Visual Studio 2010, 2012, 2013, and 2015 versions

Known issues:

• "The 'ApexSOLAnalyzeJnstPackage' package did not load correctly" error is encountered when the Visual Studio 2019 16.7 version is started
• "Failed to authenticate the user in Active Directory (Authentication=ActiveDirectoryInteractive). Error code 0xno_client_id No ClientId was specified." Error is encountered when the Show dependencies feature is initiated and the user is connected to a remote server using Azure Active Directory - Universal with MFA authentication

Fixes:

• 205740: "Database '%database name%' not accessible for the user '%username%'" error is encountered when trying to Link database using ApexSQL Source Control when ApexSQL Analyze is integrated into SQL Server Management Studio
• 192415: "Object reference not set to an instance of an object" error is encountered when query execution is canceled due to endless running time in SQL Server Management Studio 18 when the ApexSQL Analyze is integrated into it
• 205741: "Unable to create data instance" error is encountered when "One click documentation" is used for ApexSQL Doc when ApexSQL Analyze is integrated into SQL Server Management Studio
• 204596: "A connection was successfully established with the server but then an error occurred during the pre-login handshake provider HTTP, error: 0 -)" error is encountered when trying to connect on the SQL Server which has Force Encryption option enabled

Changes:

• "Trust server certificate" option is added under the Connection options dialog

Enhancements:

• Application telemetry now collects anonymous data on the use and performance of applications and application components
• New ApexSQL Updater allows users to configure advanced updating settings of all installed ApexSQL products

Fixes:

• "Loading objects and dependencies failed" error is encountered when loading a database with objects that reference synonyms for tables or views

Changes:

• Error handling and send logs functionality has been modified

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