How to merge various PGDB into one PGDB

146
3
07-11-2020 05:47 AM
RajeshKumar4
New Contributor

I have hundreds of PGDB files of various areas of country. I want to merge those into one PGDB to access entire country data at a time. Can someone give me the solution for this. Thank you !

0 Kudos
3 Replies
DavidPike
MVP Frequent Contributor

Is there a reason for it being a personal GDB?

0 Kudos
RajeshKumar4
New Contributor

we deliver the output to client in PGDB format.

0 Kudos
DavidPike
MVP Frequent Contributor

You could use the Merge (Data Management) tool, or if you're dealing with a lot of MDBs I would script something like ListWorkspaces (MDB), ListFeatureClasses for each and produce of all Feature Classes joined to their workspace path (os.path.join()) then use this as input to the Merge tool.

This also depends on you not having relationship classes etc. inside the MDBs, and not exceeding the 2GB limit.

0 Kudos