| 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 |
|
|
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).aspxRecently 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
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 upgradehttp://msdn.microsoft.com/en-us/library/ms144256(v=sql.100).aspx------------------------------------------------------------------------------------------------------SQL Server MVPhttp://visakhm.blogspot.com/ |
|
|
|
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. |
|
|
|
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 MVPhttp://visakhm.blogspot.com/ |
|
|
|
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. |
|
|
|
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 MVPhttp://visakhm.blogspot.com/ |
|
|
|
|
Databases Running as Older Versions