How to Make a Copy of an Umbraco Database
by Johan Benjaminsson onThis is how you can move your MSSQL database from dev environment to production. Or if you just need a backup before doing an upgrade. Log in to SQL Management Studio 2014 (it's free) Right click on the database you want to copy and choose Tasks -> Generate Script Choose "Objects" and select "Tables" "Next" under "save to file" choose advanced Script: DROP and CREATE Script for server version 2008 Types of data to script: Schema and Data Choose a place to save the SQL file to Next, Finish! Then just run this script on your production server. If you are overriding an old Umbraco installation i usually get some errors...