Steps in the SQL Server Import and Export Wizard

APPLIES TO: yesSQL Server, including on Linux yesAzure SQL Database yesAzure Synapse Analytics (SQL DW) noParallel Data Warehouse

This topic describes the sequence of steps for importing and exporting data with the SQL Server Import and Export Wizard. It also contains links to the individual pages of documentation that describe each page or dialog box you see in the wizard.

This topic describes only the steps in the wizard. If you're looking for something else, see Related tasks and content.

Steps for importing and exporting data

The following table lists the steps for importing and exporting data and the corresponding pages of the wizard. Depending on the options that you select in the wizard, you typically don't see all these pages.

For a quick look at the several screens you see in a typical session, take a look at this simple end-to-end example on a single page - Get started with this simple example of the Import and Export Wizard.

Step Wizard pages
Welcome
You don't have to take any action on this page.
Welcome to SQL Server Import and Export Wizard
Pick the source of the data. Choose a Data Source
Pick the destination for the data. Choose a Destination
Configure the destination. (optional steps)

- Create a new destination database.
- If you're copying data to a text file, configure additional settings.
Create Database

Configure Flat File Destination
Specify what you want to copy. Specify Table Copy or Query

Select Source Tables and Views

Provide a Source Query
Configure the copy operation. (optional steps)

- Create a new destination table.
- Decide what to do if the wizard doesn't know how to map data types between the source and destination that you selected.
- Review column mappings between source and destination.
- Handle issues with converting data types between source and destination.
- Preview the data to be copied.
Create Table SQL Statement

Convert Types without Conversion Checking

Column Mappings

Review Data Type Mapping

Column Conversion Details Dialog Box

Preview Data Dialog Box
Copy the data.

Optionally, save your settings as a SQL Server Integration Services (SSIS) package.
Save and Run Package

Save SSIS Package

Complete the Wizard

Performing Operation

Tip

Tap the F1 key from any page or dialog box of the wizard to see documentation for the current page.

Here are some other basic tasks.

  • See a quick example of how the wizard works.

  • Learn more about how the wizard works.

  • Start the wizard. If you're ready to run the wizard and just want to know how to start it, see Start the SQL Server Import and Export Wizard.

  • **Get the wizard.** If you want to run the wizard, but you don't have [!INCLUDE[msCoName](../../includes/msconame-md.md)] [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] installed on your computer, you can install the [!INCLUDE[ssNoVersion](../../includes/ssnoversion-md.md)] Import and Export Wizard  by installing SQL Server Data Tools (SSDT). For more info, see [Download SQL Server Data Tools (SSDT)](https://msdn.microsoft.com/library/mt204009.aspx).