Hi All!
We are trying to accomplish the task of providing the 'database diff' whenever a new update of the database is rolled out. Basically, we install two databases one with current schema and one with previous one and then use Oracle SQL developer feature to generate the database diff. ( Tools -> database diff ).
We are able to see the results we want, but the problem is the steps are manual. Hence someone has to manually go to SQL developer and follow the steps every time we roll out a release.
We are looking to automate and integrate the step in the release pipeline with teamcity.
According to me if there is a way to get it done via command line prompt then we could use scripts to get the job done in teamcity. But I am not able to find a way to get it done in command line.
Do anyone know if there is a way to get the same result using command line ? Will be keen to hear any other approach to this problem as well.
Regards