O'Reilly logo

Designing SQL Server 2000 Databases by Syngress

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Chapter 9

Importing and Exporting Data

Solutions in this chapter:

 Overview of Data Import and Export Tools

 Data Transformation Services

 Creating and Editing DTS Packages

 Executing DTS Packages

 The Bulk Copy Program

 SQL-DMO BulkCopy

 The BULK INSERT Command

 Choosing a Data Import and Export Method

Introduction

Transferring and manipulating data was once the job of trained database administrators. With data the driving factor in markets that require reaction time in terms of minutes, having the information available to analyze is the key to making informed and accurate decisions for your organization. Getting data in and out of SQL Server is a common task, and several tools are available in SQL Server 2000 to accomplish this task. Whether it’s ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required