Hi,
I have a need to run the SQL Developer "Database Export" on a regular basis and capture the results in source control. I have a repository built from files and folders generated by the Database Export feature for a production database. On a somewhat regular basis, I delete all the local files and folders and then re-run the wizard with the same options (excluding data). Then I commit the changes to the source repository. This way I can capture changes that have been applied to the database and source control them. I understand this is completely backwards, but the company has a very immature SDLC and some "cowboys" with elevated database privileges. On the way to improving the SDLC, we need to at least capture changes in some way for the sake of developers and leads.
Is there a way to parameterize and automate this SQL Developer wizard? Does SQLcl have an interface to it? I know I could write something using dbms_metadata but its extremely convenient that this feature exists and captures exactly what I want. I just want to avoid the points-and-clicks.