A Small Class Size is the Best Learning Environment*
Only F1 has no more than 6 Delegates in a Class
Everyone has Individual Attention from the Trainer

View Recent History

Course:(8911) Installation and Deployment in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(F1024) What's New in Microsoft CRM 3.0 - Applications - Microsoft Training Courses in London and South West
Course:(2732) Planning Deploying and Managing an Enterprise Project Management Solution - Microsoft Training Courses in London and South West
Course:(2505) Deploying Microsoft Office XP - Microsoft Training Courses in London and South West
indexes/Certification_courses_index.aspx Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(2830) Designing Security for Microsoft Networks - Microsoft Training Courses in London and South West
Course:(80054) Project Managing Microsoft Dynamics CRM Implementations with Microsoft Dynamics Sure Step - Microsoft Training Courses in London and South West
Course:(F1008) Developer Reskilling: Visual FoxPro to Visual Basic - Microsoft Training Courses in London and South West
Course:(F1002) Visual FoxPro 6.0 Enterprise - Microsoft Training Courses in London and South West
Course:(5060) Implementing Windows SharePoint Services 3.0 - Microsoft Training Courses in London and South West
Course:(8529) Microsoft CRM 3.0 Administration - Microsoft Training Courses in London and South West
Course:(2731) Deploying and Managing Microsoft Identity Integration Server (MIIS) 2003 - Microsoft Training Courses in London and South West
Course:(4009) Setting Up Projects for Success Using Microsoft Office Project 2003 - Microsoft Training Courses in London and South West
Course:(8522) Microsoft CRM 3.0 Marketing Automation - Microsoft Training Courses in London and South West
Course:(F1028) Introduction to Microsoft Dynamics CRM 4 for Small and Medium Businesses - Microsoft Training Courses in London and South West
Course:(F1023) What's New in Microsoft CRM 3.0 - Technical - Microsoft Training Courses in London and South West
Course:(1131) SQL Server 7.0 Upgrade and Migration - Microsoft Training Courses in London and South West
Course:(6294) Planning and Managing Windows 7 Desktop Deployments and Environments - Microsoft Training Courses in London and South West
Course:(2093) Implementing Business Logic with MDX in Microsoft SQL Server 2000 - Microsoft Training Courses in London and South West
Exchange Server 2010 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(8526) Microsoft CRM 3.0 Installation and Configuration - Microsoft Training Courses in London and South West
Visual Studio 2008 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(2840) Implementing Security for Applications - Microsoft Training Courses in London and South West
Course:(4005) Beyond the Spreadsheet: Managing Financial Information Using Microsoft Office Access 2003 - Microsoft Training Courses in London and South West
Course:(5061) Implementing Microsoft Office SharePoint Server 2007 - Microsoft Training Courses in London and South West
Course:(80003) Workflow in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Visual Basic .NET Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(5056) First Look: Windows Vista for IT Professionals - Microsoft Training Courses in London and South West
Course:(80002) Administration in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(2015) Enabling Business Processes using XML Smart Documents and Smart Solutions within the Microsoft Office System - Microsoft Training Courses in London and South West
Visual Studio .NET Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(8524) Microsoft CRM 3.0 Service Scheduling - Microsoft Training Courses in London and South West
Application Architecture Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(F1032) Fast Track to Microsoft Dynamics CRM 4.0 Certification: Become a CRM Power User in 3 Days Flat! - Microsoft Training Courses in London and South West
Course:(8912) Customisation and Configuration in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(4002) Forecasting and Trend Analysis Using Microsoft Office Excel 2003 - Microsoft Training Courses in London and South West
Course:(2151) Microsoft Windows 2000 Network and Operating System Essentials - Microsoft Training Courses in London and South West
Windows Server 2008 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(8913) Applications in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(8521) Microsoft CRM 3.0 Sales Management - Microsoft Training Courses in London and South West
Course:(F1033) Fast Track to Microsoft Dynamics CRM 4.0 Certification: Become a CRM Developer in 5 Days Flat! - Microsoft Training Courses in London and South West
Course:(F1004) FoxPro 2.6 Intensive - Microsoft Training Courses in London and South West
Course:(4008) Building Better Microsoft Office Word 2003 Documents in Less Time - Microsoft Training Courses in London and South West
Course:(6064) Planning, Implementing, and Managing Windows Mobile 6 - Microsoft Training Courses in London and South West
Course:(8530) Microsoft CRM 3.0 Data Migration - Microsoft Training Courses in London and South West
Course:(6292) Installing and Configuring Windows 7 Client - Microsoft Training Courses in London and South West
Course:(8525) Microsoft CRM 3.0 Customization - Microsoft Training Courses in London and South West
Course:(6289) First Look: Windows 7 Beta for IT Professionals - Clinic & Hands-on Lab - Microsoft Training Courses in London and South West
Course:(80141) Integrating Microsoft Dynamics CRM 4.0 and Microsoft Office SharePoint Server 2007 - Microsoft Training Courses in London and South West
Course:(6291) Updating Your Technology Knowledge of Microsoft Windows XP to Windows 7 Beta - Microsoft Training Courses in London and South West
Course:(6067) Developing Native Applications for Microsoft Windows Mobile 6 - Microsoft Training Courses in London and South West
Course:(8910) What's New in Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(2810) Fundamentals of Network Security - Microsoft Training Courses in London and South West
Course:(6066) Developing Managed Applications for Microsoft Windows Mobile 6 - Microsoft Training Courses in London and South West
Course:(F1030) Advanced Microsoft Dynamics CRM 4 for Small and Medium Businesses - Microsoft Training Courses in London and South West
Course:(4003) Summarizing Microsoft Office Excel 2003 Data to Make Better Business Decisions - Microsoft Training Courses in London and South West
Visual Studio 2010 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(2439) Scripting Microsoft Windows Management Instrumentation - Microsoft Training Courses in London and South West
Course:(2088) Designing a Highly Available Web Infrastructure (IIS) - Microsoft Training Courses in London and South West
Course:(2381) Planning Collaborative Solutions With Microsoft Office XP Technologies - Microsoft Training Courses in London and South West
Course:(8879) Using the Microsoft Dynamics Sure Step Methodology for Microsoft Dynamics CRM - Microsoft Training Courses in London and South West
Course:(F1034) Fast Track to Microsoft Dynamics CRM 4.0 Certification: Become a CRM Expert in 7 Days Flat! - Microsoft Training Courses in London and South West
Office (inc SharePoint) Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(2657) Programming Microsoft Access 2002 - Microsoft Training Courses in London and South West
Course:(4006) Time and Task Management Using Microsoft Office Outlook 2003 - Microsoft Training Courses in London and South West
Course:(F1037) Customisation of xRM/CRM for Microsoft Partners and Customers - Microsoft Training Courses in London and South West
Application Centre Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(6331) Deploying and Managing Microsoft System Center Virtual Machine Manager - Microsoft Training Courses in London and South West
Visual Basic 6.0 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(7197) Managing Enterprise Desktops Using the Microsoft Desktop Optimization Pack - Microsoft Training Courses in London and South West
Visual Studio 2005 Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(8969) Extending Microsoft Dynamics CRM 4.0 - Microsoft Training Courses in London and South West
Course:(2300) Developing Security-Enhanced Web Applications - Microsoft Training Courses in London and South West
Course:(2016) Bringing Data into Desktop Programs using the Microsoft Office 2003 Editions Research and Reference Technologies - Microsoft Training Courses in London and South West
Course:(F1029) Intermediate Microsoft Dynamics CRM 4 for Small and Medium Businesses - Microsoft Training Courses in London and South West
Course:(6290) First Look: Windows 7 Beta for IT Professionals - Hands-on Lab - Microsoft Training Courses in London and South West
Course:(3373) First Look: Getting Started with Windows SharePoint Services 3.0 Hands-On Lab - Microsoft Training Courses in London and South West
Mobile Internet Toolkit Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(4004) Managing Critical Business Information Using Microsoft Office Access 2003 - Microsoft Training Courses in London and South West
Course:(2052) Using Microsoft Visual Studio Tools for the Microsoft Office System - Microsoft Training Courses in London and South West
Course:(2433) Microsoft Visual Basic Scripting Edition and Microsoft Windows Script Host Essentials - Microsoft Training Courses in London and South West
Course:(8531) Extending Microsoft CRM 3.0 - Microsoft Training Courses in London and South West
Course:(F1001) Visual FoxPro 6.0 Intensive - Microsoft Training Courses in London and South West
Course:(80047) Using Microsoft Dynamics Sure Step - Microsoft Training Courses in London and South West
Course:(F1035) Fast Track to Microsoft Dynamics CRM 4.0 Certification: Become a CRM Guru in 10 Days Flat! - Microsoft Training Courses in London and South West
Course:(3087) First Look: Microsoft Windows Vista for Developers - Microsoft Training Courses in London and South West
Knowledge Management Training Course Index - F1Computing Microsoft Training Courses London South West UK
Microsoft Dynamics CRM Training Course Index - F1Computing Microsoft Training Courses London South West UK
Course:(2018) Creating and Customizing Team Folders - Microsoft Training Courses in London and South West
Visual Studio 6.0 Training Course Index - F1Computing Microsoft Training Courses London South West UK

Compare Recently Viewed Course Dates



Exclusive
SQL Server

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

We currently do not have any dates scheduled for this course.
Please contact us to arrange a closed course for your company or add your details to courses in waiting.
(Remember F1 has smaller classes)
Ask a Question ?Print 2 Page PDF


> Target Audience
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.
> Course outline
  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
> Pre-Requisites
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
> Purpose
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.
> 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.
> EXAMS
There are no exams directly associated with this course