Microsoft® SQL Server® 2012 Bible

628

Part V: Enterprise Data Management

and from any data source for which a managed .NET Framework data provider or a native

OLE DB provider is available.

You can access the Import and Export Wizard from various locations:

■ Choose Import and Export Data from Start ➪ Programs ➪ Microsoft SQL Server 2012.

■ (^) Open Management Studio, right-click a database and choose Task ➪ Import Data or
Export Data from the context menu.
■ (^) Open SQL Server Data Tools (SSDT) from Start ➪ Programs ➪ Microsoft SQL Server

2012. Open an SSIS solution, select SSIS Import and Export Wizard from the Project
      menu, or right-click the SSIS Packages folder.
      ■ Run DTSWizard.exe (C:\Program Files\Microsoft SQL Server\110\DTS\Binn) from
      the command prompt.

To move data with the Import and Export Wizard, follow these steps:

1. Launch the Import and Export Wizard using one of the preceding methods.


2. Skip past the Welcome to SQL Server Import and Export Wizard by clicking Next.


3. On the Choose a Data Source screen, select the source data. If you launch the
   wizard from Management Studio by right-clicking the database and choose
   Task ➪ Export Data, the source information is already preconfi gured with the server
   and database name. Based on the source data, the other options on this screen can
   vary. For example, selecting SQL Server Native Client 11.0 enables you to specify
   the SQL Server, authentication, and database.


4. On the Choose a Destination screen, select the destination source. If you launch
   the wizard from Management Studio by right-clicking the database and choosing
   Task ➪ Import Data, the destination information is already preconfi gured with the
   server and database name. This screen also enables you to create a new destination
   database by clicking the New option.


5. Specify Table or Query page enable you to either copy all the data from existing
   source tables or views or write a T-SQL query to limit the data to copy.


6. On the Select Source Tables and Views screen, select all the tables and views you
   want to copy. If you opted to write a query on the previous screen, you can
   just select the query on this screen. Click Preview to preview up to 100 rows of
   source data. Click Edit Mappings to change the destination column names, data
   types, nullability, and size, as shown in Figure 23-9. If the destination table

c23.indd 628c23.indd 628 7/31/2012 9:25:22 AM7/31/2012 9:25:22 AM

http://www.it-ebooks.info