topic Re: Using Pro to extract GDB Schema in Geodatabase Questions

Using Pro to extract GDB Schema

ZacharyHart — Tue, 13 Oct 2020 17:57:25 GMT

We are finding there are still several GDB administration tools/processes that are unavailable with Pro. Since we cannot create GDBs in (Desktop) Database Servers (SQL Express) with Pro, we were looking for a workaround and it occurred to us that there doesn't seem to be any equivalent of the Extract Data Wizard in Pro.

Is there any other way to extract just the schema (via XML) from a GDB in Pro?

Alternatively, I don't see any option to use 'Schema Only' for a checkout GDB in the Create Replica GP Tool in Pro. Not that it would do any good, because we still can't find any equivalent to importing a workspace like you have in ArcMap.

Are we just overlooking something obvious here or are these findings correct?

Thanks!

Re: Using Pro to extract GDB Schema

Robert_LeClair — Mon, 26 Oct 2020 20:55:53 GMT

Zachary - I believe you can use the Export XML Workspace Document GP tool and set the export_type parameter to Schema Only. Then you have an *.xml of the entire GDB schema but no data.

In ArcGIS Pro and checkout/check-in replication, there is a parameter under the Expand Feature Classes and Tables where you can "add with schema only" - I wonder if that would work?

Re: Using Pro to extract GDB Schema

HilaryCampbell — Fri, 30 Oct 2020 12:11:25 GMT

So, is XML the only method for extracting schemas in Pro? I have no experience with XML. The Extract Data tool in the Distributed Geodatabase toolbar in ArcMap was seamless and simple: you could select the Schema only option and the result was a fully set-up GDB shell with no data in it, without exporting or importing anything. This is ideal for documentation, testing, etc.

If there is no plan to replace the Extract Data tool in Pro, please advise ASAP. This affects a number of my current projects. Thanks.

Re: Using Pro to extract GDB Schema

ZacharyHart — Fri, 30 Oct 2020 13:43:56 GMT

Are you then able to import the XML somehow to create a pre-configured GDB?

Re: Using Pro to extract GDB Schema

Robert_LeClair — Fri, 30 Oct 2020 13:55:28 GMT

Yes. First, create a new file geodatabase. Then use the Import XML workspace document GP tool to bring in the "schema only" feature classes/tables/etc. into the new gdb. The result is a file geodatabase with the schema only feature classes/behaviors/tables.

Re: Using Pro to extract GDB Schema

ZacharyHart — Fri, 30 Oct 2020 14:02:54 GMT

Thanks, that gets me part way there.

There's still no way to create eGDBs in a Desktop Database Server instance in Pro....I've been trying to find a work around for that.

I'll still give a +1 for Hilary Campbell‌ 's suggestion. There were/are a lot of great tools in ArcMap that haven't made the leap (and maybe wont) to Pro.

Re: Using Pro to extract GDB Schema

Robert_LeClair — Fri, 30 Oct 2020 14:05:35 GMT

Hilary - XML workspace documents are not the only way to extract data in AGP. You can also use the Package Result Geoprocessing tool with the "Schema only" parameter checked and the "Convert data to file geodatabase parameter checked" The result layer package (*.lpkx) will have all the data you selected in the in_result parameter in the layer package. Then you can add it to an existing project.

Of course, if you want to continue to use the Extract Data Wizard in the Distributed Database toolbar in ArcMap and use the file in AGP that is fine too. I haven't seen the Extract Data Wizard workflow in AGP yet but I suspect its an equivalency item the GDB Team is aware of. There is an ArcGIS Idea that references the "extract data" wizard that you may want to upvote - the URL is https://community.esri.com/ideas/10042?commentID=82770#comment-82770

Re: Using Pro to extract GDB Schema

Robert_LeClair — Fri, 30 Oct 2020 14:12:18 GMT

Understand Zachary - re: the Desktop Database Server instance in Pro - I did find a thread you were a part of earlier about this topic. As I work on the Training Services Team at Esri, I have zero control on the AGP development process...fingers crossed with each new release of AGP, more equivalency items are addressed.

Re: Using Pro to extract GDB Schema

ZacharyHart — Fri, 30 Oct 2020 14:14:39 GMT

Thanks for being so helpful Robert!!

Re: Using Pro to extract GDB Schema

Robert_LeClair — Fri, 30 Oct 2020 14:19:21 GMT

You're quite welcome - happy to assist! Stay safe and healthy!

Re: Using Pro to extract GDB Schema

HilaryCampbell — Tue, 22 Jun 2021 08:49:24 GMT

Zachary, FYI I've created an idea for this: https://community.esri.com/ideas/19259

Feel free to vote it up and spread the word so others do too. Thanks!