February 5, 2018 at 8:13 am
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?
February 5, 2018 at 9:12 am
dva2007 - Monday, February 5, 2018 8:13 AMI 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?
You may find that you are able to solve some of these problems more efficiently through the use of Synonyms.
The absence of evidence is not evidence of absence.
Martin Rees
You can lead a horse to water, but a pencil must be lead.
Stan Laurel
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply