Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Any upgrading issues from SQL 2000 to 2008? 1

Status
Not open for further replies.

robertfah

Programmer
Mar 20, 2006
380
US
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?

 
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
 
One point towards what SQLBill said, do your upgrade in a test environment.

You've got questions and source code. We want both!
 
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).
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top