Our business has a single live server running SQL that powers three database-driven web sites (1 x 200mb mdb file, plus 2 x 15mb mdb files). These currently run SQL2005 Workgroup, and we have SQL 2008 Developer Edition on a single development machine which is provided via the Microsoft Partner agreement.
We need a new server, so as part of this process we will upgrade SQL to either 2008 or 2012. I'm guessing it makes more sense to jump to 2012 to prolong how soon we need to upgrade next time...?
First off, am I right in thinking that I only need Standard Edition if we don't do any BI work? We just access SQL using SSMS and use T-SQL/SP's to perform CRUD work/backups. The MS site says Standard is for non-critical databases. For me it is critical(!) but I assume it means when no failover clustering is being used, which we currently don't do?
So if Standard is the right edition, do I need 1 x Server license + 1 x CAL (for the developer to log in via SSMS), or does our Developer Edition negate the need for the CAL?
Next up, how the heck do I actually buy it? I've asked three so-called software resellers (found on MS PinPoint) to clarify the above and haven't even had a reply...!
I used Microsoft License Advisor with these options:
The resulting price comes to £757.97 ($1,199.10 USD) assuming I don't need Software Assurance and haven't specified a pricing band (whatever they are...).
Is anyone aware of a UK-based reseller who can provide SQL at anywhere near this price (if the price is indeed correct for my needs?). If this price to purchase SQL is correct, how come UK hosting companies like Rackspace and Memset charge £195 per month
for a SQL standard license?