i`m looking for ways to generate DDL ALTER script between different versions of the same model using python.
Let`s say i have two DDL scripts for different versions of the model(newer and older), i need to compare those two and then generate DDL ALTER script for changes in order to update database to a newer version.
I`m looking for some API for Python or command line .
Ive tried using Erwin API for this but seems its only able to generate DDL Create Script Also i
m not looking at any GUI - based programs