Best practices when moving data from File GDB to Enterprise GDB?

TigerWoulds · ‎12-29-2020

I have a large Terrain Dataset (roughly 450 GB) that I need to move from a File Geodatabase to an Enterprise Geodatabase on SQL Server.

I figured I could just Copy/Paste the data to the EGDB but I'm assuming this will lock up my ArcGIS Pro session for a LONG time.

Is there a preferred GP tool or way to do this that would increase my chances of this working successfully?

JoeBorgione · ‎12-29-2020

If you are going to move that much data, you should count on it taking some time especially if you are dependent on network connections, vpn's etc.

You have a few options, and I would do it as a python script you can either run as a scheduled task or set it and forget it after quitting time.

https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/append.htm (you'd need to create features in the target Egdb of the same names and schema as your fgdb)

All come to mind. I suspect best practice is in the eye of the beholder; for me it's whatever works and gives me the smallest headache

can't wait to retire....

JoeBorgione · ‎12-29-2020

If you are going to move that much data, you should count on it taking some time especially if you are dependent on network connections, vpn's etc.

You have a few options, and I would do it as a python script you can either run as a scheduled task or set it and forget it after quitting time.

https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/append.htm (you'd need to create features in the target Egdb of the same names and schema as your fgdb)

All come to mind. I suspect best practice is in the eye of the beholder; for me it's whatever works and gives me the smallest headache

can't wait to retire....

TigerWoulds · ‎12-30-2020

Thanks much! I will give the Copy tool a go then try the XML workflow if that fails. I'll get back with you in a week or two when this is done 😅