• Eirikur Eiriksson (8/25/2014)


    ramana3327 (8/25/2014)


    Hi,

    If we want to move SQL Sever 2008R2 to SQL 2102,

    In placemigration (Upgradation) or side by side migration is better? How can we decide which one is better option to us?

    This article showing that it is always better to avoid in place migration

    Thanks,

    Quick thought, my preferred method is (when possible) to do a side by side installation of SQL2012 and then copy everything over, test it and drop the source.

    😎

    +1. Side by side is safer. It completely avoids the risk of in-place upgrade. Your rollback plan is to simply revert back to using the original.