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?
Solved! Go to Solution.
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/copy.htm
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
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/copy.htm
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
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 😅