Solved

migrating sql server 2000/2005 to 2008

Posted on 2011-02-25
1
309 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

Control application downtime with dependency maps

Visualize the interdependencies between application components better with Applications Manager's automated application discovery and dependency mapping feature. Resolve performance issues faster by quickly isolating problematic components.

Question has a verified solution.

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

Read about achieving the basic levels of HRIS security in the workplace.
Messaging apps are amazing tools with the power to do a lot of good, but the truth is the process of collaborating with coworkers requires relationships established through meaningful communication - the kind of communication that only happens face-…
Familiarize people with the process of retrieving data from SQL Server using an Access pass-thru query. Microsoft Access is a very powerful client/server development tool. One of the ways that you can retrieve data from a SQL Server is by using a pa…
This video shows how to set up a shell script to accept a positional parameter when called, pass that to a SQL script, accept the output from the statement back and then manipulate it in the Shell.

911 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

Need Help in Real-Time?

Connect with top rated Experts

17 Experts available now in Live!

Get 1:1 Help Now