Audience

IT professionals including database administrators, application developers, independent software vendors, IS managers, system integrators, and Internet consultants who want to plan, deploy, configure, administer, and troubleshoot SQL Server 7.0

Prerequisites

Experience of configuration and administration of Windows NT, familiarity with the Windows 95 or Windows NT user interface, familiarity with managing end-user accounts in an NT environment, knowledge of SQL or Transact-SQL, and an understanding of the role of a database administrator

Course Aim

To enable students to successfully upgrade SQL Server databases from version 6.x and earlier to version 7.0, and to describe how to migrate data from third-party RDBMS platforms to SQL Server 7.0

Learning Objectives

Explain how to plan an upgrade from SQL Server 6.5 to version 7.0. Describe the various upgrade scenarios and choose the appropriate approach for a particular topology. Show how to perform a side-by-side upgrade from SQL Server 6.5 to SQL Server 7.0. Summarize the required post-upgrade activities. Point out how to plan a migration from Access, Oracle, and Sybase systems to SQL Server 7.0 and identify potential issues and pitfalls. Explain how to troubleshoot common upgrading and migrating problems.

Topics Covered

Planning the upgrade - Preparing to upgrade - Upgrade scenarios - Hands-on: Planning an upgrade scenario Upgrading to SQL Server 7.0 - Upgrade a SQL 6.5 installation - Post-upgrade activities - Hands-on: Upgrading SQL Server 6.5 to 7.0 Migrations - Planning migrations - Migrating from Oracle - Migrating from Sybase - Migrating from Access Troubleshooting - Troubleshooting an upgrade - Troubleshooting migration - Examining an error log

| About Eno.com | Security&Privacy | Contact Us |
Copyright © 1998-2001 E&A Inc.. All rights reserved.