Teradata Developer Tools

Free

Compose SQL queries for the Teradata Database and execute those queries using the .NET Data Provider for Teradata

(3) Review
Visual Studio
2013, 2012, 2010
Download (1,982)
5/13/2014
15.0.0.0
View
E-mail Twitter del.icio.us Digg Facebook
Add to favorites
Description
Reviews (3)
Q and A (6)
Sign in to write a review
Sort by:

by Fyodor Dobrovidov | Wed 1:23 PM

It works, very useful tool

by mdknauss | May 23 2014

I haven't noticed any bugs in the functionality provided with this so far. I would like to have the ability to see what database I'm connected on on each tab. I'd also like to be able to format any sql snippets I copy and paste into the edit window. I really like the auto complete function and look forward to the next version of this extension.

by sundarvenkata1984 | September 19 2013

Works without any noticeable bugs which is great for the first release. I expect more features like the following in the subsequent releases:

1) Support for native VS keyboard shortcuts (toggle outlining expansions)
2) Ability to have output in a separate non-intrusive tab
3) Snippets for basic SQL fragments

Sign in to start a discussion


  • SQL File association
    2 Posts | Last post July 23, 2014
    • How do I make .sql files open as a Teradata Query window and not the SQL server project template?
    • The way VS works is that each editor extension registers a file type (or types) that it handles.
      Microsoft has already grabbed 'sql' so I had to register 'tdsql'.
      
      If you never use SQL Server and you want to use sql rather than tdsql you can play with the registry a bit.
      
      In the following key, change the string value 'tdsql' to 'sql, leaving everything else the same:
      HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\10.0_Config\Editors\{8bec50d7-7644-48da-9cff-49414b941d74}\Extensions
      (or you could just add an 'sql' string value that copies the 'tdsql' value)
      
      Either remove the following keys completely, or change the 'sql' string value in their Extensions key to 'mssql' or something similar:
      HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\10.0_Config\Editors\{C5B506FB-13BA-4381-3A48-41275C4CA2B5}
      HKEY_CURRENT_USER\Software\Microsoft\VisualStudio\10.0_Config\Editors\{C76E46D4-B7D7-42b8-9726-A98D8045B179}
      
      All the above keys are for Visual studio 2010.
      If you use VS2012 change '10.0_Config' to '11.0_Config', etc.
      
      NOTE - I have NOT tested this ... but I think it will work.
      
      
  • Error in VS 2010 Ult
    3 Posts | Last post May 01, 2014
    • Getting the following error...
      
      ---------------------------
      Microsoft Visual Studio
      ---------------------------
      The 'Teradata.Client.VS.Query.TdQueryEditorPackage, Teradata.Client.Query, Version=14.11.0.1, Culture=neutral, PublicKeyToken=76b417ee2e04956c' package did not load correctly.
      
      The problem may have been caused by a configuration change or by the installation of another extension. You can get more information by running the application together with the /log parameter on the command line, and then examining the file 'C:\Users\sbedwel\AppData\Roaming\Microsoft\VisualStudio\10.0\ActivityLog.xml'.
      
      
      In the log, it says "Could not load file or assembly 'ActiproSoftware.Shared.WinForms, Version=13.1.310.0, Culture=neutral, PublicKeyToken=c27e062d3c1a4763' or one of its dependencies. The system cannot find the file specified."
      
      Any ideas to get past this?
    • The vsix file (really just a zip file) should contain the following files:
        ActiproSoftware.Shared.WinForms.dll
        ActiproSoftware.SyntaxEditor.WinForms.dll
      It sounds like at least one of them was either corrupted or not extracted when VS installed the extension.
      
      Hopefully you can manually extract these files and place them into the directory where the extension is installed.
         \<your name>\AppData\Local\Microsoft\VisualStudio\nn.0\Extensions\???
      
      Alternatively you could try uninstalling the extension, then re-installing the vsix file. (assuming you have the file on your system)
      
      If you installed it directly though VS gallery and don't have the actual vsix file on your system you would have to uninstall and then reinstall from the gallery.
       
    • Thanks!  It was missing one of the dll's somehow.  Manually unzipping and copying over the files fixed it.
  • Featurere quest
    2 Posts | Last post February 06, 2014
    • I notice the handy possibility to collapse case statements, But could you make something like visual studio regions functionality. You can indicate a custom region and collapse that. 
    • In 15.0 you will be able to collapse entire statements - including the separate parts of a Union/Intersect - as well as the derived tables, case statements, Begin/end blocks, procedural blocks and multiline comments that you can currently collapse.
      
      The idea of user defined regions does not fit well with SQL since the parts that need to be collapsed often dont start/end at the beginning or end of a line. (and starting/ending regions in the middle of a line would be a parsing nighmare)
  • SSDT
    6 Posts | Last post December 19, 2013
    • Hello,
      
      Could you modify the extension to be compatable with SSDT (VS Studio 2010 Shell)
      
      Thanks.
    • I'll add 'IntegratedShell' as a supported platform in the next update.
      I think it should work in the Shell but I have not verified that.
    • One question though.
      Why would you want a Teradata specific extension to be available for SSDT - which is specifically for SQL Server?
    • Hi Mike
      
      I would need the same feature ... I'd need it because we for example have many SSAS cubes accessing Teradata via MOLAP and sometimes ROLAP using SSAS 2012 and VS SSDT 2012
      
      Thanks
    • Hi Mike :-)
      Teradata Developer Tools work with VS 2010/2012 Express?
      
      thx
      saviano
    • It supports only VS Professional and above.
  • VS2013
    3 Posts | Last post November 11, 2013
    • Any idea when VS2013 compatibility will be available?
    • We are planning to release version 14.11.0.1 at end Jan.
      That should support VS 2013. 
    • Thanks Mike!
  • Version 14
    2 Posts | Last post October 21, 2013
    • Teradata 14 version coming soon?
    • Teradata 14 (and in fact 14.10) are already available.