Project Plan

Migrating to SQL Server 2008 & 2008 R2


Congratulations on making the decision to migrate to SQL Server 2008 or 2008 R2! The SQL Server 2008 & 2008 R2 Migration Project Plan will assist you every step of the way through the process via hands on, how-to articles and videos. Migrating to SQL Server 2008 or 2008 R2 requires a good amount of planning, from choosing the right SQL Server license for your needs to installing the required hardware and software before you migrate. After you’ve planned out your SQL Server 2008 or 2008 R2 environment, you’re ready to migrate.

This SQL Server Pro Project Plan will walk you through the process of the actual migration from previous versions of SQL Server, such as SQL Server 2000, and other database offerings such as Microsoft Access. When your migration is complete, you’ll want to take your database environment to the next level by implementing SQL Server2008 or 2008 R2’s new features, such as new data types, encryption, and PowerPivot for Excel 2010. Our expert content will show you how to implement SQL Server 2008 or 2008 R2’s administration, development, and business intelligence features in your environment.

Not finding what you're looking for? Email our editors, and let us know how we can help.

Planning


SQL Server 2008 R2 Requirements
by Michael Otey

SQL Server Version Build Numbers
by Michael Otey

SQL Server 2008 R2 New Features
by Michael Otey

Details

Migrating


Upgrading to SQL Server 2008 R2
by Michael Otey

Migrating to SQL Server 2008
by Michael Otey

How to Upgrade to SQL Server 2008
from SQL Server 2000

by Orin Thomas

Tools for Migrating Access to SQL Server
by Michael Otey

SQL Server 2008 - Episode 8: How Do I Upgrade
by Randy Dyess

Details

Fine Tune Your Migration


Database Administration

Top 10 SQL Server Performance Tuning Tips
by Andrew J. Kelly

Configuring SQL Server 2008’s Resource Governor
by Greg Low

Set Up a SQL Server 2008 Cluster
by Denny Cherry

Upgrading a SQL Server 2005 Cluster to a SQL Server 2008
by Denny Cherry

Compression in SQL Server 2008
by Orin Thomas

An Overview of SQL Server High Availability Options
by Michael Otey

3 Log Shipping Techniques
by Robert Davis

Efficient Data Management in SQL Server 2008, Part 1
by Don Kiely

Efficient Data Management in SQL Server 2008, Part 2
by Don Kiely

Build a Policy-Based Management System for SQL Server 2008
by Brent Ozar

Synchronizing Disparate Data with Master Data Services
by Denny Cherry

Introducing the SQL Server Utility
by Ross Mistry

Tips for Using SQL Server Management Studio 2008
by Michael Otey

SQL Server 2008 - Episode 2: Under the Hood
by Randy Dyess

SQL Server 2008 - Episode 5: Knowing Your Data
by Randy Dyess

SQL Server 2008 - Episode 6: 64 Bit and You
by Randy Dyess

SQL Server 2008 - Episode 7: Ready for your Environment
by Randy Dyess

SQL Server 2008 R2: Enterprise Data Access for Mission-Critical
Applications

by Michael Otey

Details

Backup and Recovery

Database Mirroring in SQL Server 2008 R2 and SQL Server 2008
by Richard Waymire

Advanced BACKUP and RESTORE Options
by Paul Randal

Step-by-Step Approach to Differential Backup and Recovery
by Chris Burns

Details

Security and Auditing

Hardening SQL Server
by Robert Davis

SQL Server 2008 Boosts Built-in Encryption
by Randy Dyess

SQL Server Ecryption
by Basit Aalishan Masood-al-farooq

SQL Server 2008 - Episode 1: How Can I Secure Data
by Randy Dyess

SQL Server 2008 - Episode 3: Protecting Your Data
by Randy Dyess

Details

Virtualization

Optimizing SQL Server Performance in a Virtual Environment
by Denham Cherry

7 Best Practices for Running SQL Server on Hyper-V
by Michael Otey

Details

T-SQL

Upgrading Clusters to SQL Server 2012 When AlwaysOn Availability Groups Will Be Used
by Denny Cherry

Planning and Implementing a SQL Server Cluster
by Denny Cherry

More SQL Server 2008 T-SQL Improvements
by Itzik Ben-Gan

SQL Server 2008’s T-SQL Development and Debugging Features
by Michael Otey

Parallelism Enhancements in SQL Server 2008
by Itzik Ben-Gan

Date and Time Support in SQL Server 2008
by Itzik Ben-Gan

Using SQL Server 2008 FILESTREAM Storage
by Michael K. Campbell

Using SQL Server 2008's FILESTREAM Data Type
by Michael Otey

Simplifying Spatial Data
by Kurt Survance

SQL Server 2008 - Episode 4: What About Developers
by Randy Dyess

Details

Business Intelligence

Introducing PowerPivot for SharePoint
by Tyler Chessman

SQL Server 2008 Change Data Capture
by Derek Comingore

