Skip to main content

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

Microsoft is conducting an online survey to understand your opinion of the MSDN Web site. If you choose to participate, the online survey will be presented to you when you leave the MSDN Web site.

Would you like to participate?