Considerations for migration (starting point)
  1. Method of upgrade, upgrade instance, attach/detach or backup restore.
  2. If upgraded from further back than previous version, recommended to upgrade via intermediate versions i.e. 2005 => 2008 => 2012.
  3. Login and User connections
  4. Effects of Client upgrade (e.g. Upgrade from earlier versions of ADO causes extra recordsets returned for row counts, need to add SET NOROWCOUNT ON to queries or stored procedure).
  5. Collation - does new instance have same collation.
  6. Impact of new database on new instance.
  7. Test with captured work load (test different scenarios e.g. batch, peak day)

Last edited Jan 21, 2014 at 10:41 AM by geoffrclark, version 4