SQL Server Forums
Profile | Register | Active Topics | Members | Search | Forum FAQ
 
Register Now and get your question answered!
Username:
Password:
Save Password
Forgot your Password?

 All Forums
 SQL Server 2008 Forums
 SQL Server Administration (2008)
 Databases Running as Older Versions
 New Topic  Reply to Topic
 Printer Friendly
Author Previous Topic Topic Next Topic  

jbates99
Constraint Violating Yak Guru

385 Posts

Posted - 01/16/2013 :  23:08:54  Show Profile  Reply with Quote
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

India
52317 Posts

Posted - 01/17/2013 :  00:01:43  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

3706 Posts

Posted - 01/17/2013 :  04:23:41  Show Profile  Reply with Quote
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

India
52317 Posts

Posted - 01/17/2013 :  04:28:45  Show Profile  Reply with Quote
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
Flowing Fount of Yak Knowledge

3706 Posts

Posted - 01/17/2013 :  04:36:24  Show Profile  Reply with Quote
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

India
52317 Posts

Posted - 01/17/2013 :  04:41:21  Show Profile  Reply with Quote
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

385 Posts

Posted - 01/17/2013 :  09:59:51  Show Profile  Reply with Quote
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

India
52317 Posts

Posted - 01/17/2013 :  22:55:30  Show Profile  Reply with Quote
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
  Previous Topic Topic Next Topic  
 New Topic  Reply to Topic
 Printer Friendly
Jump To:
SQL Server Forums © 2000-2009 SQLTeam Publishing, LLC Go To Top Of Page
This page was generated in 0.06 seconds. Powered By: Snitz Forums 2000