You'll receive

Bi-weekly updates

Exclusive discounts

Product update alerts

Tools for Security and Compliance ApexSQL Security and Compliance Toolkit for SQL Server
Tools for DBAs and Operations Engineers ApexSQL Operations Toolkit for SQL Server
Tools for SQL Server Professionals ApexSQL Fundamentals Toolkit for SQL Server
Tools for Developers and DevOps Engineers ApexSQL DevOps Toolkit for SQL Server
Tools for MySQL Professionals ApexSQL Fundamentals Toolkit for MySQL Server
Spotlight Cloud hosted SQL Server monitoring and diagnostics
LiteSpeed High-speed SQL Server backup, compression and restore
 

ApexSQL Analyze release notes

Release:

2022.01.0222

Date:

May 12, 2022

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

    Release:

    2020.02.0210

    Date:

    April 14, 2021

    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

    Release:

    2020.01.0190

    Date:

    August 24, 2020

    Enhancements:

    Fixes:

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

    Changes:


    Release:

    2019.02.0163

    Date:

    December 19, 2019

    Enhancements:

    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

    Release:

    2019.01.0129

    Date:

    July 15, 2019

    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

    Release:

    2018.05.0067

    Date:

    June 21, 2019

    Changes:


    Release:

    2018.05.0062

    Date:

    May 09, 2019

    Enhancements:

    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

    Release:

    2018.04.0055

    Date:

    February 12, 2019

    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

    Release:

    2018.03.0053

    Date:

    October 23, 2018

    Enhancements:

    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

    Release:

    2018.02.0052

    Date:

    August 10, 2018

    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

    Release:

    2018.01.0035

    Date:

    December 13, 2017

    Features:


    © 2022 Quest Software Inc. ALL RIGHTS RESERVED.   |   GDPR   |   Terms of Use   |   Privacy