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