Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
jbates99
Constraint Violating Yak Guru
396 Posts |
 Posted - 2014-08-05 : 20:53:25
|
| Of course, when you restore a 2008 R2 database to a 2012 instance, it goes thru several "upgrade" steps. The databases seem to be fine but is there anything else I need to do before putting these into production use?Thanks. |
|
|
gbritton
Master Smack Fu Yak Hacker
2780 Posts |
Posted - 2014-08-06 : 08:12:30
|
| 1. Design a set of regression tests. Run these against 2008R2 and 2012 to ensure that the results are identical in all cases.2. Perform extensive quality assurance against 2012 to validate the end-to-end experience3. Run in parallel for some period of time (determined by the business)0. (Really this should be the first step!) Design a fall-back plan so that if anything goes wrong when you put 2012 into production, you can quickly and easily fall back to 2008R2 with minimal downtime and no loss of data. TEST THE PLAN!! |
 |
|
|
jbates99
Constraint Violating Yak Guru
396 Posts |
Posted - 2014-08-06 : 08:41:49
|
| Thanks, gbritton. |
|
|
|
jackv
Master Smack Fu Yak Hacker
2179 Posts |
|
|
|
|
|
Migrating Databases from 2008 R2 to 2012