In this example, we will create the HR database backup.
To back up a database:
A project file contains all the information that you have entered while walkthrough the wizard pages.
To run backup from the command line:
Note
To run the Command Line in Windows 8:
From the Desktop Mode
- Move the mouse cursor to the exact lower left corner until the desktop shortcuts menu appears.
- Right-click to see the shortcut menu and than click Run
From the Charms Bar
- Move your mouse to the upper right corner until the Charms Bar appears.
- Select Apps from the list and type run in the search box.
- Click Run from the search results.
Use Windows+R Shortcut Keys
- In desktop mode, press the Windows+R keys, to show the Run command line.
"c:\Program Files\Devart\dbForge Studio for Oracle\dbforgeoracle.com" /schemaexport/projectfile:c:\Backup\HR.backup
Press Enter.
When the process is over, a backup file appears in the specified directory.
Here are some additional commands that can help you work within the command line. Type the one you need, and then press ENTER.
/schemaexport /?
/connection:<connection_string>
/outputfile
/password:<pw>
/projectfile
/schema
You can use the Windows Task Scheduler to create and manage backup tasks that your computer will carry out automatically at the times you specify.
To create Windows task:
Note
To run Windows Task Scheduler:
- Click Start and then click Control Panel.
- Click Administrative Tools.
Note
If your current view is Category, click System and Security, and then click Administrative Tools
- Click Task Scheduler.