PrepAway - Latest Free Exam Questions & Answers

Tag: bcp utility in sql server

What should you do?

You work as the database administrator at Domain.com. The Domain.com network consists of a single Active Directory domain named Domain.com. All servers on the Domain.com network run Windows Server 2003 and all client computers run Windows XP Professional. The Domain.com network contains a SQL Server 2005 database server named Certkiller -DB01 that hosts a database named CK_Data.
You install a new SQL Server 2005 database server named Certkiller -DB02. You create a new database named CK_Sales on Certkiller -DB02. You must populate the CK_Sales database with data from several tables in the CK_Data database. You want to use the bcp command line utility to export the data to a text file. You want to accomplish this task as quickly as possible.
What should you do?