You can automate data export process using command line. Such possibility can be very useful if you need to export data from the same table or view quite often (for example, such data may be needed for generating a report, etc.). In this case you can create a template file using Data Export Wizard, where all export settings will be saved, and perform export by specifying the name of this file in the command line instead of going through all wizard pages. Note that some parameters like connection, destination file, and some others can be specified directly in the command line. In this case values of these parameters specified in your template file will be overridden.
- The generated file does not contain password information for security purposes. If the Save Password option is checked for the selected connection in dbForge Data Pump for SQL Server, you should not do anything regarding the password. If it is not, then you should define the password with the help of the /password option.
- It is not necessary to click the Export button in the wizard and perform the export process itself to create a template file.
C:\Users\user>C:\Program Files (x86)\Devart\dbForge Data Pump for SQL Server\datapump.com
/dataexport /templatefile: filepath
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 key and R at the same time, to show the Run command line.