oracle

Execute Reverse DB from a batch file

09 Feb 2017

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