Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase

SQL 2008 and SQL 2012 licensing Expand / Collapse
Author
Message
Posted Wednesday, January 16, 2013 1:19 AM
Forum Newbie

Forum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum NewbieForum Newbie

Group: General Forum Members
Last Login: Wednesday, January 16, 2013 3:00 AM
Points: 1, Visits: 16
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
Post #1407660
Posted Wednesday, January 16, 2013 1:28 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: Friday, July 25, 2014 9:12 AM
Points: 5,142, Visits: 4,930
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




Want an answer fast? Try here
How to post data/code for the best help - Jeff Moden
Need a string splitter, try this - Jeff Moden
How to post performance problems - Gail Shaw
CrossTabs-Part1 & Part2 - Jeff Moden
SQL Server Backup, Integrity Check, and Index and Statistics Maintenance - Ola Hallengren
Managing Transaction Logs - Gail Shaw
Troubleshooting SQL Server: A Guide for the Accidental DBA - Jonathan Kehayias and Ted Krueger

Post #1407666
Posted Wednesday, January 16, 2013 1:56 AM


SSCertifiable

SSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiableSSCertifiable

Group: General Forum Members
Last Login: 2 days ago @ 8:57 AM
Points: 7,081, Visits: 12,575
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
Post #1407678
« Prev Topic | Next Topic »

Add to briefcase

Permissions Expand / Collapse