Migrating a UN that exists in a Mobile GDB to SDE

[JenVerseput]

Reaching out to the community in the hope that someone has some real life experience with migrating a Utility Network contained within a Mobile GDB, to an SDE. We are in the process of piloting our Utility Network but the environment we are migrating to is not hosted by our organisation. We tried the copy and paste method and it worked really well but there was a lot of latency (between environments) which caused the process to run for hours. We make use of a Virtual Machine to access the SDE. The GDB is approx 4GB in size so we did not expect it to run for the amount of time it did. It took about 8 hours. Any options that might work better without losing data integrity?

Any advice would be great! Thanks in advance.

[RobertKrisher · Accepted solution]

You need to connect to a machine that has a better (i.e. lower latency) connection to your SDE environment. Even if you use something like an asset package to redeploy the database, you're going to run into the same problem with latency.

If you don't have a good, local connection to your SDE you should have a machine co-located with your SDE infrastructure that has ArcGIS Pro installed for administrative purposes. Some customers choose to have a dedicated machine, others will install ArcGIS Pro on one of the machines in their ArcGIS Enterprise deployment.

[JenVerseput]

Thanks for the advice, Robert. We managed to copy to our virtual machine's C-Drive and then loaded into SDE from there. It took about an hour, which is a huge improvement.