You can automate data import process using command line. Such possibility can be very useful if you need to import data to the same table or view quite often. In this case you can create a template file using Data Import Wizard, where all import settings will be saved, and perform import by specifying the name of this file in the command line instead of going through all wizard pages. Note that some parameters like connection, input 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.
You cannot import data into a new table using command line.
- 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 Import button in the wizard and perform the import process itself to create a template file.
C:\Users\user>"C:\Program Files (x86)\Devart\dbForge Data Pump for SQL Server\datapump.com"
It is not necessary to specify the extension of the datapump file with the .com extension.