Extracting data from a table or view to a .data file

You can extract the data from a table or view to a .data file on the file system.

Procedure

To extract data from a table or view to a .data file:

  1. Right-click a table or view in the Data Source Explorer, and click Data > Extract. If you are in the Object List, right-click the table or view and click Unload > With SQL. The Extract Data window opens
  2. Specify a name and location for the file. Specify delimiter options, and then click Finish.

Results

The .data file is saved to the directory that you specified, and the results of the data extraction are displayed in the SQL Results view.

Feedback