Any upgrading issues from SQL 2000 to 2008? 1

[robertfah]

Pretty much what the topic says...we are preparig to upgrade our SQL Server 2000 to 2008 and was curious if there are any hurdles that I should be aware of?

 

[gmmastros]

Have you looked at the upgrade advisor yet?

http://www.microsoft.com/download/en/details.aspx?id=11455

-George
Microsoft SQL Server MVP
My Blogs
SQLCop
twitter
"The great things about standards is that there are so many to choose from." - Fortune Cookie Wisdom

 

[SQLBill]

yes. Run the upgrade wizard. The old joins (=* *=) need to be re-written. Does your process use textcopy.exe? It doesn't exist in SS2008. Table hints change. Column aliases in Order By cannot be prefixed by the table alias.

There are lot of other issues when you upgrade to SS2008 from SS2000 - so run the upgrade wizard to see what you need to fix.

-SQLBill



The following is part of my signature block and is only intended to be informational.
Posting advice: FAQ481-4875

 

[Qik3Coder]

One point towards what SQLBill said, do your upgrade in a test environment.

You've got questions and source code. We want both!

 

[robertfah]

Thanks guys...I ran the wizard and it fould Full-Text searches needed to be changed (but we don't use them so I think this is ok) and a few Keywords that have depreciated which will need changing. What a life-saver this app is. Thanks for the help! Oh and yes, we ran it in our Staging environment first (which is identical to our Production environment).