Copy Tables Between SQL Server Instances
The Copy, Paste Structure, and Paste Data features in Teratrax Database
Manager provide an easy and convenient way to duplicate tables in the same
database or different databases on the same SQL Server instance. To copy a table
from one SQL Server instance to another, you need to use the XML export and
import features.
The XML export and import features in Teratrax Database Manager provide a way
to copy an individual table from one SQL Server instance to another.
Simply export the table to your local computer in XML format and import it into
a
database on a different SQL Server instance. 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
Backup and Restore Individual Tables
Using XML
|
