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.
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:
(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:
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.
Getting the following error...
Microsoft Visual Studio
The 'Teradata.Client.VS.Query.TdQueryEditorPackage, Teradata.Client.Query, Version=22.214.171.124, 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:
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.
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.
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)