Best Practise/Way to reorder, rename fields, alter schema in a GDB

[timdunlevie]

Hi all,

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

Thanks,

Tim

[JayantaPoddar]

Hi Tim,

Have you tried Sort (Data Management) tool?

And Renaming a field (ArcGIS 10.2 and later).

Thanks,

Jay

[timdunlevie]

Thanks for the reply but I dont need to sort values in a field but need to reorder column/metadata names, remove columns, rename columns etc..

thanks

[JayantaPoddar]

Hi Tim,

You could try ArcGIS Diagrammer

Thanks,

Jay

[JohnBrodnicki]

The "Alter Field" tool would help with renaming fields. I don't know of any tools available in Arc to re-order fields. I think your best bet will be to create new feature classes with the correct/updated schema and append the data. If everything goes right, you could then delete the old features classes and rename the new ones to the old feature class names. If you have GlobalIDs, you may want to do some research to make sure the GlodalbID doesn't change when you append the data. If you don't have any replicas, relationship classes, or joins based on GlobalID then this would be a non-issue.

[timdunlevie]

Thanks John,

Yeah I was thinking of doing it the hard way – new FC, append existing data.

Yeah we haven’t assigned GlobIDs as yet….we intend to roll out the replication to other sites later.

Thanks,

Tim

[deleted-user-8KkqhMYcTNGx]

The Xray for Geodatabases Add In has a Reorder Fields Tool, which sounds like it may be exactly what you are looking for. Here is the Link: http://www.arcgis.com/home/item.html?id=9ea218ff575f4a5195e01a2cae03a0ae

[OwenEarley]

Jayanta has already mentioned one - ArcGIS Diagrammer is a useful tool for creating or adjusting a geodatabase schema.

If you create your new schema FME Desktop has some good tools for mapping data from a source to a target feature class. It is a commercial product but it may save you some time. The alternative is using the Simple Data Loader or Append tool.

[deleted-user-8KkqhMYcTNGx]

It should also be mentioned that ArcGIS Diagrammer has not been upgraded to work with ArcGIS Desktop version 10.3... So depending on which version of the software you are running it will not work.

Please help Promote this Idea to add ArcGIS Diagrammer functionality to Version 10.3

http://ideas.arcgis.com/ideaView?id=087E0000000CuxTIAS

[timdunlevie]

Thanks.

I did have a look at ArcGIS Diagrammer.

I like the fact it’s simple to use to adjust/create/edit schema design…but I still have to re-import/append data to the new design right?

Thanks,

Tim