Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
agdavidson
Starting Member
17 Posts |
 Posted - 2010-01-06 : 13:45:53
|
| I am upgrading a SQL Server 2000 database to 2008, and my boss directed me to "identify deprecated index options & script tables with appropriately modified indexes". Now that I've restored the 2000 DBs onto our 2008 server instance, I expected there to be significant work along these lines, but the indexes appear to be intact and functioning. Are they "upgraded" automatically as part of the restore process, or am I missing something here (I thought it would be somewhat equivalent to identifying index hints in SPs that don't use WITH, etc)?I hope that makes sense cause I’m certainly at a loss here, and I’d like to figure this out without having to go back and ask him for clarification :)Austin |
|
|
russell
Pyro-ma-ni-yak
5072 Posts |
Posted - 2010-01-06 : 14:28:10
|
| I think your boss is confused.See this documented for a list of deprecated features: http://msdn.microsoft.com/en-us/library/ms143729.aspxThere are new features you can use, but the only thing deprecated is CREATE syntax without parentheses. DBCC functions are as well, but that's nothing to do with what your boss is apparently asking for...As far as "upgrading" the indexes, they are internally stored the same in sql2005/2008 as they were in 2000.What you should do is rebuild all the indexes, but other than that there is really nothing to it |
 |
|
|
tkizer
Almighty SQL Goddess
38200 Posts |
|
|
agdavidson
Starting Member
17 Posts |
Posted - 2010-01-07 : 10:26:51
|
| Thank you both for clearing this up! I really appreciate it :) |
|
|
|
|
|
|
Index Options When Moving from 2000 -> 2008