ApexSQL Analyze Changelog

What's new in ApexSQL Analyze 2020.02.0210

Apr 14, 2021
  • Fixes:
  • "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
  • "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
  • "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
  • "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

New in ApexSQL Analyze 2019.02.0163 (Dec 19, 2019)

  • 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

New in ApexSQL Analyze 2019.01.0160 Patch (Sep 25, 2019)

  • Fixes:
  • The project cannot be opened when the column dependencies option under the View tab is enabled
  • The application stops working and the project cannot be saved when specific snapshot is loaded

New in ApexSQL Analyze 2019.01.0129 (Jul 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

New in ApexSQL Analyze 2018.05.0067 (Jun 21, 2019)

  • 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

New in ApexSQL Analyze 2018.05.0062 (May 9, 2019)

  • 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

New in ApexSQL Analyze 2018.04.0055 (Feb 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

New in ApexSQL Analyze 2018.03.0053 (Oct 23, 2018)

  • 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

New in ApexSQL Analyze 2018.02.0052 (Aug 9, 2018)

  • Fixed:
  • 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

New in ApexSQL Analyze 2018.01.0049 Patch (Jul 16, 2018)

  • Fixes:
  • "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

New in ApexSQL Analyze 2018.01.0047 Patch (Jun 5, 2018)

  • Fixes:
  • Connected SQL Server version is not visible in application log file

New in ApexSQL Analyze 2018.01.0043 Patch (Apr 23, 2018)

  • Clicking the Help button in the Resources tab leads to a missing web page

New in ApexSQL Analyze 2018.01.0041 Patch (Mar 9, 2018)

  • Fixes:
  • "Object reference is not set to an instance of an object" error message is shown when analyzing a database that contains a syntax error

New in ApexSQL Analyze 2018.01.0039 Patch (Feb 5, 2018)

  • Fixes:
  • An unhandled exception is experienced when selecting an object and clicking the "Show script" button

New in ApexSQL Analyze 2018.01.0038 Patch (Jan 24, 2018)

  • Fixes:
  • The silent installer 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