Friday, July 25, 2014
 
  Understanding Data Import & Export

Understanding Data Import and Export

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
  Using Powershell for Import & Export

Using PowerShell for Data Import and Export

In this demonstration you will learn to:

  • Manage data export with PowerShell












  Using BCP and Bulk Insert

Exporting Data Using BCP and Bulk Insert

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










Importing and Exporting Data Using SQL Server 2008

In this module you will learn about tools and functionality in Oracle and their equivalents in SQL Server in data transport out and into the database, and tools and functionality in SQL Server for data transport within SQL Server and across multiple data sources and destinations.
  Conditional Data Transfer

Conditional Data Import and Export

In this demonstration you will learn to:

  • Extract conditional table from one source to multiple destinations
  Using Data Import Export Wizard

Using Data Import Export Wizard

In this demonstration you will learn to:

  • Move infrequent data transformations with a wizard

HOME   |   Article Library   |   Scripts & Tools   |   Training Videos   |   Job Board   |   Resources
Copyright 2010 by SQLCOMMUNITY.COM