topic Re: Automatically tracking database schema changes in Data Management Questions

Automatically tracking database schema changes

AhmadSALEH1 — Thu, 30 Aug 2018 18:07:07 GMT

Hi,

Is there any software that can be used to track the GIS database schema changes, I am looking for a method or a software that tracks any changes on the schema gives a detailed report about the geodatabase history!

Till now I am doing this using excel, it dose the job but not professionally . I draw a chart as an example for what am I thinking of:

This chart or report gives the history of Feature Class #1 inside the Database #1:

Thank you,

Ahmad

Re: Automatically tracking database schema changes

MitchHolley1 — Thu, 30 Aug 2018 20:12:08 GMT

Ahmad,

I have a tool that does something like this. Please check my GitHub repository for the code. However, this tool only lists GDB items, some info about them, and their fields. It does not compare two different geodatabases. Let me know if you have any ideas on how to improve on it.

Re: Automatically tracking database schema changes

AhmadSALEH1 — Thu, 20 Sep 2018 19:59:00 GMT

Mitch,

This looks awesome , I think this is a great tool to get the current status of the DB, but it doesn't provide full history of the database of course I can run it very time I change something in DB and get a new xls file.

It would be great if it tracks the history in one page. I know that this might be challenging in python.

Example:

Field A

Field A renamed to A2 on 9/9/2018

Field A renamed to A_02 on 9/19/2018

Feild B

Deleted on 9/19/2018

Field C

Added on 9/19/2018

Thank you,

Ahmad

Re: Automatically tracking database schema changes

MarcoDiazgranados — Tue, 23 Mar 2021 00:14:29 GMT

Hi Ahmad,

I'm looking something similar to track the schema changes for my geodatabases, are you find something usefull after all this years?

Thanks,

Marco