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.

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Upgrade considerations from 2005 to 2008

Author  Topic 

WindChaser
Posting Yak Master

225 Posts

Posted - 2012-03-05 : 15:22:49
Hi folks,

I searched the forum and the MS site without success. Does anyone know where I could find a list of upgrade considerations for 2005 to 2008 including a list of data types which may no longer be supported?

Thanks!

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-03-05 : 15:50:57
I don't have a list such as that, but have you run the Upgrade Advisor to check for incompatibilities?

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

WindChaser
Posting Yak Master

225 Posts

Posted - 2012-03-05 : 23:26:41
Thanks for the suggestion. I've just run it and it came up clean.

Thanks Tara!
Go to Top of Page

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2012-03-06 : 00:21:04
If all of your database code is in stored procedures, and the upgrade advisor says you are okay, then I would start testing 2008 on a test system. Might be a-okay! Oh and be sure to test on compatibility level 100 to take full advantage of 2008.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog
Go to Top of Page

Kristen
Test

22859 Posts

Posted - 2012-03-06 : 04:31:07
SQL2008 Migration: Hints and Tips SQL 2008

http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=138230
Go to Top of Page

jackv
Master Smack Fu Yak Hacker

2179 Posts

Posted - 2012-03-06 : 10:42:03
There's a link to a download from Microsoft on : http://www.sqlserver-dba.com/2012/03/sql-server-2005-to-sql-server-2008-r2-upgrade-considerations.html

Jack Vamvas
--------------------
http://www.sqlserver-dba.com
Go to Top of Page
   

- Advertisement -