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

6237
13
02-17-2015 12:37 AM
Highlighted
Occasional Contributor

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

Tags (2)
Reply
0 Kudos
13 Replies
Highlighted
Honored Contributor

Hi Tim,

Have you tried Sort (Data Management) tool?

And Renaming a field (ArcGIS 10.2 and later).

Thanks,

Jay

Reply
0 Kudos
Highlighted
Occasional Contributor

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

Reply
0 Kudos
Highlighted
Honored Contributor

Hi Tim,

You could try ArcGIS Diagrammer

Thanks,

Jay

Reply
0 Kudos
Highlighted
New Contributor III

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.

Reply
0 Kudos
Highlighted
Occasional Contributor

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

Reply
0 Kudos
Highlighted
Occasional Contributor

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

Reply
0 Kudos
Highlighted
Regular Contributor

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.

Highlighted
Occasional Contributor

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

Reply
0 Kudos
Highlighted
Occasional Contributor

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

Reply
0 Kudos