We have an ArcGIS spatial database.
It has roughly 70 Feature Classes.
It was populated a few years back...
I now want to clean the database up a bit and change various field names, re-order some of the fields, remove redundant fields.
It's a simple gdb with no domains or other relationships....just a heap of FCs.
From reading there's no easy way to change the db schema ?
I'm thinking of exporting the SDE to .XML, do edits to the schema there...and somehow get the data back into the new schema??
Anyone had any experience doing this? And what is the best way to go about it ?
The other idea I had was to create new FCs and Append the old data to the new FC schema....