We are pleased to announce general availability of the Teradata Developer Tools for Visual Studio 15.11.
This product may be integrated with Visual Studio 2010, 2012, 2013 or 2015 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 the following articles first:
New Teradata Developer Tools for Visual Studio
Teradata Developer Tools for Visual Studio 15.01
Teradata Developer Tools for Visual Studio 15.10
The main feature of this release of the Teradata Developer Tools for Visual Studio is the addition of a New Table Designer.
A New Table designer is opened using the Add New Table command on the context menu of either a Database node or a Tables Collection node of the Teradata Explorer. This designer window contains 3 sections as shown below:
As with the Query/Result panes of the Query Editor you may switch the positions of the SQL Text and Designer areas, or Maximize either of these.
The Table, Columns, and Constraints can be further defined using the Properties window.
The following screen shot shows some of the properties of the Table itself:
When the designer is first displayed the Properties window will display the table properties and focus will be on the Table Name property.
To display the properties of a column click on the row in the Columns Grid that defines that column.
To display the properties of a constraint click on the node within the Constraint Tree that displays that constraint.
To re-display the properties of the table itself click on the column headers or white space area of the Columns Grid, or within the white space area of the Constraint Tree.
The available properties will vary depending on the Teradata Database release that you are connected to, and on the property values you have previously set. For example, if you set the Temporary property for the table then the Is Queue, Block Compression and Journaling properties will not be available.
Most constraints are added by selecting the Column rows that define the constraint and then using the context menus:
After completing your definition, you can create the table using the standard Execute command, or you can script it to a Teradata Query editor, or file, using one of the Script commands.
If the table is successfully created it will automatically be added to the Tables node of that database in the Teradata Explorer.
A new Add Database 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 enter the name of an existing database that you wish to add to the tree. This allows you to add a User while using the option to load only databases, or to add a newly created Database without refreshing the entire data source.
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/different functionality than the Teradata Developer Tools.
Can I integrate it with the free Visual Studio 2015 Community Edition https://www.visualstudio.com/products/visual-studi
Although this is not part of the main topic, may I ask if we allowed to install Visual Studio Express and/or Visual Studio Community Editions in our Teradata laptop?
I have not tested the tools with the community edition but I did allow it in the installation control file so you should at least be able to install it.
I think CE contains the full application, but without the compilers and extra tools, so I think it should work.
I don't know Teradata's policy on that but since it does not require purchase of a license I don't see why they would object.
I'm really excited to use these tools. I've downloaded them and installed them, but every time I try to launch the Teradata Explorer window after connecting, it crashes VS. Any ideas on what might be happening?
Here are my VS settings:
I have never used either of the 'shell' components - I only use the full product - so I may be wrong here.
My understanding is that the integrated shell runtime allows use of extensions in the 'isolated' shell. (The download site says that 'isolated' is required for use of the 'integrated' runtime)
The only version of the isolated shell I can find is 2010 (Version 10).
You say you are using version 12 (VS2013) of the integrated shell but no mention of the isolated shell so maybe I don't understand what is required. (and there doesn't seem to be a version 12 of isolated.)
I have only tested the extension with VS2010, VS2012, VS2013 and VS2015. (Professional and Enterprise versions)
However everything I have read says it will also work with the [free] VS2015 community edition.
Having said all that, your issue may be the version of .Net Data Provider for Teradata that you have installed. You say 22.214.171.124 but this product requires 15.11. (unless that was a typo in your comment)
The vsix package includes version 15.11 of the provider but if you installed version 14.11 with its VS Integration feature that might have caused things to get confused.