Tools menu allows you to setup different options of the Aginity Workbench for Netezza application.



Here is the list of all the functions you can access via Tools menu.

   1.  Sql Dump Runner -  allows you to run each query in a debug mode.

   2.  Reverse Engineer Database - this command is similar to the Script Database command except that you must provide the connection information that database you want to reverse engineer.

   3.  Compare Schemas - select any two databases and click Compare to get started. After the comparison has completed running you will see the structure of the two databases. The objects highlighted in red are missing or different from the other schema. Clicking the 'Alter Script' button for the respective window creates a SQL scripts file which will reconcile any differences with the other database.

   4.  Analyze Database Schema - performs various data checks including: uniqueness of data, referential integrity and bad table distribution.

   5.  Analyze Database Data - performs analysis of the data table content in order to suggest improvements to the: nullability of fields that allow nulls, minimizing the row size by using minimum precision for columns and minimizing the size character columns.

   6.  Migrate DDL - allows to migrate databases from Oracle, MySql or Microsoft SQL server to Netezza.

   7.  Groom Database -  choose this option if you want to irrevocably delete records from the database.

   8.  SSH Terminal - opens a new window to connect to SSH terminal.

   9.  Options - allows you to completely customize the Aginity Workbench for EMC Greenplum.



Here is brief description of the options menu sections.

• General - set the default query time,  adjust the number of files shown in Most Recently Used file menus and enable or disable Connection pooling here.
• Fonts and Colors - here you can customize how your queries and syntax highlighting look.
• Shell Integrations - allows you to select what files to associate with the Workbench.
• Security - provides options to deal with cached SSH credentials.
• Query Analyzer Defaults - From this menu, you can adjust object browser settings, the number of results returned from a query, and enable syntax highlighting. You can also change the format of the date fields that are returned in the results window.
• Code auto-complete - provides access for different auto-complete code options.
• Code snippets - allows you to edit and create your own code snippets.
• Result set options/output options - allows you to edit the output format of the data in the result set window.
• Excel/CSV export - from this menu, you can adjust the default settings for importing and exporting data.
• Database highlighting - allows different background colors to be used for different connections.
• Stored Procedures - choose a method to create or replace a stored procedure.
• DB Script - you can customize which objects should be included in the script by default.
• Compare Schema - you can setup script action selection defaults here.
• UDX Designer - allows you to choose whether you want to save the UDX before compiling or not.

Go up  |  Go To WorkBench Help page