There is no known issue yet in migrating the EMS Database from MS SQL 2008 R2 to MS SQL 2012 SP1.
Take the backup of EMSDB from MSSQL 2008 and restore it on MSSQL 2012. Also need to modify context.xml and ems-quartz.properties file for pointing new database location.