| Author |
 Topic  |
|
|
jbates99
Constraint Violating Yak Guru
285 Posts |
 Posted - 01/16/2013 : 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
India
47069 Posts |
|
|
James K
Flowing Fount of Yak Knowledge
1500 Posts |
Posted - 01/17/2013 : 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. |
 |
|
|
visakh16
Very Important crosS Applying yaK Herder
India
47069 Posts |
|
|
James K
Flowing Fount of Yak Knowledge
1500 Posts |
Posted - 01/17/2013 : 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. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
India
47069 Posts |
Posted - 01/17/2013 : 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/
|
|
|
|
jbates99
Constraint Violating Yak Guru
285 Posts |
Posted - 01/17/2013 : 09:59:51
|
| Thanks for the tips, everyone. I will run the upgrade advisor before changing the compatibility mode. |
|
|
|
visakh16
Very Important crosS Applying yaK Herder
India
47069 Posts |
Posted - 01/17/2013 : 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/
|
|
|
| |
Topic |
|
Databases Running as Older Versions
