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

ApexSQL Unit Test release notes

Release:

2019.02.0179

Date:

February 12, 2021

Fixes:

  • 195497: "Object reference not set to an instance of an object" error message is shown on SQL Server Management Studio startup after the add-in installation

Release:

2019.01.0175

Date:

December 19, 2019

Enhancements:

  • SQL Server 2019 support

Fixes:

  • The uninstall confirmation message box appears is shown when the /verysilent and /suppressmsgboxes switches are used
  • "BatchCompleted error" error is encountered in SQL Server Profiler when SQL Server Management Studio is started

Release:

2018.04.0170

Date:

June 21, 2019

Changes:


Release:

2018.04.0164

Date:

May 02, 2019

Fixes:

  • The add-in doesn't integrate with SQL Server Management Studio 18 GA version

Release:

2018.03.0147

Date:

February 11, 2019

Fixes:

  • SQL Server Management Studio stops working when the Unit Test explorer button from the add-in toolbar is clicked for a SQL Server Analysis Services instance
  • SQL Server Management Studio stops working when the Unit Test explorer button from the add-in toolbar is clicked for a SQL Server Reporting Services instance

Changes:

  • The application now requires Microsoft .NET framework 4.7.2

Release:

2018.02.0146

Date:

November 09, 2018

Enhancements:

Fixes:

  • Creation of the sample database and Demo kit never ends

Release:

2018.01.0131

Date:

July 16, 2018

Enhancements:

Fixes:

  • 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
  • "Unable to get versions info" error occurs when we try to install tSQLt framework from Web source
  • A new query with a unit test template does not open when creating a new test class
  • The first letter of the unit test name will be removed if an empty space is not used when specifying a name of the new unit test
  • SQL Server Management Studio 2012 and 2014 stops working upon starting it with add-in installed from ApexSQL Installer
  • The add-in isn’t integrated into SQL Server Management Studio when it is installed via the Single installer for all tools

Known limitations:

  • “SQL Server Management Studio has stopped working” error is encountered when the Unit Test explorer command is clicked on against:
    • SQL Server Analysis Services instance
    • SQL Server Integration Services instance
    • SQL Server Reporting Services instance

Release:

2016.07.0108

Date:

December 13, 2017

Fixes:

  • "Microsoft SQL Server Management Studio 17 is not installed. Please install this version to integrate into" message is shown and the add-in installation doesn’t continue when SQL Server Management Studio 17.4 is installed

Release:

2016.06.0106

Date:

August 16, 2017

Enhancements:

  • Support for SQL Server 2017 RC2

Fixes:

  • "Not found" error is encountered on start-up when the add-in is integrated into SQL Server Management Studio 17
  • "Object reference not set to an instance of an object" error is encountered on start-up when the add-in is integrated into SQL Server Management Studio 2016

Release:

2016.05.0104

Date:

May 25, 2017

Enhancements:

  • SQL Server Management Studio 17 integration
  • Support for SQL Server 2017 CTP 2

Release:

2016.04.0096

Date:

February 27, 2017

Fixes:

  • The add-in doesn’t integrate into SQL Server Management Studio 16.5.3 when it is the only ApexSQL add-in installed
  • The “UTESession.xml file that stores session's info doesn't exist in the options directory; Tests execution failed” error is encountered when the CLI is used without previously using the GUI

Release:

2016.03.0093

Date:

December 15, 2016

Enhancements

  • Export test execution results to a SQL script
  • Export test execution results to a SQL database table
  • Customizable success thresholds

Fixes:

  • "SSMS is restarting" error is encountered when SQL Server Management Studio is started
  • SQL Server Management Studio stopped working when use the word “test” in the unit test name
  • SQL Server Management Studio freezes when renaming the test class
  • CLI does not start the operation when the “rc” switch is included along with other switches
  • “Object reference not set to an instance of an object” error is encountered when installing tSQLt for a database
  • Incorrect message about the .NET version that should be installed
  • The list of tests is collapsed/refreshed when the “Cancel” button is clicked in the “Rename class” dialog
  • The same shortcut can be used for all actions in the “Options” window
  • tSQLt framework is installed even when the “No” button is clicked in the “Install tSQLt” dialog
  • The "Create" button is clickable while the Demo kit is being created in the “Demo kit” dialog
  • Details about the selected tSQLt version are highlighted by default
  • Informative message is missing when a SQL Server instance where unit tests are not detected
  • Test results section includes passed tests

Release:

2016.02.0078

Date:

October 31, 2016

Enhancements

  • GUI theme integration with SQL Server Management Studio
  • Multi-selection of unit tests in the "Unit test explorer" tab
  • Demo kit database with predefined unit tests
  • Export test execution results to XML
  • CLI switch to install tSQLt framework
  • CLI switch to install SQLCop tests

Fixes:

  • Missing keyboard shortcuts for refreshing and renaming tests
  • Missing information about number of tests per class, number of tests on a single database
  • The "test" prefix should not be visible in the list of tests, but only in the query window
  • SQL Server Management Studio goes out of focus when deleting a test from the "Unit Test explorer" tab
  • SQL Server Management Studio 2016 stopped working when the add-in installed and trial period is selected
  • "One or more errors occurred" message appears when reinstalling tSQLt
  • The add-in offers to uninstall tSQLt on a new database which has not tSQLt installed
  • "Unknown error" message appears when there is a quotation mark in the name of a test
  • The "Options" menu item is not working in SQL Server Management 2016 when trial period is over
  • The "Unit test explorer" button is not working in SQL Server Management Studio 2016 when the trial period expired
  • Missing warning message in case unit tests do not exist
  • Missing 1% of tests in status bar
  • Number of passed and failed tests is not updated in real time
  • The "SSMS is restarting" error is encountered when SQL Server Management Studio is started with the add-in installed
  • Inappropriate message when the selected SQL Server node in the "Unit Test explorer" tab does not contain any unit tests
  • "Unknown error" message appears when refreshing unit tests after renaming the test class
  • Database will not be automatically added to the "Unit Test explorer" tab, in case tSQLt framework is installed within the "Object Explorer" pane
  • The "Install SQLCop tests" option is disabled when SQLCop tests already exist
  • Database is removed from the Unit Test explorer tab, when clicking the "Cancel" button in the "Uninstall tSQLt" dialog
  • Excessive message when creating sample database, in case it is already created
  • The drop-down menu for databases in the "Unit Test explorer" tab becomes disabled after changing between databases and selecting the "Show all" at the end

Release:

2016.01.0043

Date:

August 10, 2016

Features:

  • Supports SQL Server 2005 and higher
  • Supports SQL Server Management Studio 2012 and higher
  • Create SQL unit tests directly in SQL Server Management Studio
  • Manage all SQL unit tests from within a single form
  • Multiple sources for installing tSQLt
  • Organize SQL unit tests in test classes
  • Run SQL unit tests with a single click
  • Run SQL unit tests under one class with a single click
  • Get messages about passed and failed SQL unit tests
  • Stop SQL unit test execution at any time
  • Automated SQL unit test execution through the CLI
  • Export SQL unit test results when using the CLI