Exporting SQL Server Data
The Export Data dialog allows you to export SQL Server table and view content
into CSV files.
The Export Data Dialog
- Server: Displays the SQL Server instance you are connected to. This is a static
box and is for informational use only.
- Database: Displays the SQL Server database you are connected to. This is a static
box and is for informational use only.
- Table/View: Displays the SQL Server table
or view you are exporting. This is a static box and is for informational use only.
- Export All Rows: Check this box to export
all rows in the table or view. To export a subset of the rows, uncheck this
box and click on Edit SQL, then add a WHERE clause to the default query. If
you are exporting into XML, do not change the original part or the query.
- Save To: The location of the exported file.
Exporting XML Files
The export XML feature generates three files with the same file name and the
following extensions:
XML: Contains the actual data content of the exported table or view.
XSD: Contains the schema definition of the exported table or view.
TXD: Contains additional schema definition proprietary to Teratrax.
The XSD and TXD files must be kept in the same folder and with the same names
as the XML file in order for Teratrax Database Manager to import the XML file
into a SQL Server database. Do not delete or rename these files.
Related Links
Backup and Restore Individual Tables
Using XML
Copy Tables Between SQL Server
Instances
|
