Home
Topics
Microsoft SQL Server Platforms
Microsoft SQL Server 2005
Step 2: SQL Server 2005 upgrade prerequisites

Step 2: SQL Server 2005 upgrade prerequisites

With a clear understanding of your upgrade needs, you can jump into the technical steps to complete the migration.

Determine your product version upgrade path.
- See "Version and Edition Upgrades" in SQL Server 2005 Books Online

Verify that your SQL Server 2005 environment meets hardware and software requirements.
- See

Requires Free Membership to View

Login

By submitting you agree to receive email communications from
TechTarget and its partners. Privacy Policy Terms of Use.

- Hardware and Software Requirements for Installing SQL Server 2005

Ensure that your SQL Server 2005 environment is capable of supporting future needs from a user and transaction perspective.
- Review your legacy SQL Server configurations and objects using SQL Server 2005 Upgrade Advisor to determine potential issues prior to the upgrade. This Microsoft tool is valuable to understanding issues in the environment.
- See Using Upgrade Advisor to Prepare for Upgrades and the SearchSQLServer.com tip Reduce upgrade unknowns with SQL Server 2005 Upgrade Advisor

Set up an environment to test the migration process as well as front-end applications and dependent (upstream and downstream) systems' functionality.
- Take a holistic view of the environment to ensure you don't overlook any applications because the components that are overlooked become issues during the process.

Migrating to SQL Server 2005

Home: Introduction
Step 1: What to upgrade
Step 2: Upgrade prerequisites
Step 3: Migration options
Step 4: Additional considerations

ABOUT THE AUTHOR:
Jeremy Kadlec is the Principal Database Engineer at Edgewood Solutions, a technology services company delivering professional services and product solutions for Microsoft SQL Server. He has authored numerous articles and delivers frequent presentations at regional SQL Server Users Groups and nationally at SQL PASS. Jeremy is also SearchSQLServer.com's Performance Tuning expert.

More information from SearchSQLServer.com

Tip: Reduce upgrade unknowns with SQL Server 2005 Upgrade Advisor
Learning Guide: SQL Server 2005 Learning Guide
Book Excerpts: SQL Server 2005 Management Studio

More News and Tutorials

Articles

Related glossary terms

Terms for Whatis.com - the technology online dictionary
- Yukon

This was first published in March 2006

Join the conversationComment

Share

Comments

Results

Contribute to the conversation

All fields are required. Comments will appear at the bottom of the article.

More from Related TechTarget Sites

Business Analytics
Data Center
Data Management
Data Management UK
Oracle
Content Management
Windows Server

Business Analytics
- Tagged.com solves data quality problems on road to better analysis
  
  For Tagged.com, a data quality project led the company to realize excellent data means more than having the correct information.
- TechTarget's IT Salary Survey Results 2012
  
  TechTarget’s latest salary statistics show average pay raises and salary rates for the most frequently found roles in IT organizations.
- Real-time data analysis recipe calls for mix of IT, business savvy
  
  Business intelligence teams, IT managers and business executives need to come together to make real-time analytics initiatives effective.
Data Center
- Clearing up questions about 64-bit ARM processors
  
  Emerging 64-bit ARM processors are headed to the data center and may enable a new wave of scalable, energy-efficient enterprise-class computing.
- Modern server room design to fit your business needs
  
  Server room design has changed. So when planning one for an existing facility, make sure it meets current and future needs.
- Cloud storage and Storage as a Service to gain popularity in 2013
  
  A 2013 TechTarget survey reveals steady growth in cloud storage, while more IT pros look for savings in Storage as a Service.
Data Management
- Quiz: Data warehouse performance issues
  
  After you view and listen to the content in our data warehouse performance classroom, take this short quiz to test your knowledge of the topic.
- TechTarget's IT Salary Survey Results 2012
  
  TechTarget’s latest salary statistics show average pay raises and salary rates for the most frequently found roles in IT organizations.
- VoltDB's 'new SQL' database ups velocity for big data apps
  
  Data pioneer Mike Stonebraker's latest take on transactional processing is a "new SQL" database. This week it adds hooks for fast data ingestion.
DataManagement UK
- Big data roundtable webcast: gaining value from big data
  
  Roundtable discussion on business value of big data, chaired by Brian McKenna, Editor, SearchDataManagementUK, and featuring Mike Ferguson, Roxane Edjlali (Gartner), Joshua LeCure (GlaxoSmithKline).
- 2012 training courses: BI, data management, data warehousing
  
  Find out where to hone your business intelligence, data management and data warehouse skills with this list of training courses for 2012.
- Poor data quality: what is dirty data costing UK organisations?
  
  Poor data quality can have serious financial consequences for businesses. Read about the current state of data quality management at UK companies, including dirty data problems.
Oracle
- Three important facets of Oracle Hyperion project implementation
  
  When implementing an Oracle Hyperion project, a company must be aware of technical, management and roadmap issues.
- Oracle PaaS products due out in first half of this year
  
  Oracle PaaS products for storage, messaging and virtual compute are expected to be generally available by the end of June.
- TechTarget's IT Salary Survey Results 2012
  
  TechTarget’s latest salary statistics show average pay raises and salary rates for the most frequently found roles in IT organizations.
Content Management
- Insiders talk up Yammer integration with SharePoint content management
  
  Two Microsoft executives discuss Yammer's integrating with SharePoint content management and Microsoft's developing its social, cloud and mobile apps.
- SharePoint 2013 search, metadata-driven navigation simplify structure
  
  SharePoint expert Shawn Shell explains the metadata-driven navigation features of SharePoint 2013 search and how SharePoint users can benefit.
- Plan carefully now to avoid SharePoint deployment frustration later
  
  SharePoint users and experts agree: Don't sideline planning, or you'll be in for a bumpy deployment.
Windows Server
- How can I use Powershell remoting to pass info to remote computers?
  
  When you have to locally execute something and share it with one or more remote machines, PowerShell remoting has a specific way to do it. Here's how.
- FAQ: Three questions on Hyper-V 3.0 features in Windows Server 2012
  
  Administrators can improve VM automation, storage performance and data protection by using the new Hyper-V 3.0 features in Windows Server 2012.
- System Center 2012 SP1 hits general availability with monitoring tool
  
  Users of System Center now can manage Windows Server 2012 with System Center 2012 SP1. The service pack has virtualization enhancements and more.

All Rights Reserved,Copyright 2005 - 2013, TechTarget