Deprecated Code - Migration from SQL 2005 to 2012

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 INSERTUPDATE, 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.

March 24th, 2015 2:25am

What is your mode of upgrade

1. In place

2. Side by side

You must also read

Breaking changes to DB engine features in SQL Server 2012

Breaking changes to SQL Server features in SQL Server 2012

If you are just using DB engine features and SSIS I would advise you to first run upgrade advisor and look for breaking changes or unsupported scenarios. make sure you mitigate all such issues.

There is also a feature where you can side by side upgrade database by backup restore to SQL Server 2012 and still keep compatibility level to 90 (but that is not advised)

I have migrated database from 2008 to 2012 but not from 2005 but above documents were very handy and would work quite well.

March 24th, 2015 3:38am

This topic is archived. No further replies will be accepted.

Other recent topics Other recent topics