EMS logo

Products Navigation

Data Export for SQL Server

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS Data Export for SQL Server

On-line Documentation

Step 8 - Setting common options


Use this step of the wizard to set common export options. The detailed description of these options is given below.

 

Destination file

Use this edit field to set the name of the output file. You can click the Select... button to define it using the Save As dialog.

 

CheckBox Open file after export

If this option is checked, the result file will be opened with the currently associated program after the export operation is completed.

 

CheckBox Print file after export

If this option is checked, the result file will be sent to the default printer after the export operation is completed.

 

CheckBox Append datatime to file name

Check this option to add current datetime to the filename.

 

Step 8

 

 

Constraints

 

Skip ... record(s)

Specifies the number of records to be skipped before export starts.

 

CheckBox Export empty data

The option indicates whether empty records should be exported.

 

CheckBox Export binary data as hex

Check this option to present binary data in exported file as HEX.

 

RadioButton Export all records

Specifies that all records of the selected table will be exported.

 

RadioButton Export only ... record(s)

Specifies the number of records to be exported.

 

Save Export Options... / Load Export Options...

Use these buttons to save / load all export settings to/from an external configuration file. For details refer to Configuration file format.

FTP options

 

CheckBox Upload to FTP

Check this option to enable uploading of exported files to FTP server. After that define connection settings:

 

  • Host is the name of the FTP server.
  • Port indicates the port of the FTP server.
  • Path is the the directory on the FTP server where you want to upload exported files.
  • User stands for the user name on the machine with FTP server.
  • Password is the user password.

 

Click the Check connection button to check connection to the FTP server with the settings defined above.

 

 

Hint: If more convenient, you can check the CheckBox Apply to all exported objects box to set the specified options for all exported objects.

 

CheckBox Don't show this step anymore

Use the option to disable this step. To enable the step use the appropriate option at the General tab of the Preferences dialog.

 

When you are done, press the Next button to proceed to the next step of the wizard.