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 |
|
rammohan
Posting Yak Master
212 Posts |
 Posted - 2012-08-08 : 13:16:46
|
| Hi,We have couple of databases in 2000 version...Now we need to uplift these databases to 2008 versions.....We have to convert all objects of databses... Please tell me some T-SQL areas that can be uplifted to 2008 server and please provide suggestions i need to remember while uplifting queries.....Thanks in advanceOne can never consent to creep,when one feels an impulse to soarRAMMOHAN |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2012-08-08 : 13:25:01
|
| I would start with the upgrade advisor: http://www.microsoft.com/en-us/download/details.aspx?id=11455However, do not rely solely on it. Even if it does a perfect job of identifying everything (which it probably won't) it won't obviously pick up incompatibilities in adhoc queries embedded in client code etc. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
52326 Posts |
Posted - 2012-08-08 : 15:33:38
|
| for adhoc queries refer below part and see what are breaking changes in sql 2008http://msdn.microsoft.com/en-us/library/ms143179(v=sql.100).aspx------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
|
|
Migrating sp's from sqlserver 2000 to 2008