IDERA SQL Admin Toolset provides the following new features and fixed issues.
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. |