Complete Migration Scenario - ODBC Driver for Teradata

ODBC Driver for Teradata User Guide

Product
ODBC Driver for Teradata
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2526
lifecycle
previous
Product Category
Teradata Tools and Utilities

For an ODBC user to completely migrate over to the new directory tree structure, the convert_ini script will be needed to convert their existing odbc.ini files over to the new ODBC install directory. The convert_ini script will replace the InstallDir, TraceDll, and Driver attribute values with the appropriate directory paths relevant to the ini file's attributes.

It is highly recommended that the -v option is omitted so that the common install directory which is release independent is used for the 32-bit and 64-bit ODBC Drivers. This script can also be used to migrate the odbc.ini back to the ODBC Legacy directory structure by selecting either the 3.6 or 12.0 version.

convert_ini
===========
Usage: convert_ini -i <user installdir> -b [32 64] -v [3.6 12.0 13.0]
Option Description:
-i <user installdir>
specify the user installdir [default: /opt ]
-b [ 32 64 ]
specify bitness of ODBC Driver
-v [ 3.6 12.0 13.0 ] specify TTU version [default: ODBC_32 or ODBC_64 ]
-f [ i.e. /home/odbc.ini, /opt/teradata/client/14.00/ODBC_64/odbc.ini, ... ] specify ini file
-p use UNIX pipe to process ini file list
-d generate comparison records

Example Convert Legacy odbc.ini File to Common 32-bit Install Directory

 $ convert_ini -f odbc_pre14.0_32_drivers_drivers.ini -b 32 -i /vob/tdodbc_nt/src/odbcadmin/work -d
 
 
 ==================================
 PROCESSING.... [odbc_pre14.0_32_drivers_drivers.ini]
 ==================================
 
 INI FILE MIGRATION COMPLETED on odbc_pre14.0_32_drivers_drivers.ini file
 =======================================================================
 = ini file: odbc_pre14.0_32_drivers_drivers.ini
 = saved file: odbc_pre14.0_32_drivers_drivers.ini_082208_19:54:36.sav
 = lines changed: [ 4]
 =======================================================================
 
 2c2
 < InstallDir=/vob/tdodbc_nt/src/odbcadmin/work/teradata/client/ODBC_32
 ---
 > InstallDir=/usr/odbc
 4c4
 < TraceDll=/vob/tdodbc_nt/src/odbcadmin/work/teradata/client/ODBC_32/lib/odbctrac.so
 ---
 > TraceDll=/usr/odbc/lib/odbctrac.so
 13c13
 < Driver=/vob/tdodbc_nt/src/odbcadmin/work/teradata/client/ODBC_32/lib/tdata.so
 ---
 > Driver=/usr/odbc/drivers/tdata.so
 23c23
 < Driver=/vob/tdodbc_nt/src/odbcadmin/work/teradata/client/ODBC_32/lib/tdata.so
 ---
 > Driver=/usr/odbc/drivers/tdata.so
 
 =======================================================================