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.
|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