I am working on migration project and just wanted to check the best way to do this. We are doing side by side migration (2005 to 2012)
We have one physical server and moving databases to two different VMs and this means splitting databases on to two servers. As a result some of the references needs to be updated. I was keeping a log of all stored procedures, views and functions which needs updating. However after keeping log of 10 objects I found we have more than 100 object to change. We can script out all objects. I thought instead of keeping script of all objects which I am updating, it is easer to script out all objects following the change and testing on new server. Then when we backup, copy and restore the databases (go live) we will have updated data. I can then run all scripted objects from 2012 server which means all changes will be applied.
Is this the best option to apply the changes?