Upgrading from 2008R2 Express to 2012 SP1 Express

I am planning to upgrade my MS SQL 2008R2 Express to the 2012 SP1 Express version.
I run an ASP Classic application that connects to that database.

Is there something that may not work on 2012 version ?  Any differences I should be concerned about ?  deprecated features, etc ?
LVL 1
AleksAsked:
Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

x
I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

amilie wilsonCommented:
I have made a excel sheet view it you will definitely find solution
differences-in-sql-2008R2---2012.xlsx
Deepak ChauhanSQL Server DBACommented:
You can upgrade 2008r2 to 2012, depricated feature are still available in sql 2012 but you have to think for next upgrade. A common issue has been noted with SQL CLR types. If you have only sql server 2012 installed on the system, you may see the error message "Could not load file or assembly 'Microsoft.SqlServer.Types"

You can work around this issue in your connection string by specifying a value of "SQL Server 2012" for the "Type System Version" attribute to force SqlClient to load version 11.0 of the assembly.

No worry if you are not using any CLR types.

In addition you can install and run the SQL server 2012 upgrade Advisor,  this will help you where you need to take corrective action.

Here is the list of depricated features.
https://technet.microsoft.com/en-us/library/ms143729(v=sql.110).aspx

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
Vitor MontalvãoMSSQL Senior EngineerCommented:
Are you going to upgrade in-place or it will be a side-by-side upgrade?
If in-place then be sure that your SQL Server 2008R2 has at least SP1 installed. Also, don't forget to apply SP2 + CU6 on SQL Server 2012 instance so it will be up to date.
After upgrading/migrating the databases you'll need to change their compatibility level from 10 (MSSQL 2008) to 11 (MSSQL 2012).
AleksAuthor Commented:
Thanks to both. This should take care of it  :)
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today
Windows Server 2008

From novice to tech pro — start learning today.