Currently, i am using SQL SERVER 2008 Standard in our organisation. I wonder what factors should i consider to upgrade it to sql server 2008 r2? In other words, what factors drive in an organisation that enables us to think about upgrading a existing version of the database server.
asked Nov 16 '11 at 06:42 PM in Default
Regardless of the version you want to upgrade to, take a look at what features you currently use and what features are coming in the version you want to upgrade to. Take into consideration if there are any features that you currently miss, but are in the next version. Also consider if the Edition will stay the same or not (upgrade/downgrade).
Some Enterprise only features of a current version get pushed down to Standard Edition (backup compression being a good example for 2008R2).
I agree with @Håkan Winther, wait and upgrade to 2012. That is, if you can wait and if the new licensing plans don't clash with your company's policies.
answered Nov 16 '11 at 11:46 PM
Personally I would wait for SQL server 2012. SQL server 2012 contains a lot more features that are useful and SQL server 2012 is scheduled to the beginning of 2012.
answered Nov 16 '11 at 09:41 PM