All Forums Tools
taruntrehan 43 posts Joined 10/12
16 Sep 2013
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.

Regards, Tarun Trehan http://allzhere.in
M.Saeed Khurram 544 posts Joined 09/12
16 Sep 2013

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

taruntrehan 43 posts Joined 10/12
16 Sep 2013

Thanks ...
This will certainly be helpful.
Looking forward for help regarding the Preferences....

Regards,
Tarun Trehan
http://allzhere.in

M.Saeed Khurram 544 posts Joined 09/12
16 Sep 2013

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

taruntrehan 43 posts Joined 10/12
16 Sep 2013

Thanks a lot.
Completely answers my query.

Regards,
Tarun Trehan
http://allzhere.in

taruntrehan 43 posts Joined 10/12
06 Oct 2013

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.

Regards,
Tarun Trehan
http://allzhere.in

You must sign in to leave a comment.