nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Migrating UN from one geodatabase to another geodatabase using a different RDBMS

AnthonyRyanEQL

Hi there,

I'm looking at the documentation on Utility network dataset administration—ArcGIS Pro | Documentation about how to migrate a utility network dataset.

I'm trying to figure out how would I migrate from a geodatabase on AWS SQL Server RDS to HANA geodatabase on AWS infrastructure as well.

The documentation talks about export/inport using the XML workspace document from the dataset. Does this process include all of the associated/logically feature classes (eg. associations, etc) ? This would also be the same of the note mentioning the core copy & paste tools

Thanks

Find more posts tagged with

Accepted answers

RobertKrisher

I agree with John that the export/import asset package is likely going to be the fastest, most reliable way to transfer the data, especially if you have a lot of associations. My second choice would be copy/paste because of the ease-of-use but given the size of your database it may take some time to do the transfer. The import/export xml workspace document is a great way to transfer schema between databases, but if you are moving a sizable amount of data, it's not a very good option because of the size of the xml file involved.

All comments

JohnAlsup

Personally I would use the Apply Asset Package tool for creating and loading the initial data in to your Target UN. The tool is RDBMS agnostic.

I would also start with one of the esri foundation UN models.

Once your UN database is setup and loaded, the foundation documentation walks you through the process of enabling, versioning, publishing, etc.

The foundation solutions are found on the Esri Solutions site solutions.esri.com

AnthonyRyanEQL

John,

We have been using UN electric for the past 2 years in PRD so I'm looking into how to migrate an existing PRD UN which will be part of an ArcGIS Enterprise upgrade as well?

JohnAlsup

Then I would export to Asset Package and import that packing using the Apply Asset Package. In my opinion, that is the safest, fastest path.

RobertKrisher

@aperi read this article for more information about one-way feature service-to-feature service sync capabilities: One-way feature service-to-feature service sync for simple features. For a full utility network, you can use any of the approaches you mentioned above depending on your requirements.

aperi

Thank You @JohnAlsup and @RobertKrisher

Join the Conversation

Signed in members can post, follow updates, and more. New here? Register a free account.

Quick Links

Community Help
Find useful guides, FAQs, and documents to help you navigate and make the most of Esri Community.