Migration means Side-by-Side as mostly in real time(Production), In-Place Migration is NOT recommended due to its more down time till the newly built instance & database are ready.
Use of UAR - upgrade adviser report
When consolidating the instances on migration(assumes Hardware suffice) Conflicts may be @:
Database names
SQL Server Jobs names
Agent Jobs History - use Agent job's id to make related entry in the new msdb
Maintenance plans - Saved Schedules
SSIS packages -
No comments:
Post a Comment