Before migrating to SQL Server 2014, you should run SQL Server 2014 Upgrade Advisor tool on your existing SQL Server 2008 Databases instance. This will make sure if you are good for upgrade, otherwise you have to do make some code/config changes as per the report created by the tool.
There were few things we observed while upgrading from SQL 2008 to SQL 2012 and as these should also stand same for SQL 2014 as well, so please check these:
1. No native Linked Server support to SQL Server 2000
2. Temp #Tables created with negative IDs
3. IDENTITY column value hop (by design, not a bug)
4. SQLNCLI11 for linked server “XYZ” returned message “Requested conversion is not supported”
~manoj | email: http://scr.im/m22g
http://ift.tt/LOIag3
MCCA 2011 | My FB Page
No comments:
Post a Comment