January 16, 2013 at 1:19 am
Dear all,
Let me make a couple of questions that made me confused alot.
(1) We have some softwares that only compatible with SQL 2008, unfortunately we only can purchased SQL 2012 license in the market.
My first quetion is, can we just go ahead to upgrade to SQL 2012 and set compatibility level to SQL 2008 for those database that only compatible with SQL2008 as I mentioned before?
(2) We purchased SQL 2012 license from our vendor. But they did not provide any license key and installation CD/DVD. What they gave us are just license agreement documents and Microsoft Open License Purchase Order Confirmation (Authorization Number and 8 digit of License Number are inside in that paper - I am sure this should not be SQL license key). The licnese should appears in our VLC user centre, but when it says there is no product key needed for this product.
My second question is, Where can I get our SQL2012 license key? Is that OK just downloading evaluation version from Microsoft Website?
Thank in advance
Regards,
Silence
January 16, 2013 at 1:28 am
Generally the licence key is built into the media, the only thing you have to say its licensed or not is a piece of paper saying I have X amount of licenses, then it is up to you to ensure that you are in compliance with that.
Now depending on your licensing agreement you may have downgrade rights, where you purchase SQL 2012 licenses but you actually install SQL 2008, but you need to ensure that you licenses the SQL 2008 box under the SQL 2012 rules, so per core not per processor. Check with your re-seller on if you have downgrade rights.
Evaluation edition will expire after 180 days, so you will need to ensure that you download the full edtion of SQL or ensure you have the full license key when installing from the evaluation edition media.
If the vendor of the application says its only compatable with SQL 2008, then I would heed their advice and leave it on SQL 2008 as they may be functionality which will break on the upgrade to 2012.
You could always run the upgrade advisor and see if anything will break, then upgrade your dev, test environment first and test the app out to ensure it works as it should in SQL 2012 before you upgrade your production box.
Compatability level doesnt make the database a SQL 2008 database. Once you upgrade from 2008 to 2012 the database changes to a SQL 2012 database, the compatabilty level just tells SQL that certain things behave differently.
As with all things licensing, don't take a public forums advice as the truth, always speak to your MS Reseller or MS directly
January 16, 2013 at 1:56 am
zinminmaungmaung (1/16/2013)
(1) We have some softwares that only compatible with SQL 2008, unfortunately we only can purchased SQL 2012 license in the market.My first quetion is, can we just go ahead to upgrade to SQL 2012 and set compatibility level to SQL 2008 for those database that only compatible with SQL2008 as I mentioned before?
Chances are good everything will work fine but there is no guarantee so set aside some time for testing. The compat level only pertains to the query language parser. Everything else beyond that functions as a SQL Server 2012 database. The compat level is there so that you can run applications built for SQL 2008 against a SQL 2012 database but it is not 100% guaranteed that everything will work the same, only that it is likely.
There are no special teachers of virtue, because virtue is taught by the whole community.
--Plato
Viewing 3 posts - 1 through 2 (of 2 total)
You must be logged in to reply to this topic. Login to reply