How to Merge the Asset packages in EGDB

[jayaramBirudukota]

Hi,

I have already pushed one asset package into the UN-enabled EGDB. Now, I have two more asset packages with the same schema and EGDB version. I would like to load both their spatial and non-spatial data into the same EGDB.

Please suggest the best and most efficient approach for high-speed data loading.

[gis_KIWI4]

You have a few options here but these in my opinion are the easiest. 

1) use data loading tools. Specifically the append tool if the schema is the same.

https://doc.arcgis.com/en/arcgis-solutions/latest/tool-reference/data-loading/append-with-transforma...

2) Use tools like FME. Load data via the UN service. 

one shortcoming is that it doesn’t create vertex on the line if a device is “added” mid segment. Which means the device isn’t topologically connected. 

A more fool proof way would be to merge all the data in the asset package before deploying the UN. 

[jayaramBirudukota]

Hi kiwi,

Thanks for responding to my previous question. Actually, I don’t have just 2 GDBs — I have more than 5,000 asset package GDBs, each representing different exchange data. Since multiple team members are working in parallel, we are planning to push all these GDBs into the same EGDB.

Merging all these files into one is not feasible due to size limitations, so I’m looking for the best approach to load the data — either in parallel or one by one — efficiently and accurately. Please suggest the most effective and high-speed method for this process.

Thank you.

[RobertKrisher]

The point @gis_KIWI4 makes about missing vertices is one you need to consider carefully. If the source data is coming from a geometric network, and you aren't creating new features, then this isn't a big concern. If the data is being created outside of an environment that maintains a proper topology, then your appending process must identify and create any missing vertices on lines (in the asset package as well as in the source data) to ensure the newly imported data becomes properly connected. If you need to create missing vertices, you will probably want to use FME.

The methods suggested by @gis_KIWI4 should work regardless of whether you're loading one asset package or 5,000 asset package, although individually loading 5000 asset packages will require some special attention be paid to how you load and QaQc each package as well as how you manage pruning out the unnecessary history you will be creating during the loading process.