Moving Umbraco

To move Umbraco hosting you can follow the following steps.

You will need:

• Access to your control panel at control.mijnhostingpartner.nl
• Backup of your current database, stored locally.
• Backup of your Umbraco files. In almost all cases this is the entire wwwroot. This can be done via FTP.

The steps to be performed below:

1. The files can be uploaded via FTP to the new environment. Do this by creating a zip file of the files and uploading it via Filezilla.
2. Create a database and user in the control panel.
3. Import the database with Microsoft SQL Server Management Studio.
4. Modify the database to the new users and database name.
5. Change the prefix of all tables to dbo. This is because of the error message: "Invalid object name 'umbracoDomains'" This can be done with the following SQL statement:
   
   exec sp_MSforeachtable 'ALTER SCHEMA dbo TRANSFER ?'

You now have the files in the right place and the database adjusted where necessary and put live. Now all that remains is to modify the web.config file to the new database data. And adjusting the correct permissions via the Filemanager.

Remember that the database name and user must be filled in with our predix from the control panel and is CapitalLetterSensitive.



After performing the above steps your Umbraco website should be successfully moved. If the domain name has changed then you will also need to change this in the administrator environment of Umbraco.