[GIS] Converting personal geodatabase .mdb file to .gdb

arcgis-10.2arcgis-desktopfile-geodatabasepersonal-geodatabasepython

Is it possible to convert an MS Access personal geodatabase file to a SDE enterprise geodatabase file format? What kind of python scripting would it entail? I need to convert it in such way to maintain consistent geometric/spatial properties for an application.

I have looked for similar questions but to no avail, please direct me to one if I missed it!

Best Answer

Take a look at the Feature Class To Geodatabase (Conversion) tool. This should hopefully do what you need. You can right click the tool and batch export a number of items.

Related Solutions

[GIS] Choosing File Geodatabase (.gdb), Personal Geodatabase (.mdb) or shapefile format

At a high level, it might be preferable to make a choice based on whether users are inexperienced and need nothing more than points, lines and polygons. Shapefiles could be suitable for this.

If they need annotation, domains for pick lists and validation, raster, longer field names, etc then File Geodatabases could be used which are easy to use, fast and can be massive in size.

Personal Geodatabases are based on MS Access. Unless there is a requirement for Access users to also interact with them, there is more restriction with this choice. The 2Gb size limit & inability to store rasters is restrictive.

[GIS] Converting multiple File geodatabase (.gdb) into multiple Personal geodatabase (.mdb)

Here is one approach that performs the following actions:

Create a new .mdb with old FGDB name, but in new workspace
Find all FC's in FGDB--take into account empty FDS's
Copy all FC's to .mdb

import arcpy, os

arcpy.env.workspace = r'C:\temp\inws'
inws = arcpy.env.workspace
outws = r'C:\temp\outws'

fgdb = arcpy.ListWorkspaces(workspace_type = "fileGDB")

counter = 1
for f in fgdb:
    # Define the output .mdb name
    name = os.path.basename(f).split(".")[0]

    # Create a new personal gdb (.mdb)
    arcpy.CreatePersonalGDB_management(outws, name)
    outgdb = os.path.join(outws, name + ".mdb")

    # Get the FC's in FDS and copy to .mdb
    arcpy.env.workspace = os.path.join(inws, f, "")
    fcs1 = arcpy.ListFeatureClasses()
    for fc in fcs1:
        arcpy.CopyFeatures_management(fc, os.path.join(outgdb, fc))

    # Get stand-alone FC's and copy to .mdb
    arcpy.env.workspace = os.path.join(inws, f, "URS")
    fcs2 = arcpy.ListFeatureClasses()
    # Make sure there are FC's in the FDS
    if fcs2 != None:
        for fc in fcs2:
            arcpy.CopyFeatures_management(fc, os.path.join(outgdb, fc))

    print "%s of %s workspaces converted" % (counter, len(fgdb))
    counter = counter + 1

print "Processing complete."

Best Answer

Related Solutions

[GIS] Choosing File Geodatabase (*.gdb), Personal Geodatabase (*.mdb) or shapefile format

[GIS] Converting multiple File geodatabase (.gdb) into multiple Personal geodatabase (.mdb)

Related Question

[GIS] Choosing File Geodatabase (.gdb), Personal Geodatabase (.mdb) or shapefile format