AnsweredAssumed Answered

Benifits of using a staging GDB prior to loading data into SQL SDE database

Question asked by JCSCO_GIS on Oct 9, 2017
Latest reply on Oct 9, 2017 by asrujit_pb

I'm working with several large polygon data sets which can be both stand alone shape files or feature classes
from a FGDB. The end destination is a SQL sde database, is it best practice to load directly to SDE or first
load to a staging GDB (perform data prep, ie--> rename, geometry checks/repairs, re-projections...etc) then load to SDE?


The data sets will be loaded and reloaded on a regular basis. I would like to do a nightly compare and load new data in an automated fashion.

Thanks for any feedback on the topic