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!

  • 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 Aug 15 '13 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 Aug 15 '13 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 Aug 15 '13 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 Aug 15 '13 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 Aug 15 '13 at 14:18

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

  • 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 Aug 15 '13 at 16:00

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

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