Migration and Testing Workload

• ramana3327

  SSCoach

  Points: 19700

  More actions

  August 27, 2014 at 2:59 pm

  #310494

  Hi,

  We are using Sql Server 2008 R2. We are planning to move to 2014 either through in-place o side-by-side. Mostly side-by-side.

  Here first we want to test that 2014 and availability groups. First we are doing in dev box to test. Also we need asynchronous replica because just we need to use that as reporting server.

  We want to take work load. For the dev boxes, the applications doesn't connect. Then in that case what the people will do.

  If We take database backup from prod to that dev and run some queries in the loop and run the trace for some time and do either in-place migration or side-by-side migration and use the same back to restore and doing the running the same queries and compare this trace to previous trace will work?

  Later we can do this in the test box

  Any suggestions please

  Thanks