Backup and Restore Individual Tables Using XML
The XML export and import features in Teratrax Database Manager provide a way
to backup and restore an individual table in your database. You can restore a
table that has been exported into XML by simply importing it back into the
database. You can import the table on the same instance or any other SQL Server
instance creating a copy of the table. During the import, you can specify a new
table name to create the table alongside the old table if you are importing into
the same database. You can export a table from a SQL Server 7 or SQL Server 2000
instance and import it on a SQL Server 2005 instance under any existing schema
by simply specifying the full name of the new table ([Schema].[Table]).
When exporting a
table into XML, Teratrax Database Manager stores schema definition information
about the exported table in the .XSD and .TXD files. When importing an XML file,
Teratrax Database Manager uses the .XSD and .TXD files associated with it to
recreate the table the same way it was at the time of the export. The following
list illustrates the table structure elements that are preserved after importing
XML files:
| Structure Element |
Preserved |
| Data Types |
YES |
| Column Size, Precision, & Scale |
YES |
| Allow Nulls Indicator |
YES |
| Identity Indicator |
YES |
| Collation |
YES |
| Computed Column Indicator |
YES |
| Defaults |
NO |
| ANSI Padding |
NO |
| Rules (Deprecated in SQL Server 2005) |
NO |
| Triggers |
NO |
| Indexes |
NO |
| Primary Keys |
NO |
| Foreign Keys |
NO |
| Unique Constraints |
NO |
| Check Constraints |
NO |
Related Links
Importing Data into SQL Server
Exporting SQL Server Data
Copy Tables Between SQL Server
Instances
|