Details

SharePoint and SQL Server Integration

5 Considerations for Setting up a SQL Server 2008 Backend for SharePoint 2010
by Brian Reinholz

SSRS 2008 R2 and SharePoint 2010 Integration
by Stacia Misner

Details

PowerPivot and Excel

How to Create PowerPivot Applications in Excel 2010
by Derek Comingore

A Walkthrough of PowerPivot for Excel 2010
by Tyler Chessman

Integrating SQL Server 2008 Spatial Capabilities with Microsoft Virtual Earth
by Tyler Chessman

Managed Self-Service BI
by Stacia Misner

Details

SQL Server Reporting Services

Unlock the Secrets of SQL Server 2008 Reporting Services
by William Vaughn

A Candid Look at Report Builder 3.0
by William Vaughn

Details

SQL Server Integration Services

Use Checkpoints to Restart Failed SSIS Packages
by Stacia Misner

SSIS Novices’ Guide to Data Warehouses: Moving Data into the Data Warehouse
by Kristl Smith Tyler

Details

SQL Server Analysis Services

Backup Basics for SQL Server Analysis Services
by Tyler Chessman

Details

Migrating to SQL Server 2008 & 2008 R2 Project Plan

<<< Back to the Project Plan


Planning


SQL Server 2008 R2 Requirements

SQL Server Version Build Numbers

SQL Server 2008 R2 New Features

Migrating


Upgrading to SQL Server 2008 R2

Migrating to SQL Server 2008

How to Upgrade to SQL Server 2008 from SQL Server 2000

Tools for Migrating Access to SQL Server

SQL Server 2008 - Episode 8: How Do I Upgrade

Fine Tune Your Migration


Database Administration

Top 10 SQL Server Performance Tuning Tips

Configuring SQL Server 2008’s Resource Governor

Set Up a SQL Server 2008 Cluster

Upgrading a SQL Server 2005 Cluster to a SQL Server 2008

Compression in SQL Server 2008

An Overview of SQL Server High Availability Options

3 Log Shipping Techniques

Efficient Data Management in SQL Server 2008, Part 1

Efficient Data Management in SQL Server 2008, Part 2

Build a Policy-Based Management System for SQL Server 2008

Synchronizing Disparate Data with Master Data Services

Introducing the SQL Server Utility

Tips for Using SQL Server Management Studio 2008

SQL Server 2008 - Episode 2: Under the Hood

SQL Server 2008 - Episode 5: Knowing Your Data

SQL Server 2008 - Episode 6: 64 Bit and You

SQL Server 2008 - Episode 7: Ready for your Environment

SQL Server 2008 R2: Enterprise Data Access for Mission-Critical Applications

Backup and Recovery

Database Mirroring in SQL Server 2008 R2 and SQL Server 2008

Advanced BACKUP and RESTORE Options

Step-by-Step Approach to Differential Backup and Recovery

Security and Auditing

Hardening SQL Server

SQL Server 2008 Boosts Built-in Encryption

SQL Server Ecryption

SQL Server 2008 - Episode 1: How Can I Secure Data

SQL Server 2008 - Episode 3: Protecting Your Data

Virtualization

Optimizing SQL Server Performance in a Virtual Environment

7 Best Practices for Running SQL Server on Hyper-V

T-SQL

Upgrading Clusters to SQL Server 2012 When AlwaysOn Availability Groups Will Be Used

Planning and Implementing a SQL Server Cluster

More SQL Server 2008 T-SQL Improvements

SQL Server 2008’s T-SQL Development and Debugging Features

Parallelism Enhancements in SQL Server 2008

Date and Time Support in SQL Server 2008

Using SQL Server 2008 FILESTREAM Storage

Using SQL Server 2008's FILESTREAM Data Type

Simplifying Spatial Data

SQL Server 2008 - Episode 4: What About Developers

Business Intelligence

Introducing PowerPivot for SharePoint

SQL Server 2008 Change Data Capture

SharePoint and SQL Server Integration

5 Considerations for Setting up a SQL Server 2008 Backend for SharePoint 2010

SSRS 2008 R2 and SharePoint 2010 Integration

PowerPivot and Excel

How to Create PowerPivot Applications in Excel 2010

A Walkthrough of PowerPivot for Excel 2010

A Walkthrough of PowerPivot for Excel 2010

Integrating SQL Server 2008 Spatial Capabilities with Microsoft Virtual Earth

Managed Self-Service BI

SQL Server Reporting Services

Unlock the Secrets of SQL Server 2008 Reporting Services

A Candid Look at Report Builder 3.0

SQL Server Reporting Services

Use Checkpoints to Restart Failed SSIS Packages

SSIS Novices’ Guide to Data Warehouses: Moving Data into the Data Warehouse

SQL Server Reporting Services

Backup Basics for SQL Server Analysis Services

Sponsored Introduction Continue on to (or wait seconds) ×