SQL Server 7.0 Upgrade and Migration
(Microsoft Training Course: 1131) - 3 days - £1700 exc VAT

THIS COURSE HAS NOW RETIRED. PLEASE SEE THE SUPPLEMENTARY INFORMATION FOR DETAILS OF ALTERNATIVE COURSES.
This course is intended for database administrators and system engineers with experience working with Microsoft SQL Server 6.x, who are responsible for upgrading an installation or migrating data to Microsoft SQL Server 7.0.

1. Introduction to Microsoft SQL Server 7.0
2. Changes to the SQL Server Architecture
3. Changes to Administrative Functions
4. Changes to Transact-SQL
5. New SQL Server Components
6. Upgrading to SQL Server 7.0
7. Migrating Databases to SQL Server

---

Supplementary Information This course has now retired and is no longer available. We suggest you look at Courses 2780: Maintaining a Microsoft SQL Server 2005 Database and 6231: Maintaining a Microsoft SQL Server 2008 Database.

---

Module 1: Introduction to Microsoft SQL Server 7.0

• Why SQL Server Changed
• Increased performance
• More efficient storage engine
• Componentization of architecture
• Windows NT 5.0 Integration
• Reduced cost of ownership
• Dynamic resource management
• Improved Management tools
• Multi-site administration
• Improved scalability
• Very large database support
• Microsoft Access 2000 integration
• Microsoft Windows 95/98 support
• Improve data warehousing capabilities
• Built in Data Transformation Services
• Built in OLAP Server
• Graphical query processing
• English Query support
• Microsoft Repository
• SQL Server 7.0 Installation Changes
• New hardware and software requirements
• Improved SQL Server installation options
• Easier SQL Server Setup
• SQL Server Enterprise Manager

top

---

Module 2: Changes to the SQL Server Architecture

• Security Architecture
• Simpler Authentication Modes
• Easier login account creation
• Fixed Server Roles
• User-defined Roles
• Application Roles
• Simplified object ownership
• Introduction to Course Databases
• Northwind
• Credit
• Storage Architecture
• Database changes
• sp_dboption changes
• Moving databases between servers
• New Page, Extent, and Table structures
• Improved Transaction Log
• Files and Filegroups support
• Unicode Support
• Data types
• Changes to Char, VarChar, Binary, Bit, Text, Image, Numeric, Decimal datatypes
• Better Ansi Null options
• New Unicode data types
• Support for GUIDs with UniqueIdentifier
• Excellent Cursor support
• New Index architecture
• Query Processing
• Graphical Query Processing
• Read-ahead processing
• Ad hoc query caching
• Stored procedure processing
• Processing Strategies
• Sort operations
• Join and group operations
• Parallel queries
• Index processing
• Statistics management
• Full-text search
• Lock Management
• Comparing Transaction Isolation levels
• Row level locking
• Memory Management

top

---

Module 3: Changes to Administrative Functions

• Backup and Restore
• Who performs backups
• Where to store backups
• Multiple backup files
• Dynamic backup process
• Differential backup
• File and Filegroup backups
• Restore process
• Restoring from a differential backup
• Restoring from a file or Filegroup backup
• Restoring damaged system databases
• Automation
• Jobs and Job steps
• Performance Condition Alerts
• SQLMail and SQL Server Agent
• Mail Sessions
• Database Maintenance Wizard
• Replication
• Immediately Updating Subscribers
• Merge Replication
• Monitoring and Tuning
• DBCC
• Processing
• Commands
• Index Tuning Wizard
• Profiler
• Ad-hoc Performance Monitor Counters

top

---

Module 4: Changes to Transact-SQL

• New Keywords
• Commands
• Syntax
• Options
• Changes for ANSI Compliance
• Information Schema Views
• ANSI Keywords
• CAST
• COMMIT/ROLLBACK WORK
• PRIVILEGES
• ODBC ANSI Settings
• NULL
• QUOTED IDENTIFIERS
• Changes to Objects
• New object-information functions
• Referencing local and remoteObjects
• Identifiers
• Object Ownership
• Changing Object Owners
• Tables
• Columns
• Indexes
• Views and Stored Procedures
• Triggers
• Cursors
• Distributed Queries
• Linking to a remote data source
• Setting Up Linked Server Security
• Getting information about linked servers
• Changing a data source from a remote server to a linked server
• Ad hoc queries
• Linked server queries

top

---

Module 5: New SQL Server Components

• Data Transformation Services (DTS)
• DTS Overview
• DTS Processes
• DTS Tools
• Transferring Data with DTS
• Restructuring and Mapping Data
• Defining Transformation Steps
• Defining Workflow
• Creating a DTS Package
• Executing and Scheduling a DTS Package
• Full-text search
• Installing full-text search
• Creating a full-text index
• Using full-text search
• English Query
• Installing English Query
• Identifying Query Terms
• Using English Query
• OLAP Server
• Introduction to OLAP Server
• Installing OLAP Server

top

---

Module 6: Upgrading to SQL Server 7.0

• Steps in Upgrading
• Version Upgrade Wizard
• Considerations when upgrading TempDb: size and location
• Upgrading SQL Server Enterprise Edition
• Installing on dual-boot computers
• Loading a 6.5 database
• Running multiple instances of SQL Server
• Expected upgrade issues
• Troubleshooting an Upgraded Database
• Specifying a Database Compatibility Level
• Unattended Upgrades
• Customizing Upgrades
• Considerations in Upgrading an Application to SQL Server 7.0

top

---

Module 7: Migrating Databases to SQL Server

• Migrating an Access Database to SQL Server
• Considerations when Migrating
• Migration Process
• Migrating a non-Microsoft relational database to SQL Server
• Oracle & Sybase & Informix

top

---

This course requires that students meet the following prerequisites:

• Course 867, System Administration for Microsoft SQL Server 6.5, or working knowledge of setting up security, creating devices and databases, backup and recovery, and the import and export of data using the bulk copy utility.
• Course 750, Implementing a Database Design on Microsoft SQL Server 6.5, or working knowledge of creating indexes, managing locking, retrieving data, and creating views, stored procedures, and triggers.
• Course 689, Supporting Microsoft Windows NT Server 4.0—Enterprise Technologies, or equivalent knowledge.
• Minimum of one year of experience with SQL Server 6.5.
• Experience using SQL Server Enterprise Manager, ISQL/w, and isql

At the end of this course, the student will be able to install Microsoft SQL Server 7.0; use the new and changed features of SQL Server 7.0; upgrade an existing SQL Server 6.x installation to version 7.0; migrate data and databases from various data sources to SQL Server 7.0.

This course has now retired and is no longer available. We suggest you look at Courses 2780: Maintaining a Microsoft SQL Server 2005 Database and 6231: Maintaining a Microsoft SQL Server 2008 Database.