We are pleased to announce general availability of the Teradata Developer Tools for Visual Studio 15.10.
This product may be integrated with Visual Studio 2010, 2012 or 2013 and can be downloaded from the following locations:
Alternatively, you can use the Extensions and Updates item on the Tools menu in Visual Studio to download it directly from within Visual Studio.
This release of the Teradata Developer Tools for Visual Studio adds a range of small changes and improvements to the tool.
The Teradata Explorer now displays the Data Source Names defined within the tool rather than Server Names. If you have defined data source names that are not the same as the server that they connect to you should delete those Data Source nodes from the Teradata Explorer. These nodes will no longer be used and will simply add overhead.
A new Change Password command has been added to the context menu for Data Source nodes. This command will only be displayed when you are connected to the data source. Clicking this command will display a dialog that allows you to securely change your password on the Database server, and also any saved password within the configuration file.
The Teradata Explorer, and all dialogs, now use the Visual Studio Environment Font. In addition the Teradata Explorer now adopts the color and style of Server Explorer. This includes Font, Color scheme, Lines, Expansion icons, and full width node selection highlighting. The following images show the new vs. old appearance when using the dark theme:
Two new commands, Script and Script to File, have been added for use when editing table data. These commands will generate Insert statements for the table rows, and write the SQL to a new Teradata Query [Script], or to a file [Script to File]. If any rows are selected then only those rows will be scripted. Otherwise all rows in the display grid will be scripted.
The output will be of the form:
INSERT INTO HR.Phonelist (FirstName, LastName, HomeNum) VALUES ('David', 'Jones', 9045552700)
INSERT INTO HR.Phonelist (FirstName, LastName, HomeNum) VALUES ('John', 'Smith', 4075551234)
or if the option to enclose object names in quotes is set:
INSERT INTO "HR"."Phonelist" ("FirstName", "LastName", "HomeNum") VALUES('David', 'Jones', 9045552700)
INSERT INTO "HR"."Phonelist" ("FirstName", "LastName", "HomeNum") VALUES('John', 'Smith', 4075551234)
Keyboard macros may now be recorded and later replayed. After recording a macro you will be prompted to enter a meaningful name for this macro. When you wish to play a macro you may use the Play command to display a list of saved macros. Select the macro to play, and optionally set a count for how many times it should be played. If you wish to replay a macro that you have recently played use the Replay command.
Macros may be deleted by clicking the Play command and then clicking Delete after selecting the macro(s) to be deleted.
Note that if a macro uses F3 [Find Next] or Shift+F3 [Find Previous] you must issue the appropriate Find command prior to executing the macro. The target string is not saved as part of the macro - only the keys are saved.
A new Save My Password check box has been added to the Basic tab. This will cause us to save the Password or Authentication Parameter for this data source to the Data Source configuration file. These security fields will then be pre-loaded into their respective fields whenever the data source is selected. Saved passwords will also allow the Teradata Explorer to automatically connect without prompting for any input.
Note that all saved security information is fully encrypted.
A new Recovery option has been added to the Advanced tab. This allows you to select the session recovery option you wish to use for this Data source.
A new All Properties tab has been added. This tab displays a property grid that allows you to set any connection string property supported by the data provider. The only exceptions are New Password which will be ignored, and Connection String which will be displayed as a read only field at the bottom of the tab. This field will display the current connection string without the security fields.
The following new commands have been added in order to improve control of the Query / Result set windows:
Note that the old Explorer Font Size option has been removed since we now use the Environment Font.
If specified in the connection string, or through default settings on the Database Server, we will attempt to reconnect a broken session and continue processing the statement that was interrupted. If the reconnection takes too long you may cancel waiting by clicking the Abort button. Any reconnection, or aborted reconnect, that occurs will be logged to the Messages tab.
Changes have been made to improve performance for both large files and very long lines. Refer to the new Parser Limit option above for more details.
This tool will allow you to develop the SQL required for your applications without leaving the Visual Studio environment. However it should be noted that the tool is not a replacement for SQL Assistant or Teradata Studio. These other tools still have more functionality than the Teradata Developer Tools.