Most of the control files used by SQL Assistant are the same, or very similar to, those used by the Teradata Developer Tools. These files can therefore be copied from a newer version of the tools product as follows.
- Go to the Visual Studio Marketplace at http://marketplace.visualstudio.com.
- Search for Teradata, then select Teradata Developer Tools – English version.
- Download the package. It is a single .zip file with the vsix extension.
- Unzip the Teradata.Client.Query.vsix file to a temporary location.
-
Copy the teradata*.mbr files to c:\users\<username>\AppData\Roaming\Teradata\SQL Assistant.
These files will replace existing files of the same name.
- Copy the explain.lng and format.lng files to <SQL Assistant install directory>\Data.
-
Use a Diff product, such as WinMerge, to merge the changes from the teradata.lng file to the existing SQL Assistant file in <SQL Assistant install directory>\Data.
- The files have different names on line 2 so do not merge that difference.
- The Visual Studio Tool file has a SemicolonTrigger entry that is not required by SQL Assistant.
- The SQL Assistant file has multiple references to the following additional token types:
- Commands
- NamedParam
The references to these token types should not be removed.
Otherwise, merge all the remaining differences.
The teradata.syn file is not used by the Teradata Developer Tools. You will need to manually edit that file to see any new syntax examples in the Favorites window.