Settings Tab |
Reports Directory
(for CDT) |
If you are running CDT, specify the absolute path where you
want reports to be generated. |
Reports Directory (for CDV Tool) |
If you are running CDV Tool, specify the absolute path where
you want to export the comparison results report. |
Custom
Deployment Class |
Specify the name of the class that should be invoked for deploying
custom tables not handled by CDT. |
Max Changes to Display |
Specify the maximum number of differences to be displayed.
The default display number is 100. |
Audit Version Deployment |
Validate Old Values |
If you select this check box, the system detects conflict based
on the expected old value of an attribute of a record of the obtained
changes from the source database against the current value of the
corresponding record in the target database. |
Validate Lockid |
If you select this check box, the system detects conflict based
on the expected Lockid of a record of the obtained changes from the
source database against the current Lockid of the corresponding record
in the target database. |
Validate Record Exists Before Delete |
If you select this check box, the system validates the record
exists in the target database before it attempts to delete it. If
the record is not there, the operation will be marked as a conflict. |
Transformations
Tab |
Table Element |
Tables that can be added or deleted. |
Table Name Attribute |
Specify the name of the table on which you want to carry out
the transformation. The syntax and case must match the name of the
table used in the Sterling Selling and
Fulfillment Foundation ERDs.
Custom tables cannot be transformed. Choose the Details icon
to specify a value. |
Column Element |
Columns that can be added or deleted. |
Column Name Attribute |
Specify the name of the column containing the data to be transformed.
The syntax and case must match the name of the column used in the Sterling Selling and
Fulfillment Foundation ERDs.
Extended columns can be transformed. Choose the Details icon to specify
a value. |
Transform Element |
Define the transformation for this column. For each column,
you can define one or more transformations. These transformations
are applied to data in this column in sequential order. You can specify
multiple transformations for each column, using the delete action
to remove the parent element. |
Match Attribute |
Specify the pattern to search for in the source data. All matching
occurrences of this pattern are replaced with the value specified
in the Replace attribute. Choose the Details icon to specify a value. |
Replace Attribute |
Specify the value to replace the pattern with. Choose the Details
icon to specify a value. |
XPath Attribute |
Conditional. If the column to be transformed contains non-XML
data, you do not need to specify this XPath attribute. However, some
configuration information in Sterling Selling and
Fulfillment Foundation is
stored as XML in the database. If the column to
be transformed contains XML data, use this attribute to specify the
location of the exact attribute to be transformed.
Use
the syntax: xml:/Configuration/Connection/Host/@IPAddress.
Choose the Details icon to specify a value.
|
Append-Only
Tables Tab |
Append-only Tables |
Specify configuration table, if any, in which some rows
maintain data that is external to Sterling Selling and
Fulfillment Foundation.
This prevents the data from being deleted during deployment. Specify
that table and all of its dependent tables. Note: Rows that are maintained externally should never be present
in your source database, since this can lead to unpredictable results.
|
Ignore
Tables Tab |
Ignore Tables |
Specify any external configuration tables that you do not want
the tool to deploy from the source to the target. Ignoring a table
automatically ignores all dependent tables as well. |