Upon completion of this course, the student will be able to: Describe the DTS architecture and the Import and Export process. Explain the transformation process. Describe the DTS Package Designer. Explain the three replication methods. Explain the process of Conflict Resolution.
Data Transformation Services
- Data Transformation Architecture
- Importing and Exporting Data
- Transforming Data
- DTS Package Designer
Replication
- Overview
- Snapshot Method
- Transactional Method
- Merge Method
- Conflict Resolution