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"?> |