New to the GIS world, but have a little background with Python. I'm attempting to compare an Access DB to a GDB and update the GDB for specific fields if there is a difference. I've read multiple places that updating a field like length or width directly with SQL can cause issues, so I wanted to make sure I'm using the appropriate modules to update the fields. I found a similar link below that is attempting to something similar, but I'm only wanting to update the differences in specific fields. The other issue is that the field columns are named differently, utilizing SQL I could just rename the column and match the values appropriately, but I haven't found any documentation stating that I can do the same with modules such as TableCompare_management, and join.
Just to confirm, can I not just compare each row from the access db by a unique ID to the GDB, and update the fields that are different? Or will that really break things?