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)
 Databases Running as Older Versions

Author  Topic 

jbates99
Constraint Violating Yak Guru

396 Posts

Posted - 2013-01-16 : 23:08:54
Hi all,

I have found several databases on a 2008 R2 server that have simply been restored from a 2005 instance, but never were upgraded. In 'Options' they show "2005".

What am I losing by them running as an older version? I do plan to upgrade them at some point.
Thanks, Jack

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-01-17 : 00:01:43
you wont be able to use some of new features available in sql 2008 due to 2005 level compatibility set
see
http://www.codeproject.com/Articles/19495/SQL-Server-2008-and-T-SQL-new-features

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-01-17 : 04:23:41
Another thing to keep in mind when you upgrade is that some of the features have been removed - see this page: http://msdn.microsoft.com/en-us/library/ms144262(v=sql.100).aspx

Recently I experimented with upgrading a vendor database from 90 to 110 (2005 to 2012) and found that they were using old style joins (*= and =*) in some of their queries, which is not supported in 110. Should have listened to them before I wasted my time.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-01-17 : 04:28:45
you can use upgrade advisor to get information about any upgrade issues before you start actual upgrade

http://msdn.microsoft.com/en-us/library/ms144256(v=sql.100).aspx

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

James K
Master Smack Fu Yak Hacker

3873 Posts

Posted - 2013-01-17 : 04:36:24
I had done my due diligence, Visakh. The vendor, who shall remain unnamed to protect the guilty, had the SQL code dynamically constructed in their middle tier application.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-01-17 : 04:41:21
quote:
Originally posted by James K

I had done my due diligence, Visakh. The vendor, who shall remain unnamed to protect the guilty, had the SQL code dynamically constructed in their middle tier application.


Hmm..then no guilty feeling James

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

jbates99
Constraint Violating Yak Guru

396 Posts

Posted - 2013-01-17 : 09:59:51
Thanks for the tips, everyone. I will run the upgrade advisor before changing the compatibility mode.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2013-01-17 : 22:55:30
quote:
Originally posted by jbates99

Thanks for the tips, everyone. I will run the upgrade advisor before changing the compatibility mode.


cool. Also try doing it in test box and doing an impact analysis before doing it in a production environment

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page
   

- Advertisement -