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

Use the Extract Data window to extract the data from a table or view into a 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.
  2. In the window that opens, specify a name and location for the file. Specify delimiter options, 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