Merging models can be invoked through the command line.

mergeModels
-repo <repo name>
-c <category>
-pm <primary model>
-pv <primary version>
-sm <secondary model>
-sv <secondary version>
-o <path to operations file>

Example

jre\bin\java -Xmx512m -XX:MaxMetaScpaceSize=512m -splash: -jar WhereScape-3D-HEAD-bundle.jar mergeModels -repo "Local repository" -c "Load and Staging" -pm "Tutorial" -pv "Master" -sm "Tutorial" -sv "1.0" -o "C:\temp\Operations.xml"

Operations file

The operations file can be created from the merge models dialogue.

<?xml version="1.0" encoding="UTF-8"?>

<merge_model_settings xmlns="http://www.wherescape.com/xml/3D" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemalocation="http://www.wherescape.com/xml/3D ./merge_model_settings_1.xsd">

   <xml_version>1</xml_version>

   <table action="when-missing-in-source-keep-in-target"/>

      <group>true</group>

      <schema>true</schema>

      <database>true</database>

      <label>true</label>

      <icon>true</icon>

      <table_type>true</table_type>

      <hidden>true</hidden>

      <rating>true</rating>

      <comment>true</comment>

      <ddl>true</ddl>

      <extended_properties action="when-missing-in-source-delete-from-target">true</extended_properties>

      <validation_expresion action="when-missing-in-source-delete-from-target">true</validation_expresion>

      <documentation action="when-missing-in-source-keep-in-target">true</documentation>

      <diagram_notes action="when-missing-in-source-delete-from-target">true</diagram_notes>

      <keywords action="when-missing-in-source-delete-from-target">true</keywords>

      <indices action="when-missing-in-source-keep-in-target">true</indices>

      <data_transformations action="when-missing-in-source-delete-from-target">

         <description>true</description>

         <condition>true</condition>

         <change_expression>true</change_expresion>

         <asigned_columns action="when-missing-in-source-delete-from-target">true</assigned_columns>

      </data_transformations>

      <business_rules action="when-missing-in-source-delete-from-target">

         <description>true</description>

         <validation_code>true</validation_code>

         <drill_down_code>true</drill_down_code>

         <expected_result action="when-missing-in-source-delete-from-target"true</expected_results>

      </business_rules>

      <source_mappings>

         <source_mapping_priority>true</source_mapping_priority>

         <source_mapping action="when-missing-in-source-delete-from-target"true</source_mapping>

         <query_join_types action="when-missing-in-source-delete-from-target"true</query_join_types>

         <query>true</query>

         <dw_query>true</dw_query>

      </source_mappings>

      <column action="when-missing-in-source-keep-in-target">

         <columns_order>true</columns_order>

         <label>true</label>

         <data_type_size_and_scale>true</data_type_size_and_scale>

         <column_type>true</column_type>

         <rating>true</rating>

         <nullable>true</nullable>

         <unique>true</unique>

         <pk>true</pk>

         <auto_increment>true</auto_increment>

         <default_value>true</default_value>

         <comment>true</comment>

         <hidden>true</hidden>

         <column_data_characteristics>true</column_data_characteristics>

         <extended_properties action="when-missing-in-source-delete-from-target">true</extended_properties>

         <validation_expression action="when-missing-in-source-delete-from-target">true</validation_expression>

         <documentation_subjects action="when-missing-in-source-keep-in-target">true</documentation_subjects>

         <diagram_notes action="when-missing-in-source-keep-in-target">true</diagram_notes>

         <source_mappings action="when-missing-in-source-delete-from-target">true</source_mappings>

         <source_mappings_order>true</source_mappings_order>

      </column>

   </table>

   <relationship action="when-missing-in-source-keep-in-target">

      <direction>true</direction>

      <types>true</types>

      <arrow_from>true</arrow_from>

      <arrow_to>true</arrow_to>

      <label>true</label>

      <comment>true</comment>

      <constraint_name>true</constraint_name>

      <sequence>true</sequence>

      <validation_expression action="when-missing-in-source-delete-from-target">true</validation_expression>

      <documentation action="when-missing-in-source-keep-in-target">true</documentation>

   </relationship>

   <layout>

      <overwrite_tables_position>true</overwrite_tables_position>

      <overwrite_notes_position>true</overwrite_notes_position>

   </layout>

   <equal_entities>

      <remove_from_targetfalse</remove_from_target>

   </equal_entities>

