SQL Assistant Preferences & DSN entries location

Tools
Enthusiast

SQL Assistant Preferences & DSN entries location

Hi All,

I am using SQL Assistant as my workbench for TERADATA.

Recently, my system crashed and i had to setup the SQL assistant again.

SQL history was available in a MS Access DB file and i was able to save a lot of time as i had backed it up earlier.

However, i had a tough time with the following :

1. I had about 10 DSN defined to connect to various servers.

    These are user defined DSN on windows 7.

    Can someone guide me regarding backing and restoring these entries ?? It can save a lot of manual effort.

2. Also, any clue about where SQL assistant stores the selected preferences ??

    There are multiple preferences and is convenient if those can also be restored with few clicks.

5 REPLIES
Enthusiast

Re: SQL Assistant Preferences & DSN entries location

The ODBC entries can be backed up and restored from the registry entries. 

The ODBC entries are present at the following location:

HKEY_CURRENT_USER\Software\ODBC for User DSNs

HKEY_LOCAL_MACHINE\Software\ODBC for System DSNs

and File DSNs are stored in directories. These directories are listed in 

KHKEY_LOCAL_MACHINE\Software\ODBC\ODBC.INI\ODBC File DSN

So you can go the these entries, right click and click export. All the DSN will be exported to a file. 

To restore simply go the File menu of Regedit and click import, choose the previously exported file and thats it. 

Khurram
Enthusiast

Re: SQL Assistant Preferences & DSN entries location

Thanks ...

This will certainly be helpful.

Looking forward for help regarding the Preferences....

Enthusiast

Re: SQL Assistant Preferences & DSN entries location

About the second part of your question:



SQL-Assistant stores the customized information in XML files at the following path:

"C:\Users\<username>\AppData\Roaming\Teradata\SQL Assistant" on Win-7

OR "\Documents and Settings\<username>\Application Data\Teradata\SQL Assistant" otherwise



The files are as follows:

DataSources.config -> contains all the odbc sources defined through SQL-Assitant define data sources option in Tools menu.

DBTree.config -> Contains all the customizations for the databases added to the DBTree.

Toolbars.config -> Contains all the customization made to Toolbars

UserOptions.config -> Contains all the customizations to useroptions.

Hope now you will be able to backup and resotre your whole SQL-Assistant customizations.

 

Cheers!

Khurram
Enthusiast

Re: SQL Assistant Preferences & DSN entries location

Thanks a lot.

Completely answers my query.

Enthusiast

Re: SQL Assistant Preferences & DSN entries location

Posted about my learning and experience on backup/restore SQL assistant on the following linke:

http://allzhere.in/2013/10/06/teradata-sql-assistant-backuprestore-guide/

I hope it helps.