This question has been asked so far :
Please let us know the procedure required from AE side when upgrading the AE Database.
Current version: MSSQL 2008 R2
New version: MSSQL 2012
==> Automation Engine won't affect anything as long as you in supported version of MSSQL and V10 do support MSSQL2012