Dano1970

Export data out of SDE in consistent order each time

Discussion created by Dano1970 on Apr 27, 2012
Latest reply on Apr 30, 2012 by Dano1970
Hello All,

My problem is that I need a unique, maintained attribute field to perform SQL on later in my workflow in order to maintain database linkages in a computer aided dispatching system between rebuilds.

Is there a way to have the records, being exported from an SDE using Feature Class to Feature Class, populate the newly created feature class in the same order each time?
In other words, when exporting data, from the SDE, I would like FID 1 to be the same record each time I export the same feature class. Currently, each time I export data FID 1 ends up being a different record.

Thanks,
Dan Sereno
GIS DBA

Outcomes