Solved

migrating sql server 2000/2005 to 2008

Posted on 2011-02-25
1
313 Views
Last Modified: 2012-08-14
This question is of a general nature; we are in  the process of migrating sql 2005 {which is running in compatibility mode with 2000} to sql server 2008 clustered environment.

2 paths have been proposed:
1)migrate to 2008 and continue to run in 2000 + 2005 compatibility mode - is this even possible since a lot of features have been deprecated in 2008.

2)migrate to 2008 - how does one identify deprecated code - is there any literature I can refer to on best practises etc.

thanks.
0
Comment
Question by:sanagarwl
1 Comment
 
LVL 17

Accepted Solution

by:
dbaSQL earned 500 total points
ID: 34979672
I would take a look at the upgrade advisor:
http://www.microsoft.com/downloads/en/details.aspx?FamilyID=f5a6c5e9-4cd9-4e42-a21c-7291e7f0f852&displaylang=en
http://msdn.microsoft.com/en-us/library/ms144256.aspx

It will give you a good assessment of your current build, and any issues that may arise during your upgrade.

Also, see this on the deprecated features:
http://msdn.microsoft.com/en-us/library/ms143729.aspx
0

Featured Post

Webinar: Aligning, Automating, Winning

Join Dan Russo, Senior Manager of Operations Intelligence, for an in-depth discussion on how Dealertrack, leading provider of integrated digital solutions for the automotive industry, transformed their DevOps processes to increase collaboration and move with greater velocity.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

"Disruption" is the most feared word for C-level executives these days. They agonize over their industry being disturbed by another player - most likely by startups.
In this article we will learn how to fix  “Cannot install SQL Server 2014 Service Pack 2: Unable to install windows installer msi file” error ?
Familiarize people with the process of utilizing SQL Server functions from within Microsoft Access. Microsoft Access is a very powerful client/server development tool. One of the SQL Server objects that you can interact with from within Microsoft Ac…
Via a live example, show how to setup several different housekeeping processes for a SQL Server.

685 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question