We need to upgrade two SQL Servers for our projects to SQL Server 2012. Since we’re not db-admins or familiar with such migrations, I wanted to ask you if you could tell me what we have to be aware of and check before upgrading.
Some information about the servers:
- SQL Server 2008
- No procedures
- No functions
- No views
I think this should not really be a problem to upgrade to 2012 right? Is there anything else we have to make sure?
- SQL Server 2005
- ~700 procedures
- ~50 functions
- ~100 views
I think this will be more of a problem… is there any logic that won’t work on SQL Server 2012 that did on SQL Server 2005?
Is there a list of keywords which are not supported anymore?
Are there other problems that could happen during / after the migration?
Thanks in advance