1

after migration from File Geodatabase (.gdb) to Personal Geodatabase (.mdb) - how to change automatically all field names at query definitions at the MXD from " " to [ ]

What's else is important when conducting such transition ? I'm using version 10.1 sp1 and I have a MXD with dozens layers and dozens of queries, also at the symbol classes of the labels there are even more SQL syntax to change.

Thanks in advance!

Improve this question
7
  • How many such modifications to Definition Queries do you need to make? Are you using ArcGIS 10.1 or 10.2? Are you comfortable with ArcPy and Python? Please edit your question to provide any answers rather than as Comments so that potential answerers can read all the relevant info in one place.
    – PolyGeo ♦
    Commented Aug 15, 2013 at 11:06
  • I'm curious about the direction of your migration and what requirements drove that to be your choice. Using 10.1 SP1 is good because it would let you use arcpy.da.Walk if you later needed to do this in multiple folders.
    – PolyGeo ♦
    Commented Aug 15, 2013 at 12:44
  • The FGDB was the draft and contained the raw material of project and the volume was above 2G. the final version of the project is at PGDB, another reason to migration is to handle fields order using MS ACCESS. I'm new in Python Could you elaborate more ?
    – Dror Har Gil
    Commented Aug 15, 2013 at 12:53
  • 2
    It should be noted that the size limit for PGDBs is 2GB, and that their performance degrades after 500mb. I'm not certain if you can reorder fields in access without potentially damaging the ArcGIS handling of the feature classes.
    – DPierce
    Commented Aug 15, 2013 at 14:01
  • about reordering fields - You should back up your database before using ACCESS platform reorder fields, for me It works without problems
    – Dror Har Gil
    Commented Aug 15, 2013 at 14:18

1 Answer 1

Reset to default
2

Updating definition queries in map documents after the workspace has been changed is all discussed in.....the help file!

Improve this answer
1
  • 2
    Your link does address some of the migration issues, however for definition query updates it shows how to go from PGDB to FGDB not FGDB to PGDB. A bit more logic is involved when replacing double quotes with brackets.
    – artwork21
    Commented Aug 15, 2013 at 16:00

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge you have read our privacy policy.

Not the answer you're looking for? Browse other questions tagged or ask your own question.