Converting 2005 Databases to 2008

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)

Converting 2005 Databases to 2008

Author

Topic

jbates99
Constraint Violating Yak Guru

396 Posts

Posted - 2010-11-02 : 14:36:29

hi everyone,

I restored a 2005 .bak onto my 2008 R2 server.

In Management Studio, the new (2008) database Compatibility Level shows "SQL Server 2005"

I seem to be able to click the box and flip it to "SQL Server 2008"

Does that really trigger any kind of conversion on the database? Should I be concerned if my restored databases still show as SQl Server 2005?

Thanks, John

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2010-11-02 : 14:38:00

It doesn't trigger a conversion, but it means that your code could break if it doesn't support what 2008 requires. You should do a full regression test on the new compatibility level before making this change in production.

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

Subscribe to my blog

Kristen
Test

22859 Posts

Posted - 2010-11-02 : 15:12:11

See http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=138230 for SQL2008 Migration Hints and Tips

jbates99
Constraint Violating Yak Guru

396 Posts

Posted - 2010-11-02 : 18:02:04

quote:
Originally posted by Kristen

See http://www.sqlteam.com/forums/topic.asp?TOPIC_ID=138230 for SQL2008 Migration Hints and Tips

Thanks very much Kristen!

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources