ApexSQL Unit Test release notes

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

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

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

Fixes:

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

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

Enhancements:

• New error handling and send logs functionality
• Improved application installer with a dark theme
• SQL Server Management Studio 18 integration support
• SQL Server 2019 CTP 2.0 support

Fixes:

• Creation of the sample database and Demo kit never ends

Enhancements:

• New application icon
• 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

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

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

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

Enhancements:

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

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

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

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

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