Hi,
We're planning to upgrade our database from SQL Server 2005 to 2012. Based on this link, it seems there's no code conversion needed in terms of Data Type, Keywords in creating SPs, Function, trigger.
The only thing that concerns me is this
Set options |
SET ROWCOUNT for INSERT, UPDATE, and DELETE statements |
TOP keyword |
SET ROWCOUNT |
109 |
But other than that, it should be good.
I would also like to get any feedback from other user who migrated their database from 2005 to 2012. What were the issues encountered during the process. Any tips and suggestion will be much appreciated.
Many Thanks.