</merge_model_settings>


<?xml version="1.0" encoding="UTF-8"?>
<merge_model_settings xmlns="http://www.wherescape.com/xml/3D" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemalocation="http://www.wherescape.com/xml/3D ./merge_model_settings_1.xsd">
   <xml_version>1</xml_version>
   <table action="when-missing-in-source-keep-in-target"/>
      <group>true</group>
      <schema>true</schema>
      <database>true</database>
      <label>true</label>
      <icon>true</icon>
      <table_type>true</table_type>
      <hidden>true</hidden>
      <rating>true</rating>
      <comment>true</comment>
      <ddl>true</ddl>
      <extended_properties action="when-missing-in-source-delete-from-target">true</extended_properties>
      <validation_expresion action="when-missing-in-source-delete-from-target">true</validation_expresion>
      <documentation action="when-missing-in-source-keep-in-target">true</documentation>
      <diagram_notes action="when-missing-in-source-delete-from-target">true</diagram_notes>
      <keywords action="when-missing-in-source-delete-from-target">true</keywords>
      <indices action="when-missing-in-source-keep-in-target">true</indices>
      <data_transformations action="when-missing-in-source-delete-from-target">
         <description>true</description>
         <condition>true</condition>
         <change_expression>true</change_expresion>
         <asigned_columns action="when-missing-in-source-delete-from-target">true</assigned_columns>
      </data_transformations>
      <business_rules action="when-missing-in-source-delete-from-target">
         <description>true</description>
         <validation_code>true</validation_code>
         <drill_down_code>true</drill_down_code>
         <expected_result action="when-missing-in-source-delete-from-target"true</expected_results>
      </business_rules>
      <source_mappings>
         <source_mapping_priority>true</source_mapping_priority>
         <source_mapping action="when-missing-in-source-delete-from-target"true</source_mapping>
         <query_join_types action="when-missing-in-source-delete-from-target"true</query_join_types>
         <query>true</query>
         <dw_query>true</dw_query>
      </source_mappings>
      <column action="when-missing-in-source-keep-in-target">
         <columns_order>true</columns_order>
         <label>true</label>
         <data_type_size_and_scale>true</data_type_size_and_scale>
         <column_type>true</column_type>
         <rating>true</rating>
         <nullable>true</nullable>
         <unique>true</unique>
         <pk>true</pk>
         <auto_increment>true</auto_increment>
         <default_value>true</default_value>
         <comment>true</comment>
         <hidden>true</hidden>
         <column_data_characteristics>true</column_data_characteristics>
         <extended_properties action="when-missing-in-source-delete-from-target">true</extended_properties>
         <validation_expression action="when-missing-in-source-delete-from-target">true</validation_expression>
         <documentation_subjects action="when-missing-in-source-keep-in-target">true</documentation_subjects>
         <diagram_notes action="when-missing-in-source-keep-in-target">true</diagram_notes>
         <source_mappings action="when-missing-in-source-delete-from-target">true</source_mappings>
         <source_mappings_order>true</source_mappings_order>
      </column>
   </table>
   <relationship action="when-missing-in-source-keep-in-target">
      <direction>true</direction>
      <types>true</types>
      <arrow_from>true</arrow_from>
      <arrow_to>true</arrow_to>
      <label>true</label>
      <comment>true</comment>
      <constraint_name>true</constraint_name>
      <sequence>true</sequence>
      <validation_expression action="when-missing-in-source-delete-from-target">true</validation_expression>
      <documentation action="when-missing-in-source-keep-in-target">true</documentation>
   </relationship>
   <layout>
      <overwrite_tables_position>true</overwrite_tables_position>
      <overwrite_notes_position>true</overwrite_notes_position>
   </layout>
   <equal_entities>
      <remove_from_targetfalse</remove_from_target>
   </equal_entities>
</merge_model_settings>

  • No labels