Microsoft SQL Server 7.0: Upgrading and Migration

Overview/Description
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

Target Audience
IT professionals including database administrators, application developers, independent software vendors, 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

Expected Duration
4 hours

Objectives:

Microsoft SQL Server 7.0: Upgrading and Migration

  • To describe how to plan and implement an upgrade of a SQL Server 6.5 installation to SQL Server 7.0
  • To show how to upgrade a SQL Server 6.5 installation to SQL Server 7.0
  • To plan a migration from Oracle, Sybase, or Access database system to SQL Server 7.0
  • To explain how to troubleshoot the process of upgrading and migrating to SQL Server 7.0


    • Course Number: SQ7023E