Fixing Geometry Issues After a Bulk Copy
Concept Procedure

For foreign schemas, the Bulk Copy operation uses the first geometry it finds to create the geometry in the target data store. If there are multiple spatial indexes for the geometry properties in the original data store, the geometry property in the resulting data store’s schema will be different from the order in the original data store. As a result, the geometry in the new data store may not match the geometry in the source.

You can fix this problem in the original data store or in the resulting data store. If you fix the problem in the resulting data store, you modify the XML file schema and import the modified version into the data store.