The Windows console displays WorkBench startup information. Do not close the console while the WorkBench is running. Closing the console closes the tool, and your work is lost.
To start the Configuration Data Versioning Tool:
When you are finished, close the dialog box. The values you specified are saved automatically and persist from one session to the next.
If you change the name of either source or target database, the transformation settings are lost. To get back your old transformation settings, revert to the old source and target database name.
In the Source database and Target database windows, specify the applicable values as described in Table 1.
Field | Detail |
---|---|
Name | Specify a logical database identifier. For the source, specify the database you want to copy data from. For the target, specify the database to write the data to. |
className | Specify the class name of your database driver as follows:
|
jdbcURL | Specify the URL to connect to the database:
|
dbType | Specify the type of database you are running. Enter it in all
lower case, as shown:
|
folder | If using an XML datasource, specify the complete path of the folder location for the XML files. |
httpurl | Only applicable for the target database. Specify a URL for the application server whose data cache is to be refreshed after data is deployed into the target database. Use the syntax: http://<hostname/ip-address>:<port-number>/<Application>/interop/InteropHttpServlet, where <hostname/IP-address> is the server address where the application is running, <port-number> is the port on which the application is running, and <Application> is the name of the application; for example, smcfs. |
schema | Specify the schema owner as follows:
|
user | Specify the user name associated with the database. |
The system compares the two database versions. Once the comparison is complete, the system displays the Comparison Results screen. The results are grouped by table name onscreen.
Field | Detail |
---|---|
The first row displays the name of the entity which contains the conflict (for example, YFS_ORGANIZATION), type of the conflict (for example, Record has been modified), and user key (for example, DEFAULT). | |
Name | Displays the name of the attribute whose values caused the conflict. |
Expected Old Value | Displays the old value that is expected in the target database. |
Actual Old Value | Displays the old value that actually exists in the target database. |
New Value | Displays the new value that is obtained due to the change in the source database. |
Previous | Click this button to view the previous record. |
Next | Click this button to view the next record. |
Close | Click this button to close the Conflict Details window. |
Changed | Displays the name of the changed attribute along with it's old value and new value. |
Unchanged | Displays the name of the unchanged attribute along with its existing value. |
There are three types of changes that can be displayed:
You can scroll through the records by using the Previous and Next buttons. When you are done reviewing the details for a record, click Close.