What is the best way to replace a SQL Server database with an updated one?
Restore new database from backup (or attach) as yourDatabaseNew
Rename old database to yourDatabaseOld
Rename new database to yourDatabase
Drop the old database

To fix the logins problem make sure you created all logins and users on your temporary VPS.
Export logins from the existing server with sp_help_revlogin