• Scroll to top of this topic Scroll to Top of Page

  • Print the current topic Print Topic

  • No expanding elements on this page Show/Hide Expanders

Console Scenario Elements

To execute the console scenario, you have to create the .xml file. You can find the schema of this .xml file here.

The root element for the Database Compare Suite console scenario is DatabaseCompareSuiteScenario. This element is mandatory, and every console scenario should start with it.

To specify the version index of current console scenario, you can use the version attribute. It is optional, and the default value for this attribute is 1.0.

The console scenario .xml file can include the following elements.

Element Type Comment
Connection Required Specifies the connection to databases (connection parameters for source and target database can be specified in different connection elements).
Operation Required Specifies the operations, executed in the console scenario. Unbounded element. The scenario without any operation is empty and doesn’t make sense. It can be mixed with the ExecuteSQL element.
Preferences Optional Specifies preferences for all operations in the scenario and cannot be combined with the “OpenProject” element.
Matching Preferences Optional Specifies matching preferences for all operations in the scenario and cannot be combined with “OpenProject” element.
Type Mapping Optional Specifies types mapping for all operations in the scenario and cannot be combined with “OpenProject” element.
ExecuteSQL Optional Unbounded element. Specifies the SQL code to execute and can be mixed with the operation element. The value of this element is actually an SQL script.
OpenProject Optional Specifies existing project to open for the scenario and cannot be combined with “Preferences”, “MatchingPreferences”, “TypeMapping” elements.
It has only one value which is the path to the saved Database Compare Suite project file.

You can find the scenario samples on this page