In this example, we would like to show you a sample how to use a Windows batch file to execute the Reverse DB Engineer on a regular basis and store each resulting script as a date-stamped file for future reference.
Note the RevDDL executable has been passed two parameters: the name, including path, of the resulting .sql file, and the logon credentials of the user.
The name of the generated .sql file in this case is
D:\MyDDLs\2017_01_09_hr_pdbora12c4.sql
You may need to tailor the batch file to accommodate your own date format. Here, it is YYYY-MM-DD. Just type “date” from the command prompt to find out what it is on your machine.
Back to the overview