SQL Upgrade 2000 to 2008

Question

SQL Upgrade 2000 to 2008

youngoz

SSC Enthusiast

Points: 102
More actions
March 28, 2010 at 1:16 pm

#386591

Hi Guys
Has anyone done a database upgrade from 2000 to 2008. Im planning to upgrade to 2005 but I was wondering if their many be an issue upgrading to 2008. I like the new intellisense features on 2008. What are the main difference between 2005 & 2008?
What do you guys recommend?

Viewing 14 posts - 1 through 13 (of 13 total)

You must be logged in to reply to this topic. Login to reply

Perry Whittle SSC Guru Points: 233963 More actions · Answer 1

whether upgrading to SQL server 2005 or 2008, immediately after run DBCC UPDATEUSAGE and rebuild all indexes. Also run DBCC CHECKDB with DATA_PURITY to ensure your database(s) have no metadata or performance issues

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

youngoz SSC Enthusiast Points: 102 More actions · Answer 2

Thanks for the Advice. What do you recommend to Upgrade from 2000 to 2005 then 2008 or should I upgrade from2000 to 2008?

Jeffrey Williams SSC Guru Points: 90266 More actions · Answer 3

Perry Whittle (3/28/2010)
whether upgrading to SQL server 2005 or 2008, immediately after run DBCC UPDATEUSAGE and rebuild all indexes. Also run DBCC CHECKDB with DATA_PURITY to ensure your database(s) have no metadata or performance issues

And don't forget to update statistics also.

Jeffrey Williams
“We are all faced with a series of great opportunities brilliantly disguised as impossible situations.”

― Charles R. Swindoll

How to post questions to get better answers faster
Managing Transaction Logs

Perry Whittle SSC Guru Points: 233963 More actions · Answer 4

Youngoz

upgrade straight to 2008, just bear in mind what i previously pointed out and as Jeffrey said update your stats too. The full rebuild should catch most of those anyway, so when you update stats it will ignore any already up to date.

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

mcsmall Grasshopper Points: 15 More actions · Answer 5

Preparing the process of moving to sql server 2008 from 2005 focusing focusing on consolidating all of the SQL servers that are out there on a core machine and have the different databases running on it.

To avoid paying for extra licenses.

Meet George Jetson SSChampion Points: 11554 More actions · Answer 6

Is there a question involved?

Chris Powell

George: You're kidding.
Elroy: Nope.
George: Then lie to me and say you're kidding.

INNOCENT GUMBO Old Hand Points: 378 More actions · Answer 7

I am more concerned with DTS Packages from SQL 2000, Is it possible to let all of them run on Legacy Mode or it is advisable to upgrade them to SSIS? What if it takes time to re-do some of the Packages into SSIS? advise me.

VSSGeorge SSCrazy Eights Points: 8146 More actions · Answer 8

Hi

I recommend straight upgrade from 2000 to 2008, since Denali, SQL Server 2011 knocking on the door, to be released next year.

I think you got carried away with Intellisense.

There are other features new to SQL Server 2008.

Also read,

http://www.sql-programmers.com/Blog/tabid/153/EntryId/26/T-Sql-Programmability-Features-in-Sql-server-2008-Part-1.aspx

Perry Whittle SSC Guru Points: 233963 More actions · Answer 9

INNOCENT GUMBO (12/7/2010)
I am more concerned with DTS Packages from SQL 2000, Is it possible to let all of them run on Legacy Mode or it is advisable to upgrade them to SSIS? What if it takes time to re-do some of the Packages into SSIS? advise me.

If any packages use dts only components then they will need re writing. Upgrade advisor should pinpoint any packages which may cause an issue

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

INNOCENT GUMBO Old Hand Points: 378 More actions · Answer 10

Thanks Perry;

My Upgrade needs to be completed as fast as possible. So you advise I should leave them in Legacy mode then eventually after a successful Upgrade we can Re-write them if we so wish?

I am sure this should work for us. Isn't it?

Thanks a lot

Perry Whittle SSC Guru Points: 233963 More actions · Answer 11

If any packages are using dts only components they will need re writing immediately and won't run in legacy mode.

-----------------------------------------------------------------------------------------------------------

"Ya can't make an omelette without breaking just a few eggs" 😉

INNOCENT GUMBO Old Hand Points: 378 More actions · Answer 12

Perry;

Ok. Thanks for the information. I will do as such (Rewrite Packages).

Thanks a million

Nadrek SSC-Insane Points: 20039 More actions · Answer 13

2008 (R2) Intellisense has more time savers than time wasters (overall it saves time), but A) it requires a change in how you write things, and B) it completely screws up certain things (cursors, some complex SQL constructs).

2008 (R2)'s best features for me (many are Enterprise only): Date data type, compressed backups, compressed indexes(!), MERGE operator, filtered indexes.

2005+'s best feature: 64-bit version!

Caveat: while, reported DTS runs in Legacy mode on 32-bit 2008 and 2005, this is _not_ supported on the 64-bit versions.