What's New in Rapid SQL 2016

From RapidSQL
Jump to: navigation, search

Go Up to Main Page

PostgreSQL Object Management

Object Wizards/Editors

A Wizard and an Editor for Types have been added for PostgreSQL: Types Wizard and Types Editor.

Missing Indexes

The Missing Indexes feature analyze the system looking for Missing Indexes which, once added, would improve the performance.

Rapid SQL proposes you some Indexes that can be created created after analyzing the system. You can create these Indexes by launching the Indexes Wizard (SQL Server) and directly double-clicking the selected Missing Index.

Description about how to use and access Missing Indexes is in Missing Indexes (SQL Server).

Note: Missing Indexes is only available for SQL Server.

ISQL Performance

SQL Editor includes new functionalities for SQL Server. In this new release, SQL editor provides information about the SQL statements while you are writing in the SQL Editor. This information is included in a new window as well as listed in the Error Pane. Information like Missing Indexes, Statistics, Overlapping Statistics and Recommendations are displayed in this new window. You can find more information in ISQL Performance

Performance window


ISQL Performance listed in Error Pane


Note: ISQL Performance only available for SQL Server.

Team Server 2016 Support

Integration of Team Server 2016 in Rapid SQL has been improved. The old TeamServer Navigator has been fully integrated into the Datasource Navigator as well as all the features only accessible from the TeamServer Navigator. For more information, see Using the Datasource Navigator and Basic Viewing Options in the Navigator. Notice that when logged in Team Server 2016, a node is added:

  • Saved Searches


Team Server 2016 as the Data Source Catalog

Rapid SQL 2016 adds the option of registering datasources from the Team Server 2016 Repository. To allow that, new options have been added to Quick Start Setup, and in Tools > Options > Datasources.

In Quick Start Setup, the import of datasources using Team Server 2016 as a catalog has been added.


In Tools > Options > Datasources the possibility of selecting Team Server 2016 as the source of the catalog has also been added. For more information, see Working with Team Server 2016 as Datasource Catalog.