I have a SQL Server instance with 3 databases in it (SQL Server 2016 Web on Win Server 2012 r2). All databases have relations with each other. It is live and is feeding some web services.
I need to update 2 databases (or all 3) with the actual data. It takes around a week. So, I created a new VPS and a new SQL Server on it, I created same databases (with the same names and same filenames) on it and I filled them with the new data with no rush.
Now I want to learn what is the best, safest and fastest way to update the live environment.
I plan to do something like this:
Detach the new DBs on the new SQL Server
Detach the hdd from the new windows server.
Attach the hdd to my current live server.
Detach (or maybe delete ???) the old 2 or 3 databases from the live SQL Server.
Attach the new databases on newly attached hdd to old live server.
I have some questions about the logins, relations between the databases, etc...
I need to interrupt the services no more than some minutes. How can I proceed?
I would appreciate with any help.