We need to query data from the national soils database. The data is in a file geodatabase (which is about 20 GB), but we need to query the data in a SQL Server environment. In ArcCatalog, I am able to import the tables I need into SQL Server Enterprise 2014 (not SQLServerExpress which has a 10GB limit!) from the file geodatabaes, except for one of them. This one table is about 12GB in size (and does not contain spatial info). When I try to import the table, ArcGIS Desktop (Advanced, ArcInfo license) crashes/closes. When I open ArcCatalog again I can see that the table/structure is there but it is empty. The file is too large to export to a dbf. How can I get this table OUT of the file geodatabase?
closed as unclear what you're asking by PolyGeo♦ Feb 4 '18 at 11:36
Please clarify your specific problem or add additional details to highlight exactly what you need. As it's currently written, it’s hard to tell exactly what you're asking. See the How to Ask page for help clarifying this question. If this question can be reworded to fit the rules in the help center, please edit the question.
I would try the following steps.
- In ArcCatalog, copy and paste the table in to the new ArcSDE db.
- Add the table to ArcMap, Open it, on the table window, Options Table export.
- Try using Model Builder to do it for you.
- Export your model to Python and try it.
- Then try all the steps again on a BIG server.
- Try running a Python script that just grabs the first 10 records and insert them to a table that you built. If this works just iterate through the rows. There just might be a data type that 2014 doesn't support.
Do you have a link to this gdb download?