Running SQL Compare

The following SQL Compare files are included when you install the HPE Service Manager Upgrade Utility:

• sqlupgrade.unl
• upgdbdct.dta

SQL Compare returns messages for dbdict mappings that contain new fields. You can update the dbdicts to contain the fields specified by the SQL Compare applications before you begin the applications upgrade.

To run the SQL Compare utility, follow these steps:

1. From the System Navigator, click System Administration > Ongoing Maintenance > Upgrade Utility > SQL Compare Utility.
2. Select Run SQL Compare Utility, and then click Next.

3. Type the full path to upgdbdct.dta including the final back slash (\) or forward slash (/), depending on your operating system. For example, if you copied the files to a temporary directory, the path might be:

   Windows: c:\temp\upgrade\

   Linux: /tmp/upgrade/

4. Click the Next button.

   SQL Compare returns the following message:

   Process Complete. Please check for any additional messages.

   The results of the SQL Compare process are stored in the sqlupgrade table. This table resets each time you run SQL Compare.

To view the SQL compare results of the table fields, follow these steps:

1. From the System Navigator, click System Administration > Ongoing Maintenance > Upgrade Utility > SQL Compare Utility.
2. Select View SQL Field Compare Results, and then click Next.
3. Click Search. The results are displayed in a record list.

Each table field difference found by the SQL Compare Utility appears as a separate record in the sqlupgradefield file. This record also lists the new fields that you must add to the database dictionary if you are updating your RDBMS mapped system manually.

The sqlupgradefield record provides the following information for each field you must add or modify if you are updating your RDBMS mapped system manually.

List of sqlupgradefield fields

Field	Description
File Name	The exact file name which delegates the database dictionary.
Field Name	The exact field name to add or modify to the associated database dictionary.
Field Structure	The field structure in the database dictionary.
Field Type	The field type in the database dictionary.
Field Level	The field level in the database dictionary.
Result Type	The actions happened or will happen to this field.
Field Alias Of	If this is an alias field, it contains the name of the primary field that it is an alias of. Otherwise, this field is blank.
Field SQL Table Alias	The SQL table alias of this field in the database dictionary.
Field SQL Name	The SQL name of this field in the database dictionary.
Field SQL Type	The SQL type of this field in the database dictionary.
Field SQL RC	The encoding format of this field in the database dictionary.
Exceptions	The exceptions that occurs when adding or modifying this field.

To view the SQL Compare results of the table unique keys, follow these steps:

1. From the System Navigator, click System Administration > Ongoing Maintenance > Upgrade Utility > SQL Compare Utility.
2. Select View SQL Unique Key Compare Results, and then click Next.
3. Click Search. The results are displayed in a record list.

Each table unique key difference found by the SQL Compare Utility appears as a separate record in the sqlupgradekey file. This record also lists the new unique keys that you must add to the database dictionary, if you want to check the possible duplicated record manually.

The sqlupgradekey record provides the following information for each field you must add or modify, if you want to check the possible duplicated record manually.

List of sqlupgradekey fields

Field	Description
File Name	The exact file name which delegates the database dictionary.
Result Type	The actions happened or will happen to this field.
Key Type	The unique key types include primary, unique, and noduplicated.
Key Field	Concatenates all the key fields with the | character.
Exceptions	The exceptions that occurs when adding or modifying this unique key.