You are designing a plan to migrate Microsoft SQL Server 2008 databases to SQL Azure.
You do not plan to migrate the SQL Server databases to SQL Server 2008 R2.
You need to recommend an approach for performing bulk data transfers from the SQL Server databases to SQL Azure.
What should you recommend?
A.
Use the bcp utility.
B.
Use the dta utility.
C.
Use the SQL Server Import and Export Wizard.
D.
Attach each SQL Server database to SQL Azure.
Explanation:
The bcp utility bulk copies data between an instance of Microsoft SQL Server and a data file in a user-specified format. The bcp utility can be used to import large numbers of new rows into SQL Server tables or to export data out of tables into data files. Except when used with the queryout option, the utility requires no knowledge of Transact-SQL. To import data into a table, you must either use a format file created for that table or understand the structure of the table and the types of data that are valid for its columns.