1. Before using the utility, the user needs to create the view S_EIM_MAP_V in the database. The database platform independent script for creating the view is create_EIM_MAP_V.sql and can be found in <dbsrvr>\common directory.
2. The executable utleimdiff.exe is in <tools>\bin directory. Switches for the program are as follows:
/U User Name | Siebel user name |
/P Password | Siebel Password |
/C Connect String | ODBC connect string |
/D Table Owner | Database Table Owner |
/N New Siebel Repository Name (Required)
This is the name of the new repository.
/O Old Siebel Repository Name (Required)
This is the name of the old repository.
(enclose repository names in quotation marks, .i.e. /N "New Repository" /O "Old Repository")
/I Input Filename
This file contains the list of EIM tables that will be compared. The default input file of "eim_tbl_lst.inp" is shipped in the same directory. User can edit this file.
/M Report Filename (Required)
This is the output report. The default name is "eim_diff.txt"
/L Log Filename (Default: eim_diff.log)
3. The output file contains three parts:
Part 1: Interface Table Difference
Part 2: Interface Table Mapping Difference
Part 3: Interface Column Mapping Difference
Part 1 compares all interface tables in the two repositories, whereas Part 2 and 3 compare the interface tables listed in the input file. The program may run for several minutes, depending on the number of tables to be compared.
The output file is self-explanatory. The first column of each part is the repository name. If there is an entry in one repository but not the other, then that means it exists in one repository but not the other. If there is the same entry in both repositories, then that means it has been modified. In Part 3, "UK" means "User Key sequence", and "Req'd" specifies whether the column in the base table is required or not.