MCSE Microsoft SQL Server 2000 System Administration(c) Training Kit (c) Exam 70-228
3 4
Chapter 7
About This Chapter
This chapter prepares you to populate your database from an existing data source. The chapter begins with a discussion of the data transformation, consistency, and validation issues you will encounter when you import data from one or multiple sources into a SQL Server 2000 database. Next, you are introduced to the primary SQL Server 2000 tools used for populating a database. Finally, you learn how and when to use each of these tools.
Before You Begin
To complete this chapter, you must have
- A computer that meets or exceeds the minimum hardware requirements listed in Table 2.1 in the Lesson 1 section of Chapter 2.
- Microsoft Windows 2000 Server running on your computer on an NTFS partition.
- A computer with a NetBIOS name of SelfPacedCPU, configured as a domain controller in the SelfPacedSQL.MSFT domain.
- Installed a default instance and at least one named instance of SQL Server 2000 (see Chapter 2).