Skip to main content
Sign in
Home 2012 2008 R2 2008 Previous Versions Library Forums
SQL Server > 2008 > SQL Server for Oracle DBA > Module 11: Data Transport

Module 11: Data Transport

In this module, you will learn the following:

  • Tools and functionality in Oracle and their equivalents in SQL Server for:
    • Data transport out of the database
    • Data transport into the database
  • Tools and functionality in SQL Server for data transport into, out of, and within a database and across multiple databases, multiple file formats, and other data sources and destinations

If you've installed Silverlight, you can click the Play button in the video player at left.
Or, right-click (Save Target As...) the link below to download.

Video Download
WMV

Length: 23 Minutes 40 seconds

Downloads
Powerpoint - Open the file using PowerPoint 2007.
Zip - Unzip the file, click launch.htm to view interactive training.

Module 11: Demo 1

In this demonstration you will learn to:

  • Manage data export with PowerShell

Video Download
WMV

Length: 12 Minutes 16 seconds

Module 11: Demo 2

In this demonstration you will learn to:

  • Extract the data with the Bulk Copy Program (bcp)
  • Use bcp and Bulk Insert to import data into new tables

Video Download
WMV

Length: 12 Minutes 35 seconds

Module 11: Demo 3

In this demonstration you will learn to:

  • Extract conditional table from one source to multiple destinations

Video Download
WMV

Length: 25 Minutes 34 seconds

Module 11: Demo 4

In this demonstration you will learn to:

  • Move infrequent data transformations with a wizard

Video Download
WMV

Length: 6 Minutes 31 seconds

© 2013 Microsoft