How to Import and Export Data in SQL Server

Artemakis Artemiou, Senior SQL Server & Software Architect

Play Speed
  • 0.5x
  • 1x (Normal)
  • 1.25x
  • 1.5x
  • 2x
9 Lessons (49m)
    • 1. Welcome to the Course!

      2:43
    • 2. Create the Sample Database

      3:41
    • 3. Using the Import Flat File Wizard in SSMS

      4:49
    • 4. Using the BULK INSERT T-SQL Statement

      4:46
    • 5. Using the OPENROWSET Function

      4:08
    • 6. Using the SQL Server Import and Export Wizard

      10:09
    • 7. Using the BCP Utility

      5:28
    • 8. Using SQL Server Integration Services (SSIS)

      12:01
    • 9. What we’ve Learned in this Course

      0:48

About This Class

SQL Server is one of the world's leading data platforms. It allows you to store, organize and retrieve data, as well as transform raw data into useful knowledge. One of the major functions that every database developer and administrator need to know, is how to import and export data in SQL Server.

This class is all about how you can import and export data in SQL Server. It discusses and demonstrates all the built-in SQL Server tools, which can be used for efficiently performing data import and export operations in SQL Server.

More analytically, the class consists of the below sections/lectures:

Introduction

  • Welcome to the Course!

Sample Database with Data

  • Create the Sample Database

Data Import and Export Methods and Built-in Tools

  • Using the Import Flat File Wizard in SSMS
  • Using the BULK INSERT T-SQL Statement
  • Using the OPENROWSET Function
  • Using the SQL Server Import and Export Wizard
  • Using the BCP Utility
  • Using SQL Server Integration Services (SSIS)

Wrap-Up

  • What we’ve Learned in this Course