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:
- Right-click a table or view in the Data
Source Explorer, and click . If you are in the Object
List, right-click the table or view and click . The Extract Data window
opens
- 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.