I plan to have Oracle Database Schema in source control in Azure DevOps and configure CI/CD pipelines to deploy changes. To do that I plan to Use VS 2019 and it's corresponding ODT. I know I can do a schema-compare through the visual studio interface; but in order to configure automatic deploy, I need to execute schema-comparison through a powershell script (this involves a command line to have the corresponding .sql file with the changes). Does anyone know how to do that? ¿Is it possible to call or run ODT's schema compare tool from command line or Powershell in order to create the deploy script?
I'd like to incorporate this as an automated step in the build process. I found that this can be done using "Schema Compare for Oracle of redgate" but is not free and it is not estimated or valued to buy it.
Thanks a lot for your attention and suggestions to solve this. Best regards. Audberto