Compare tables in two different geodatabases

Question

I have two geodatabases, one with February data (Final_Project_2.gdb) which contains 6 feature classes. The second geodatabase has March data, (Clipped.gdb), which also contains 6 feature classes, the same ones' as the first one, except some of the feature classes attribute tables have been updated. I have been trying to run the Table Compare tool in ArcGIS Pro, but as a python script, and just can't get it. In reality I just want to get the row count from each table in each feature class from the new database and compare it to the row count of each table in each feature class to the old database and see which feature class was updated/changed, so that the GIS library can be updated accordingly.

I've ran the tool in ArcGIS Pro and can do it one by one, by I would like to do like a loop, and go from GDB1 to GDB2, and if they are == (no change), skip, but if there is a change, print out the Name.

This is a script I tried but got an error:

clippedGBD = r"C:\GIS6340\Final_Project_GIS6340\FC_03132022\ClippedFC\ClippedGDB.gdb"
in_base_table = r"C:\GIS6340\Final_Project_GIS6340\FC_03132022\ClippedFC\ClippedGDB.gdb"
in_test_table = r"C:\GIS6340\Final_Project_2\Final_Project_2.gdb"
sort_field = "OBJECTID"
compare_type = "ALL"
ignore_option = "IGNORE_EXTENSION_PROPERTIES"
attribute_tolerance = "None"
omit_field = "ALL"
continue_compare = "CONTINUE_COMPARE"
compare_file = "C:\GIS6340\Final_Project_GIS6340\FC_03132022\ClippedFC\Compared.cvs"

compare_result = arcpy.TableCompare_management(
    in_base_table, in_test_table, sort_field, compare_type, ignore_option, 
    attribute_tolerance, omit_field, continue_compare, compare_file)

Error:

Traceback (most recent call last):
  File "<string>", line 14, in <module>
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 2023, in TableCompare
    raise e
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\management.py", line 2020, in TableCompare
    retval = convertArcObjectToPythonObject(gp.TableCompare_management(*gp_fixargs((in_base_table, in_test_table, sort_field, compare_type, ignore_options, attribute_tolerances, omit_field, continue_compare, out_compare_file), True)))
  File "C:\Program Files\ArcGIS\Pro\Resources\ArcPy\arcpy\geoprocessing\_base.py", line 512, in <lambda>
    return lambda *args: val(*gp_fixargs(args, True))
arcgisscripting.ExecuteError: Failed to execute. Parameters are not valid.
 ERROR 000732: Input Base Table: Dataset C:\GIS6340\Final_Project_GIS6340\FC_03132022\ClippedFC\ClippedGDB.gdb does not exist or is not supported
 ERROR 000732: Input Test Table: Dataset C:\GIS6340\Final_Project_2\Final_Project_2.gdb does not exist or is not supported
 ERROR 000893: An empty GP value or text is entered.
Failed to execute (TableCompare).

Answer 1

I'll answer this part of your question:

In reality I just want to get the row count from each table in each feature class from the new database and compare it to the row count of each table in each feature class to the old database and see which feature class was updated/changed

You could write a function that takes the geodatabases as inputs and compares the number of features in the corresponding feature classes (and note any feature classes that don't exist in either gdb). Not the cleanest code, but you could do something like:

import arcpy
import os


def compare_gdbs(gdb_1, gdb_2):
    # Turning the list into a set makes comparison easy.
    arcpy.env.workspace = gdb_1
    fcs_1 = set(arcpy.ListFeatureClasses())
    arcpy.env.workspace = gdb_2
    fcs_2 = set(arcpy.ListFeatureClasses())

    fcs_only_in_1 = fcs_1 - fcs_2
    for fc in fcs_only_in_1:
        print(f'{fc} only in {gdb_1}')

    fcs_only_in_2 = fcs_2 - fcs_1
    for fc in fcs_only_in_2:
        print(f'{fc} only in {gdb_2}')

    fcs_in_both = fcs_1.intersection(fcs_2)
    for fc in fcs_in_both:
        fc_path_1 = os.path.join(gdb_1, fc)
        fc_path_2 = os.path.join(gdb_2, fc)

        # GetCount returns a Result object. Make into a number.
        num_features_1 = int(arcpy.management.GetCount(fc_path_1)[0])
        num_features_2 = int(arcpy.management.GetCount(fc_path_2)[0])

        if num_features_1 == num_features_2:
            print(f'{fc} matches feature count')
        else:
            print(f'{fc} #1: {num_features_1}, {fc} #2: {num_features_2}')

    return


if __name__ == '__main__':
    gdb_old = r'C:\GIS6340\Final_Project_GIS6340\FC_03132022\ClippedFC\ClippedGDB.gdb'
    gdb_new = r'C:\GIS6340\Final_Project_2\Final_Project_2.gdb'
    compare_gdbs(gdb_old, gdb_new)