DTS Import/Export Wizard Network Protocol
The data transformation services (DTS) is a Microsoft SQL Server 2000 database module that assists you in transferring data between tables and other databases. The wizard protocol allows you to use a graphical interface instead of writing tedious SQL code.
Other People Are Reading
-
Significance
-
Transferring data between databases is a delicate procedure that can cause data corruption or loss if not done properly. SQL Server provides the wizard protocol that lets you use an interface to choose your data, filter out unwanted data and create tables without using SQL code. The DTS wizard creates the SQL code for you, lowering the possibility of typing the wrong code, which causes errors.
Types
-
The DTS wizard lets you import and export to other applications, such as Microsoft or Access, Oracle databases or or a plain text file. You can export data to other formats, so you can email a spreadsheet to coworkers. It also lets you create a backup of your data to another database, such as Oracle or another SQL Server.
-
Considerations
-
When transferring data, ensure you have a backup of your files and data. Although the DTS wizard lowers the chance of a mistake, it does not eliminate the possibility of transferring to the wrong database or creating an incorrect table.
-
