Page History

Upgrade Notes

• DB Optimizer should be installed in a different directory than previous versions of DB Optimizer. If DB Optimizer is installed in the same directory, the following error will result in at application start up: "Unable to read workbench state. Workbench UI layout will be reset.
• If a previous version is already installed on your machine, either change the default Workspace or delete all files from the Workspace directory. The Workspace directory location appears whenever you start Optimizer, and can be redefined from this dialog box. If the same Workspace is indicated for the new version as was indicated previously, the following error will result: "Cannot restore workbench layout".
• If DB Optimizer is already running, you can also modify the Workspace directory by choosing File > Switch Workspace > Other from the Main Menu.
• We strongly suggest selecting a new workspace when upgrading from a previous version of DB Optimizer.
• Saved profiling and tuning session files (.oar) created using previous versions of DB Optimizer are not compatible with current versions. You can however have more than one version of DB Optimizer installed on the same system. To read old .oar files, run the older version of DB Optimizer.

Known Issues

The SQL Server sqlvariant data type is not currently supported by the Microsoft JDBC driver. If a query is used to retrieve data from a table that contains a column of the sqlvariant data type, an exception will occur. There are two workarounds to fix this issue:

• Use CAST to type cast the sqlvariant columns to the data type you want.

Or

• Use the jTDS driver to connect.

Idera strives to ensure our products provide quality solutions for your SQL Server needs. The following known issues are described in this section. If you need further assistance with any issue, please contact Support (www.idera.com/support).

Installation and configuration issues

SQL Admin Toolset no longer supports Itanium

Idera has discontinued Itanium support in SQL Admin Toolset version 1.6 and later. However, versions 1.5 and earlier will continue to operate with Itanium and support for those versions is available through November 2012. For more information, see the product requirements.

Known issues in this version

There are no new known issues in this version.

Previous known issues

Linked Server Copy

Local computer accounts are not supported. If you create a linked server and map the security locally, the linked server is created, but you receive an error stating that it is not a valid login.

Need more help? Search the Idera Customer Support Portal

...

...

...