Performing a Side-by-Side Upgrade of a Microsoft SQL Server 2000 Relational Database Environment to Microsoft SQL Server 2005 (5336)


Description:

In this two-hour online course, you will learn how to perfom a Side-By-Side upgrade of a SQL Server 2000 database. Topics covered include migrating databases using the Backup and Restore method as well as migrating databases using the Copy Database Wizard. These courses are for database administrators that are responsible for installing SQL Server 2005 within environments that have existing SQL Server 2000 installations.

Student prerequisites:

This course requires that students meet the following prerequisites:

  • Have thorough experience with SQL Server 2000 including the knowledge and skills to manage and maintain a SQL Server 2000 database solution.
  • Be familiar with SQL Server 2005 features, tools, and technologies and have a comprehensive understanding of all its new features and technologies including:
    • The relational engine
    • Storage engine
    • Integration Services
    • Analysis Services
    • Reporting Services

Objectives:

  • Perform a side-by-side upgrade of a SQL Server 2000 relational database environment to SQL Server 2005.
  • Migrate databases from a SQL Server 2000 relational database environment to SQL Server 2005 by using the Backup and Restore method.
  • Migrate databases from a SQL Server 2000 relational database environment to SQL Server 2005 by using the Copy Database Wizard.



User Reviews

Not yet rated. You will need to follow this course before you can write a review.

Course Info

  • Code: EL-PSSUMSQLS2005
  • Duration: 2 hours
  • Price: Call for price

Next Step

Enquire Now
Tell a Friend