SQL Server Essentials for Oracle DBAs: (11) Data Movement
- Posted: Dec 28, 2012 at 9:10AM
- 9,009 views
Right click “Save as…”
Module 11 examines the non-transactional mechanisms for moving data into and out of a database. The functionality varies based on homogeneous and heterogeneous databases. One key feature in SQL Server is SQL Server Integration Services (SSIS). SSIS provides users with the capabilities beyond complex ETL and high performance data movement from heterogeneous data sources. It also adds data mining capability to the process and more, all of which will be discussed in this module. Other approaches to bulk data movement will also be covered in this module and guidelines will be provided on which tools are appropriate for what scenarios.
Full course outline: