Teradata SQL Assistant is a tool shipped with Teradata utilities. It is a complete query management tool where you can prepare a query, execute it and view results. SQL history, result set sorting and data import/export are some other useful features offered by the software. Besides, there are many customization options available which include the output format, export directory, DSN setup, etc. There is no doubt that all these features make development faster and convenient.
However, there is always a possibility of a system crash or OS re-installation that wipes all the customization setup for user account. These user preferences or customization options could include:
- DSN setup for connections.
- SQL History.
- User Preferences.
In this post, I will be covering details regarding backup and restore of the above mentioned options.
Note: These details are related to Windows OS.
- DSN: The DSN created in Teradata SQL assistant are standard ODBC user DSN mapped in windows. Hence, the DSN are created under the following registry. User DSN : HKEY_CURRENT_USER\Software\ODBC
System DSN : HKEY_LOCAL_MACHINE\Software\ODBC
File DSN : HKEY_LOCAL_MACHINE\Software\ODBC\ODBC.INI\ODBC
There is an option to import/export the DSN entry from the Windows registry. Another file to look for is “DataSources”. The path is mentioned in pointers below. It contains the names of data sources setup in SQL Assistant.
- SQL History: Entire query history maintained in the tool. Loosing this is a sin. At the background, SQL Assistant stores the history in MS Access DB file named “SQLHistory”. The folder on Windows 7 is “C:\Users\<User_Name>\AppData\Roaming\Teradata\SQL Assistant”. Simply copy-paste the old file to restore your old SQL history.
- Preferences: The preferences include a variety of user options. Preferences files are also saved on the same path i.e. “C:\Users\<User_Name>\AppData\Roaming\Teradata\SQL Assistant”. The one file to look out is “UserOptions”. You will be amazed to see the level of information that this tool stores. Recent search texts, directory setting, window size, font, style; it’s all here. It is really critical to back up this file. To restore, simple paste the old file in the new installation directory.
The above details should suffice to get your SQL assistant to the same state as it was before the system re-image; provided you backed it up.