Describe the SQL Server Import and Export Wizard. What are its advantages and limitations?
What will be an ideal response?
The SQL Server Import and Export Wizard provides step-by-step instructions for designing a solution that meets basic data integration needs. The wizard moves data between a source and a destination, albeit with a limited range of data transformation capabilities. The SQL Server Import and Export Wizard enables a database administrator to quickly define a source connection, a destination connection, and the data mappings between the source and the destination. Although its functionality is limited, the wizard is an excellent introduction to Integration Services, and it is useful for quickly setting up an ad hoc process to move data.
You might also like to view...
You use a problem's solution-in other words, its output, processing, and input information and its algorithm-to determine the variables to use when coding an application.
Answer the following statement true (T) or false (F)
In Unix terminology, the difference between a host and a server is
A. a server is process, a host is a computer B. a server is smaller computer, a host supports more users
Parameters need to be enclosed in ________
A) pound signs (#) B) brackets ([]) C) asterisks (*) D) quotation marks (")
A(n) ________ button is a control that runs a VBA macro
Fill in the blank(s) with the appropriate word(s).