How to Export SQL Server Data to Other File Formats

  1. In Object Explorer, right-click a database, point to Data Pump, and then click Export Data. On the Export format page, select an export format or load export options from a template file if you saved them previously and click Next.

  2. On the Source page, select a required SQL Server server connection, a database, table(s), view(s), which you want to export, and then click Next.

    Note

    If you opened the wizard from the data grid, the Source tab would allow to specify only a name and a path of the destination file (the one where the exported data will be saved.

  3. Set additional settings for the selected export format on the Options wizard page and click Next.
  4. Select exported columns and click Next. (For CSV, HTML, PDF, RTF, and Text export formats, select formats of data representation, e.g., integer, date, time, etc. For Excel and Excel 2007 formats, the field is editable only for binary columns and includes only two data types (HexString and String) in the drop-down list).
  5. Select exported rows. You can export all rows, only selected in the grid ones, or a specified range.
  6. Specify how the application should behave when an error is encountered.
  7. (Optional) To export options to a template file for future usage, click the Save Template button and specify a path and a name of the template file.
  8. Define how dbForge Data Pump for SQL Server should handle errors during export and whether to write a log file.
  9. Click the Export button and see the result of export process.
  10. Select whether to open the exported file or result folder, and click the Finish button. Data export is finished. ExpandedToggleIcon(9x12) Filtered data export

There is a filter in the Data Export wizard window.