1. 1. Original Server Audit
   1. 1.1 Identify specific server objects
      1. Security
         1. login
         2. credentials/proxy
         3. certificates
         4. Grant Server
         5. security threat
            1. Application login as dbo
      2. Services
         1. FT search
         2. SSAS
         3. SSRS
         4. SSIS
         5. Browser
      3. Filestream
      4. Replication
         1. transactional
         2. merge
         3. snapshot
      5. SSIS DTSX packages
      6. SQL server Jobs
   2. 1.2. Identify identification mode
   3. 1.3 Identify windows specific processes/tasks
   4. 1.4 Identifiy database settings critical to migration
      1. recovery model
      2. Page verify option
      3. Compatibility mode
         1. If compatibility mode < Sql server version: upgrade and test
      4. Trustworthy
      5. Others
   5. 1.5 Database objects
      1. Full text catalogs/indexes
      2. Db_owner
      3. Security threats
         1. Application login as dbo
      4. programmability
         1. Assembly / Dlls 32-bit
         2. Dynamic Sql within Stored procedures
   6. 1.6 Space / Capacity management
      1. Current size
      2. Estimation of future growth
      3. Tempdb space allocation
2. 2. New server Audit
   1. 2.1 Audit of subsystem
      1. Disk alignment
      2. 64-k partition on data and log
      3. Framework 3.5 sp1
      4. windows installer
      5. Patched OS
      6. SQL IO performance check
      7. Ideal drives configuration
         1. OS drive 4k format (RAID 1 local)
         2. Cache Drive for OS (RAID 1 local)
         3. SQL server program Drive local (RAID 1 local)
         4. System Databases drive 64-k RAID 5 or 1+0
         5. Log Drive 64_k RAID 1/5 or 1+0
         6. Data Drive 64_k RAID 5 or 1+0
         7. Backup Drive RAID 1 or 1+0
         8. Tempdb drive RAID 1 or 1+0
   2. 2.2 Install
      1. Sql server RTM
      2. patch
      3. System databases settings
      4. Server settings
         1. sql collation, OS regional settings and clock time
   3. 2.3 High Availability
      1. Clustering
         1. Specific prerequisites
            1. Bios Hyperthreading deactivated
            2. Registry: TCP Chimney disabled, RSS and TCPA enabled
            3. MSDTC / quorum
      2. Mirroring
         1. FQDN
         2. TCP protocol
         3. Mirroring end points
         4. Security protocol: certificate vs. kerberos or windows negotiate
         5. share or nas
         6. Witness
         7. Automatic or manual failover protocol
      3. Log Shipping
         1. Share or nas
         2. Manual failover protocol
      4. Geographical HA?
         1. RecoverPoint
         2. third-party Mirroring
         3. Others
         4. SQL server solutions
            1. LS
            2. Mirroring
            3. Replication
      5. replication
   4. 2.4 Disaster Recovery plan
      1. Backup regime
      2. SLA
3. 3. First rebase and Tests
   1. 3.1 Rebase Pre Migration script and Migration script
      1. Deploy DBATool
         1. DBATool_Version 1.3.sql
      2. dtsx
         1. dtutil
         2. rebuild with bids
      3. Write all backup/ restore scripts
      4. Test Share, FTP: transfer protocol
   2. 3.2 Post script migration
      1. Compatibility mode
      2. Page verify option
      3. Security script
      4. Install HA solution if not clustering
         1. Install witness
         2. Script end points and deploy
         3. Script certificate and deploy
         4. Synchronize
         5. Deploy partners
   3. 3.3 Functional testing
      1. Profiling
         1. Check errors on connect
         2. check errors on T-SQL/Stored procedure compatibility
      2. Load tests
      3. HA test
         1. Clustering
            1. Move groups
            2. Simulate a failover
         2. Mirroring
            1. Manual failover testing
            2. Automatic failover testing
   4. 3.4 Check OS regional settings
4. 4. Migration
   1. 4.1 Planning
   2. 4.2 Recovery model to Full or Bulk-logged
   3. 4.3 coordonnate downtime
   4. 4.4 Migrate Server objects
      1. Sql server logins
         1. Sp_helprevlogins
      2. Sql server jobs
      3. Other server objects
   5. 4.5 Backup/Restore chronology
      1. transfer full backups
      2. Restore full backups with norecovery
      3. Backups logs
      4. transfer logs
      5. Restore Logs with norecovery
      6. Downtime
      7. Backup tail logs
      8. Transfer tail logs
      9. Restore tail logs with recovery
      10. fullBackups
   6. 4.6 Recovery model, database settings
   7. 4.7 Communication/synchronization
      1. Application tier
         1. Failover partner if HA
         2. Datasource switch
      2. Network tier
         1. DNS switch
5. 5. Post Migration Phase
   1. 5.1 Immediate Supervision post migration
      1. Profiling while activity is switch to new server
      2. Shut down old servers
      3. Fix exceptional and not foreseen issues (not foresee by test phase
      4. Backup regime implementation
      5. Reindex job implementation
      6. Support Q&A
      7. Supervision tools
         1. Policy-based Alerts
         2. Raiserror with Log
         3. DDL triggers
         4. DB Mail
            1. Activation
            2. Smtp Account
            3. Profile
            4. Alert jobs and failure steps
         5. Windows event log
         6. Third-party Supervision Tool
            1. Nagios
            2. Microsoft Operation Manager
            3. HP Openview
   2. 5.2 Several Days supervision
      1. Sql server jobs
      2. Perfmon
      3. Dmvs
      4. Profiler and traces