IDERA SQL Admin Toolset provides the following new features and fixed issues.
1.9.6 New features
SQL Discovery allows users to probe for SQL servers by port number
Users now can use port numbers to discover available SQL servers using the SQL Discovery tool. For more information about this tool, see SQL Discovery.
Login Copy allows users to copy and paste server name
Users now can simply copy and paste the source server name to the destination server name when using the Login Copy tool. For more information about this tool, see Login Copy.
1.9.6 Fixed Issues
| Issue Number | Description |
|---|---|
| SQLADMI-1784 | SQL Discovery. Allows users to discover SQL servers using port numbers. |
| SQLADMI-1791 | Corrects an issue preventing users from importing an updated server group |
| SQLADMI-1804 | Job Mover. Corrects an issue preventing the job package path from appearing in the destination tab. |
| SQLADMI-1813 | Quick Reindex. Corrects an issue causing a failure when attempting to rebuild columnstore indexes. |
| SQLADMI-1814 | Patch Analyzer. Corrects an issue causing errors when attempting to display Microsoft KB articles. |
| SQLADMI-1815 | Login Copy. Allows users to copy and paste source server name to destination server name. |
| SQLADMI-1816 | Multi Query. Corrects an issue causing an error when attempting to run Brent Ozar's Install-Core-Blitz-No-Query-Store.sql script. |
1.9.5 New features
Quick Reindex allows designation of SORT_IN_TEMPDB
Users now can designate the SORT_IN_TEMPDB option when using the Quick Reindex tool. For more information about this tool, see Quick Reindex.
Space Analyzer allows users to disable WMI credential requirement
Space Analyzer users now can check or clear the Use WMI Credentials checkbox to toggle whether to require WMI credentials when running an analysis. For more information about this tool, see Space Analyzer.
1.9.5 Fixed Issues
| Issue Number | Description |
|---|---|
| SQLADMI-1803 | User Clone. Corrects an issue causing some users to receive the error message, "No user information found" when attempting to use the tool. |
| SQLADMI-1801 | Index Analyzer & Quick Reindex. Corrected an issue preventing spatial indexes from appearing. |
| SQLADMI-1799 | Backup Status. Corrected an issue preventing the backup file size from updating upon a second backup. |
| SQLADMI-1791 | Corrected an issue preventing server groups from import if the servers are grouped under Microsoft SQL Servers in SSMS. |
| SQLADMI-1776 | Backup Status. Corrected an issue causing tempdb to not appear in the Backup Status report after clearing the Skip System Database option. |
| SQLADMI-1738 | Patch Analyzer. Corrected an issue causing SQL Server 2012 updates to appear as new updates. |
1.9.4 New features
Supports SQL Server 2019
The tools available in the IDERA SQL Admin Toolset now support SQL Server 2019. For more information about minimum requirements for IDERA SQL Admin Toolset, see Product requirements.
Supports Microsoft Windows Server 2019
IDERA SQL Admin Toolset now supports Microsoft Windows Server 2019. For more information about minimum requirements for IDERA SQL Admin Toolset, see Product requirements.
Backup Status Recovery Mode
The Backup Status tool now includes a column that displays the recovery mode type for each displayed database. The Recovery Mode column displays Simple or Full. For more information about Backup Status, see Backup Status.
Database Mover Windows Cluster
The Database Mover tool now supports the destination SQL Server instance on a Microsoft Windows cluster with cluster-shared volumes (CSV). The drive must be a member of the cluster group in order to have the files attached to the database and the user performing the move must have all permissions to perform database operations. For more information about Database Mover, see Database Mover.
User Clone supports multiple users
The User Clone tool now supports cloning of multiple users. For more information, see User Clone.
1.9.4 Fixed issues
| Issue Number | Description |
|---|---|
| SQLADMI-1783 | Test Cloud support for current Azure and AWS EC2 |
| SQLADMI-1781 | Adds support for the Windows Server 2019 platform. |
| SQLADMI-1780 | Adds support for the SQL Server 2019 platform. |
| SQLADMI-1777, SQLADMI-1778 | Quick Reindex and Index Analyzer. Corrects an issue causing an exception when the user clicks Browse in the database list. |
| SQLADMI-1776 | Corrects an issue preventing tempdb from displaying in the backup status. |
| SQLADMI-1775 | Patch Analyzer. Corrects an issue that caused some users to see an error message after clicking Check for New List. |
| SQLADMI-1772 | Updated the copyright info in the tools and Launchpad. |
| SQLADMI-1770 | Database Mover. Now supports a clustered shared volume disk. |
| SQLADMI-1768 | Installer no longer fails as a result of requiring .NET 2.0 or higher message. |
| SQLADMI-1761 | Login Copy. Now includes permissions when copying server login detail. |
| SQLADMI-1759 | Separates installer into Trial and Production versions. |
| SQLADMI-1757 | Database Mover. Corrects an issue preventing some properties from being copied or moved to target. |
| SQLADMI-1755 | ATS Tools now are organized into the Tools folder on Microsoft Windows 10. |
| SQLADMI-1748 | Job Mover. Corrects an issue that prevented copying of job step properties to the destination. |
| SQLADMI-1741 | Backup Status. Now presents the Recovery Mode for Backup Status. |
| SQLADMI-1582 | Launchpad. Corrects an issue causing the following error message: Launchpad error: The source was not found. Inaccessible logs: security. |
| SQLADMI-45 | User Clone. Now allows scripting of multiple users. |
1.9.3 New features
There are no new features in this release.
1.9.3 Fixed issues
| Issue Number | Description |
|---|---|
| SQLADMI-1764 | Corrects an issue with Backup status for SQL Server 2012 and older. |
| SQLADMI-1762 | Users with a large number of instances no longer experience a delay in results running Patch Analyzer in serial rather than parallel. |
1.9.2 New features
General
Supports SQL Server 2017
The tools available in the IDERA SQL Admin Toolset now support SQL Server 2017. For more information about minimum requirements for IDERA SQL Admin Toolset, see Product requirements.
New licensing
This product requires Microsoft Visual C++ 2015 Update 3 Redistributable. If the installer does not detect the correct redistributable in your environment, it will attempt to install or update to the correct version.
Please refer to the following Microsoft Support document for information about VC++ 2015 redistributable prerequisites: https://support.microsoft.com/en-us/help/3118401/update-for-universal-c-runtime-in-windows.
Diagnostic Tools
Backup Status tool now provides timestamps for backups on Availability Group nodes
The Backup Status tool now provides timestamps for Copy-Only backups performed on Availability Group nodes. For more information about this tool, see Backup Status.
Administration Tools
Database Mover now allows moves from higher to lower versions and editions
The Database Mover tool allows all moves including moves from higher versions to lower versions and higher editions to lower editions. Note that some features available in the higher versions/editions may not be available in the lower versions/editions. Users receive a warning message before moving from the higher to lower version/edition, and must confirm the move. For more information about this tool, see Database Mover.
Improves Multi-Query navigation
The Multi-Query tool now includes a vertical scroll bar to quickly search through results.
Allows database searches in Multi-Query tool
Users now can search targeted databases in the Multi-Query tool using a wildcard search. The Add Query Target dialog includes fields that allow a user to enter a search term or expression to filter for a list of matching databases. For more information about this feature, see Multi Query.
Includes new configuration options in Job Editor
The Job Editor tool now allows users to set the time since last run alert. Users can set the days, hours, or minutes in the Jobs not run in the last field. For more information about this feature, see Job Editor.
Enable or disable copied jobs when using Job Mover
While using Job Mover, the user can select whether the jobs on the destination server are enabled or disabled. For more information about this feature, see Job Mover.
Job Mover updates job steps to point to the new server for SSIS packages
The Job Mover tool now updates the job steps for SSIS packages to point to the new server rather than the old server. For more information about this tool, see Job Mover.
Partition Generator now supports datetime2 datatype
The Partition Generator tool now supports the datetime2 data type. For more information about this tool, see Partition Generator.
1.9.2 Fixed issues
| Issue Number | Description |
|---|---|
| SQLADMI-1728 | Partition Generator evaluates partitions on all editions of SQL Server 2016 SP1 and above. SQL Server 2016 RTM is not supported because partition evaluation is not allowed on that version. |
| SQLADMI-1721 | Backup Status report now properly sorts by Date DB Created column when Only include full database backups option is selected. |
| SQLADMI-1712 | Includes more descriptive information in the Level column of the Patch Analyzer. |
| SQLADMI-1708 | SQL Search now properly displays the last line of search results. |
| SQLADMI-1707 | Quick Reindex tool no longer reloads all indexes when performing a rebuild or reorg defrag on one or more indexes. |
| SQLADMI-1705 | SQL Index Analyzer now displays the list of columns in the correct order. |
| SQLADMI-1692 | Updated the banner image in the printed reports. |
| SQLADMI-1691 | Removed the WebHelp folder as it is no longer in use. |
| SQLADMI-1608 | Reserved1 no longer displays as a FILESTREAM database File Type in the Space Analyzer. |
| SQLADMI-407 | The User Clone tool now properly prevents access to the source users list when connection credentials are changed. |
| SQLADMI-399 | The Index Analyzer tool now properly supports long server names. |
| SQLADMI-376 | Space Analyzer now displays Auto Growth and Maximum Potential Size units in correct measurements. |
| SQLADMI-1 | Removed the 65535 character limit in Multi Query. |
1.9.1 New features
There are no new features in this release. Please see the Fixed Issues section for information about what is included in IDERA SQL Admin Toolset 1.9.1.
1.9.1 Fixed issues
Resolved license failure issue
IDERA SQL Admin Toolset resolves an issue occurring with some licenses that prevented users from registering a license key on certain Windows operating systems. This issue mainly affected Windows 10 and Windows 8/Windows SQL Server 2012 users, however was also seen on other versions.
1.9 New features
Improved IDERA SQL Admin Toolset user interface
IDERA SQL Admin Toolset features a new look and feel. These changes include new colors to reflect updated IDERA branding, installer changes for fast installation, and navigation menu updates for a more user-friendly experience.
Supports SQL Server 2016
The tools available in the IDERA SQL Admin Toolset now support SQL Server 2016. For more information about minimum requirements for IDERA SQL Admin Toolset, see Product requirements.
New options for the Backup Status tool
The Backup Status tool now allows you to skip offline databases in your backups by checking the Exclude Offline Databases checkbox. For more information about this tool, see Backup Status.
1.9 Fixed issues
General
| Issue Number | Description |
|---|---|
| SQLADMI-1589 | Removed SQL Server 7 from all selection lists within IDERA SQL Admin Toolset as it is not a supported version. |
| SQLADMI-1588 | Fixes an issue preventing users from activating a license on a VM with multiple NICs and constantly changing machines codes. |
| SQLADMI-1587 | Fixes an issue preventing new installations of IDERA SQL Admin Toolset from importing registered SQL Server instances on SQL Server 2014. |
| SQLADMI-1582 | Fixes an issue with IDERA SQL Admin Toolset 1.8.2 causing some users to receive a Launchpad error when attempting to open the product. |
Diagnostics tools
| Issue Number | Description |
|---|---|
| SQLADMI-1594 | CONNECTION CHECK: Fixes an issue causing the Test Network connections check of the Connection Check tool to look for only the default SQL Server instance name even when the actual instance name is provided in the SQL Server field. |
Administration tools
| Issue Number | Description |
|---|---|
| SQLADMI-1603 | DATABASE MOVER: Database Mover now includes a version compatibility check before starting to move data. |
| SQLADMI-1602 | USER CLONE: Fixes an issue causing User Clone to display the message, "You cannot keep the original password when downgrading from SQL 2014, do you want to proceed with a blank password," message even when both instances are SQL Server 2014. |
| SQLADMI-12 | JOB EDITOR: Job Editor now saves column setting changes to the Last Outcome column, such as column location and width. |
| SQLADMI-350 | DATABASE CONFIGURATION: Fixes an issue preventing the database option READ_COMMITTED_SNAPSHOT from being displayed in the Comparison Report available in the Database Configuration tool. |
Analytics tools
| Issue Number | Description |
|---|---|
| SQLADMI-370 | INVENTORY REPORTER: Fixes an issue causing Inventory Reporter to display error messages regarding data being in the incorrect format. |
| SQLADMI-1605 | PATCH ANALYZER: Fixes an issue causing Patch Analyzer to display SQL Server 2014 CTP1 build 11.09120 in the SQL Server 2012 section. |
| SQLADMI-1585 | PATCH ANALYZER: Fixes an issue causing the Patch Analyzer build list to display UNKNOWN for SQL Server 2014 and SQL Server 2016. |
| SQLADMI-1580 | PATCH ANALYZER: Fixes an issue causing Patch Analyzer to display incorrect details for SQL Server 12.0.2560. |
| SQLADMI-1600 | SERVER STATISTICS: Fixes an issue causing Server Statistics to not display data files for SQL Server 2012 and SQL Server 2014 instances. |