This article will assist you to transfer and restore your websites, MS SQL, MySQL databases from local computer to Windows VPS. We believe that you have taken a complete backup of all your websites and databases from the previous host. Now, we will need to transfer these files to Windows VPS.
Transfer Using Remote Desktop Connection
You just need to connect to your Windows VPS through Remote Desktop and transfer web content archives, MS SQL and MySQL database backups files by referring to the following tutorial. Using Remote Desktop connection, you can also transfer any other important files you want to upload from your local computer.
Transfer web content using Remote Desktop Connection
We believe that you have transferred your website files and databases to your VPS, now we will learn how to restore them.
Web Content Restoration
Extract the website ZIP file you have just uploaded. If you have purchased VPS with WebsitePanel, check out this video tutorial to create domain/website in IIS and place your website files to wwwroot folder. If you have not opted for the WebsitePanel, you can create Website from IIS and set your website path.
MS SQL Database Restoration
MS SQL database can be restored via WebsitePanel or via SQL Server Management Studio. Here is a tutorial, you can refer to restore MSSQL database via SQL Server Management Studio.
MySQL Database Restoration
To restore MySQL database, you can refer to our knowledgebase article, how to restore MySQL database from phpMyAdmin.