MCTS 70-431: Implementing and Maintaining Microsoft SQL Server 2005

Chapter 5. Data Consumption and Throughput

Terms you’ll need to understand:

• ✓ bcp command

• ✓ BULK INSERT statement

• ✓ OPENROWSET command

• ✓ Format file

• ✓ SQL Server Integration Services (SSIS)

• ✓ Business Intelligence Development Studio

• ✓ Service Broker

• ✓ Synchronous model

• ✓ Asynchronous model

• ✓ Service Broker queue

• ✓ Service Broker dialogue

• ✓ Service Broker contract

• ✓ Service Broker service

Techniques you’ll need to master:

• ✓ Using BCP to export data to a file

• ✓ Importing data by using a format file (BCP, BULK INSERT, and OPENROWSET)

• ✓ Creating services and contracts by using Service Broker

• ✓ Communicating between applications by using Service Broker

There are many ways to get data into and out of a database. Traditional tools for loading and unloading data with SQL ...