For the best web experience, please use IE11+, Chrome, Firefox, or Safari

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: