We are in need of upgrading our SQL server. I plan on building a new one and migrating and have a few questions. Once I build the new SQL server and get it updated etc. How do migrate all the data, user account, and maintenance plans? Is there a guide or document for this process. My fear of migrating versus upgrading is that something is missed. Second question is once everything is migrated does changing the server name and IP address cause any issues. I want the server name and IP to remain the same as it is now. Which means once the old server is shutdown I would need to rename the new.