Run Generate Schema Report for a subset of Feature Classes/Tables

CarstenB_orsted

 

The Generate Schema Report Tool works great. However, the tool currently only supports a single dataset or the entire workspace.

I would like to be able to select a subset of feature classes or tables.

Use case: I am developing an application that uses four feature classes and two tables in a very large enterprise GDB.

When migrating schema changes from the Dev GDB to Staging or Production, it could be very useful to have a single schema report for the subset for comparison using the Compare Schema Tool.

Currently, you have to run Generate Schema Report six times in each environment and then Compare Schema six times, and lastly compare file by file.

Ayan Palit

@CarstenB_orsted Thanks for the idea - the use case makes sense.

Please consider the following :

• You can run the Generate Schema Report tool in batch mode and select a subset schema objects of interest.
• Input Dataset may be the workspace, feature dataset, feature layer, or table view that will be used to generate the schema report.

Additionally:

1. Generate Report: In the Catalog pane, right-click your geodatabase, select Export, and choose Generate Schema Report. Select XLSX as the format for easy editing.
2. Edit Schema in Excel: Open the exported Excel file. You can modify fields, aliases, domain values, and subtype definitions directly in the sheets.
   • You can trim it down to the just the schema objects of interest.  
   • Note: Do not change structural, read-only columns required by the tool.
3. Convert Report: Open the Convert Schema Report geoprocessing tool.
4. Apply Changes: Input your edited Excel file and specify the target geodatabase (or a new one) to implement the changes.

REF: Edit schema reports for conversion