SQL Server 2008 upgrade to SQL Server 2017 standard editions
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.
Thanks
Thanks
David Johnson, CD
with local user accounts maybe, domain accounts not. won't affect sql login accounts.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
thank you very much of these methods do you recommend one over the other for simplicity. I only manage one SQL server so certainly not an expert. Looking for simple versus fast.
ASKER
sorry if this is a silly questions but I read the articles and copy database seems to be best for me. But since none of these copy the system databases I asked myself do I even need to copy the system databases? What do I lose if I don't.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Exactly what I needed