KirstenStovall
New Member
We're moving & upgrading an active ASP.NET site with a sql server 2012 db to a new host company and want to minimize down time.Our plan:[*]Recreate the db and publish the upgraded solution on the new hostTest the new installationClose the active siteDirect the domain name pointer to the new hostDuring the move and testing--steps 1 & 2 above-- the existing site will remain live and users will continue to create and update records. (It could be hours of testing and fixing and we would rather not shut down for that long. Users might make hundreds of new records across dozens of tables.)Is a full restore of the final back up of the old db the best (or only) way to update the new db with the final records from the old?Thanks