Post reply

Migration of a DB from SQL 2008 R2 to SQL 2012

  • December 3, 2015 at 7:35 pm

    #322727

    I was talking to a friend of mine on the migration plan from SQL 2008 r2 to SQL 2012 .

    On the D-day we can setup mirroring from SQL 2008 R2 to SQL 2012 and fail over to SQL 2012 . The question is what happens if we need to failback to 2008 , is faliback going to be a simple activity or we need to do something else ?

    I do not have any 2008 R2 at this time to test it . Please do let me know if anyone has done something like this ?

  • December 4, 2015 at 1:51 am

    #1843986

    himanshu.sinha (12/3/2015)

    The question is what happens if we need to failback to 2008

    You can't, so make sure that all testing has been done before the upgrade day. And keep a backup of the 2008R2 database so that you have something to fall back to if need be, though you'll have the fun of syncing all the changed data across.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • December 4, 2015 at 12:18 pm

    #1844140

    Thanks Gail . i lost the bet as my friend did told me that we cannot . Surely not a great situation if i land up there .

    What are the options we have for syncing back the data . ?

    TableDiff is one which i have used in the passed hopefully i can use still use that on 2012 .

    Anything else out of the box ?

    Or will have to use customized TSQL scripts ?

  • December 4, 2015 at 12:28 pm

    #1844145

    Tablediff works. Custom scripts. Redgate's SQLDataCompare.

    Better to test comprehensively before the upgrade and not end up in a state where you have to revert. Identify all the breaking changes before you upgrade the production server.

    For the record, I've seen three upgrades this year at clients. One succeeded without any problems. Two have had ongoing performance problems since the upgrade. Want to guess which ones tested before upgrading?

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

Viewing 4 posts - 1 through 3 (of 3 total)

You must be logged in to reply to this topic. Login to reply