CreateMigrationWorkspace

Title  Create Migration Workspace

Description

This tool is used to create a data model and data loading workspace suitable for use with the Data Loading tool.

Usage

          
This tool uses a simple data mapping workbook that has been populated with source/target mappings to extend the data model of an asset package to support the data as defined by the mappings.
Use the 'Create Simple Data Mapping' tool to create a blank source/target mapping workbook.

In the DataMapping workbook, the Exclude Copy Field sheet allows you to bypass adding fields to a target class when the copy field option is checked.  List the target class name(not qualified) and the name of the field that you do not want copied from the source.


License
Standard
Toolset
Data Migration

Syntax

CreateMigrationWorkspace (source_database, asset_package, mapping_spreadsheet, service_territory, output_folder, output_name, {dlt_mapping_table}, {add_missing_fields}, {match_options}, {calc_stats}, {match_subtypes})

Parameter Explanation Data Type
source_database Dialog Reference

The source feature dataset or workspace you want to migrate

 		GPComposite
asset_package Dialog Reference

The asset package you want to use as your base data model

 		DEWorkspace
mapping_spreadsheet Dialog Reference

Populated simple data mapping spreadsheet

 		DEFile
service_territory Dialog Reference

The extent and spatial reference used in the extended output asset package.

 		DEFeatureClass
output_folder Dialog Reference

The location to create a unique folder based on the value of the Output Folder Name parameter that will contain a modified copy of the input Asset Package and Data Loading Workspace.

 		DEFolder
output_name Dialog Reference

The name of the folder created in the location specified in the Output Location Parameter. If a folder already exist with provided name, a numerator will be appended to the end of the name.

 		GPString
dlt_mapping_table (Optional) Dialog Reference

A table that will be used to perform substring matching for datasets, values, and attribute domain coded value descriptions. Use the table to create matches or block them.

 		GPRecordSet
add_missing_fields (Optional) Dialog Reference

Copy fields from the source data that do not exist in the target

 		GPBoolean
match_options (Optional) Dialog Reference

Specifies whether field names or domain value descriptions will be matched.

  • Field Name Similarity—Field names will be matched based on similarity between the source and target fields.
  • Domain Coded Value Description Similarity—Attribute domain value descriptions will be matched based on similarity between the source and target fields. When this option is specified, fields will not be matched by name if the source or target field has a domain.

 		GPString
calc_stats (Optional) Dialog Reference

Specifies whether the count and percentage of filled-in values will be calculated for fields in the source schema.

  • Checked—The count and percentage of filled-in values will be calculated.
  • Unchecked—No calculations will be performed on the field values. This is the default.

 		GPBoolean
match_subtypes (Optional) Dialog Reference

Parameter is deprecated and has no affect on outcome of tool. This is managed internally when calling the Data Loading Tools.

 		GPBoolean

Code Samples