1.Run upgrade advisor and review generated report. If you find any errors in the report then work with app owners and fix the errors.
2.Build SQL server SQL2014 and configure as per company standard.
3.Get all DNS names and port numbers from existing servers and make sure it points to new server once it is migrated.
4.Backup all the databases and restore in new server with no recovery mode.
5.Copy ALL server objects from old server to new server.
•Linked Servers.
•Logins
•Jobs etc
6.Copy all the objects and permissions from System databases to new server.
7.Copy all SysAdmin rights related logins to new instance.
8. Restore differential backups into SQL 2014 with Recovery model and stop the SQL services on old instance.
9. Check the orphan users after the migration.
10.Change the database capability of all the databases to SQL 2014 and run the update statistics for all the databases.
11.Rebuild all Indexes
12.End users should have SQL2014 client tools installed on their desktop/Laptop after migrating to SQL 2014.
2.Build SQL server SQL2014 and configure as per company standard.
3.Get all DNS names and port numbers from existing servers and make sure it points to new server once it is migrated.
4.Backup all the databases and restore in new server with no recovery mode.
5.Copy ALL server objects from old server to new server.
•Linked Servers.
•Logins
•Jobs etc
6.Copy all the objects and permissions from System databases to new server.
7.Copy all SysAdmin rights related logins to new instance.
8. Restore differential backups into SQL 2014 with Recovery model and stop the SQL services on old instance.
9. Check the orphan users after the migration.
10.Change the database capability of all the databases to SQL 2014 and run the update statistics for all the databases.
11.Rebuild all Indexes
12.End users should have SQL2014 client tools installed on their desktop/Laptop after migrating to SQL 2014.
No comments:
Post a Comment