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

170
2
Jump to solution
12-29-2020 09:59 AM
TigerWoulds
Occasional Contributor

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? 

1 Solution

Accepted Solutions
JoeBorgione
MVP Esteemed Contributor

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/conversion/feature-class-to-feature-class.ht...

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)

https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/export-xml-workspace-documen...

https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/import-xml-workspace-documen...

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....

View solution in original post

Reply
0 Kudos
2 Replies
JoeBorgione
MVP Esteemed Contributor

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/conversion/feature-class-to-feature-class.ht...

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)

https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/export-xml-workspace-documen...

https://pro.arcgis.com/en/pro-app/latest/tool-reference/data-management/import-xml-workspace-documen...

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....

View solution in original post

Reply
0 Kudos
TigerWoulds
Occasional Contributor

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 😅

Reply
0 Kudos