Page 198 - DCAP508_DATABASE_ADMINISTRATION
P. 198
Database Administration
Notes 15. Click the Edit button in the Mapping column for the HumanResources.Department table.
16. The Column Mappings dialog box lets you change the name, data type, and other properties
of the destination table columns. You can also set other options here, such as whether to
overwrite or append data when importing data to an existing table. Click Cancel when
you’re done inspecting the options.
17. Click Next.
18. Check Execute Immediately and click Next.
19. Click Finish to perform the import. SQL Server will display progress as it performs the
import, as shown in Figure 14.2.
Figure 14.2
20. Click Close to dismiss the report.
21. Expand the Tables node of the Chapter16 database to verify that the import succeeded.
Notes In addition to executing its operations immediately, the Import and Export Wizard
can also save a package for later execution.
192 LOVELY PROFESSIONAL UNIVERSITY
