We are pleased to announce general availability of the Teradata Developer Tools for Visual Studio 15.01.
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.
If you are not familiar with this tool you may wish to read New Teradata Developer Tools for Visual Studio before continuing with this article.
This release of the Teradata Developer Tools for Visual Studio adds a Teradata Explorer window that allows you to explore the objects in your data source, and to perform various actions on them. It also includes an Edit Table function that allows you to directly modify the data in a table, and provides full integration with the Visual Studio Properties window.
The Teradata Explorer displays each Data Source that you connect to. You can expand a data source to display the Databases, and optionally the Users, within that data source.
You may then drill down to see the Tables, Views, Columns, Indexes, etc. within a database.
The information in this tree structure will be saved to a local file when the application closes, and re-loaded the next time you open the tool. This makes the information available even when you are not connected to the data source. It also reduces the impact on the data source itself.
Since this tree structure acts as a cache for the Intellisense functionality you do not need to be connected to the data source in order to get Intellisense help.
It does however mean that you must manually refresh the contents of the tree after structural changes are made on the data source. This is done using the Refresh context menu on any node that may have children.
The following actions may be performed using the Teradata Explorer:
These editor windows are created using the Edit Table context menu for any table in the Teradata Explorer.
These windows provide the following functionality:
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.