
	Home > Ask the SQL Server Experts > Archive: SQL Server 2005 Questions & Answers > SQL Server 2005 upgrade issues

Ask The SQL Server Expert: Questions & Answers

EMAIL THIS

SQL Server 2005 upgrade issues

EXPERT RESPONSE FROM: Adam Machanic

		Pose a Question

		Other SQL Server Categories

		Meet all SQL Server Experts
		Become an Expert for this site

Digg This!

StumbleUpon

Del.icio.us

QUESTION POSED ON: 01 June 2006
What possible problems are faced when migrating from SQL Server 2000 to SQL Server 2005? What are all the precautions that should be taken during migration?

Digg This!

StumbleUpon

Del.icio.us

RELATED CONTENT

	Microsoft SQL Server 2005
	End of life comes for SQL Server 2005 SP2, 2008
	SQL Server Reporting Services Fast Guide
	SQL Server Service Broker Tutorial and Reference Guide
	Tips for tuning SQL Server 2005 to improve reporting performance
	SQL Server consolidation: Why it's an optimization technique
	Parent-child dimensions in SQL Server 2005 with Analysis Services MDX
	Enforcing data integrity in a SQL Server database
	SSIS error message due to installation problem on SQL Server 2005
	Should you upgrade to SQL Server 2005 or SQL Server 2008?
	Basics for working with DATETIME and SMALLDATETIME in SQL Server 2005
	Microsoft SQL Server 2005 Research

SQL Server Migration Strategies and Planning

New SQL Server 2008 R2 CTP set for November

PASS Summit 2009 Preview

Are data warehouses made for the cloud?

Q&A: Moving forward with SQL Server in the cloud

SQL Server Mailbag: Migrating down to Standard Edition

Microsoft releases SQL Server 2008 R2 CTP

A first look at Microsoft SQL Server 2008 R2

Using Microsoft Hyper-V for SQL Server consolidation

Migrating to SQL Server 2008 and leveraging new features

The challenges of SQL Server consolidation

Archive: SQL Server 2005

Stored procedure concurrency problems in SQL Server 2005

SQL vs. T-SQL

Database Snapshots: Creating read-only copies of a database

Upgrading SQL Servers

Determining number of servers needed for large member site

SQL Server 2005 Enterprise Edition vs. Standard Edition

Encryption failures when upgrading to SQL Server 2005

Upgrading to SQL Server 2005 while maintaining .adp access

Modifying a query to show navigation path

Viewing SQL Server 2005 data via Windows Forms

RELATED GLOSSARY TERMS

Terms from Whatis.com − the technology online dictionary

application server (SearchSQLServer.com)

Yukon (SearchSQLServer.com)

RELATED RESOURCES

2020software.com, trial software downloads for accounting software, ERP software, CRM software and business software systems

Search Bitpipe.com for the latest white papers and business webcasts

Whatis.com, the online computer dictionary

There are many issues that you can run into when doing a migration – and it would be far too difficult to explain them all in this space. Luckily, Microsoft has released a tool to help with the transition. You can read all about the upgrading in my article Reduce upgrade unknowns with the SQL Server 2005 Upgrade Advisor.

For more information on migration, I invite you to listen to my webcast Upgrading to SQL Server 2005: What you must know where I share many tips to help ensure a smooth changeover to the new version.

Search and Browse the Expert Answer Center
Search and browse more than 25,000 question and answer pairs from more than 250 TechTarget industry experts.

Browse our Expert Advice
Operating Systems IT Management Networking Database	Security Servers and Storage Applications and Development Career Center

SQL Solutions - SQL Database Design

SEARCH

TechTarget provides technology professionals with the information they need to perform their jobs - from developing strategy, to making cost-effective purchase decisions and managing their organizations' technology projects - with its network of technology-specific websites, events and online magazines.


TechTarget Corporate Web Site \| Media Kits \| Site Map All Rights Reserved, Copyright 2005 - 2009, TechTarget \| Read our Privacy Policy