Page History
When SQL Query Tuner DB Optimizer is started, it prompts you to discover data source catalogs that have been created by any previously installed IDERA products (DBArtisan, Rapid SQL, SQL Query Tuneretc.), or other instances of SQL Query TunerDB Optimizer.
Additionally, the system scans your machine for the client software of all supported third-party DBMS platforms (TOAD, Eclipse Data Tools Platform, etc.). These data sources are automatically added to the data source catalog.
...
- Choose the type of data sources you want to scan for and click Next. The wizard automatically returns all data sources it finds on your machine based on the criteria you specified.
Choose the data sources you want to add to the SQL Query Tuner DB Optimizer environment and click Finish.
Data Source Explorer automatically populates with the new data source selections.Info To add data sources manually, right-click Managed Data Sources in the Data Source Explorer tree, select New > Data Source, and enter the connectivity parameters as prompted.
...
Once a data source has been registered, the connection parameters are stored locally. In some cases, a user ID and password are required to connect to a registered data source. SQL Query Tuner DB Optimizer can encrypt and save user IDs and passwords to connect automatically.
| Info |
|---|
In some cases, older versions of SQL Query Tuner DB Optimizer and DB Artisan/Rapid SQL are not compatible with this version of SQL Query TunerDB Optimizer, and the methods listed above will not import these older data source catalogs. If you are experiencing difficulties, you can import the old data sources via the Windows registry by selecting File > Import... > IDERA > Data Sources > Previously Registered IDERA Data Sources (Windows Registry). |
| Scroll pdf ignore |
|---|
Automate SQL tuning and profiling with DB Optimizer. Learn more > > |