Forum Discussion
SQL SERVER Upgrade
Before Upgrade SQL server 2014 to 2017. I would recommend to first download “Microsoft Data Migration Assistant” tool. This tool will identities all the issues before upgrade from SQL 2014 to SQL 2017. You need to fix all issues before upgrade from SQL 2014 to 2017.
https://www.microsoft.com/en-us/download/details.aspx?id=53595&751be11f-ede8-5a0c-058c-2ee190a24fa6=True
I would recommend Side by Side migration approach. Please create checklist before upgrade server.
Sr.No | Checklist | SQL 2014 | SQL 2017 |
1 | Backup all database |
|
|
2 | Copy all Logins |
|
|
3 | Copy all Audit |
|
|
4 | Copy all linked server |
|
|
5 | Copy Triggers |
|
|
6 | Copy all Policies |
|
|
7 | Copy all Data Collection |
|
|
8 | Copy all Maintenance Plan |
|
|
9 | Copy all Database Mail |
|
|
10 | Copy all SQL Jobs |
|
|
11 | Copy all Alert |
|
|
12 | Copy all Operators |
|
|
13 | Copy all Proxies |
|
|
14 | Copy all System Database Procedures |
|
|
15 | Upgrading Data Transformation Services (DTS) and Integration Services (SSIS) |
|
|
16 | Restore all Database to New server |
|
|