Online Documentation for Data Export for SQL Server

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.

 

File properties

Destination file

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

 

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.

 

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.

 

Use file name template

If this option is checked then current date and time are added to the result file name.

 

 

Constraints

Skip ... record(s)

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

 

Export empty data

The option indicates whether empty records should be exported.

 

Export binary data to Base64

Check this option to encode binary data in the exported file as Base64.

 

Export all records

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

 

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.

 

Upload options

Select the protocol in the Upload mode field 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 Apply to all exported objects box to set the specified options for all exported objects.

 

Don't show this step anymore

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

 

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