SQL server 2005 to SQL server 2012 migration

hello everyone,

hope doing good!
company had refreshed windows 2003 servers 2008 r2 last year. along server refresh, database team had upgraded sql server 2005 sql server 2012 sp2 , database set (sql server 2012) 110 compatibility level.
playing sql developer role here , have below questions,

1. stored procedures/functions/views/indexes developed on sql server 2005 work same way in sql server 2012? 
2. there way/any method identify 2012 sql db, need make code changes , how, suit current db compatibility level , take full advantage of it.

saw below useful links on https://technet.microsoft.com, difficult analyze each , every stored procedures/views/functions/indexes etc..in database. method pull out these details database helpful. fyi - don't have of server sql server 2005 db @ moment.

https://technet.microsoft.com/en-us/library/ms144262(v=sql.110).aspx
https://technet.microsoft.com/en-us/library/ms143179(v=sql.110).aspx
https://technet.microsoft.com/en-us/library/ms143359(v=sql.110).aspx
https://technet.microsoft.com/en-us/library/ms143729(v=sql.90).aspx

thanks,
uday

hello there,

there have been lot of improvements , additions of new features new versions after sql server 2005. think need take @ new features of not sql server 2012, 2008 , 2008 r2, not miss new.

also suggest check out discontinued , deprecated features lists of versions. that, there extended events can track codes using deprecated features.

before upgrade if ran upgrade advisor against sql server 2005 instance, he/she must have been noted details sps or possible database compatibility issues? if not, can again use extended events monitor codes fails. name of event "error_reported".

here's documentation various versions of sql server, search "what's new" related versions.

---

http://ekremonsoy.blogspot.com | http://www.ekremonsoy.com | @ekremonsoy

SQL Server  >  SQL Server Migration