Moving an Umbraco SQL DB to Azure

This is more for my documentation, but it may help someone else so I'm posting it

I had been developing an Umbraco 7.3.1 site locally with no issues. Then I needed to move the database to Azure (version v12). There are sources of information for doing this sort of thing, but the ones I found were out of date or overly complex. This is a straightforward way I've found that works.

  1. Open Sql Management Studio (I'm using 2014).

  2. Navigate to your Sql database that you want to copy.

  3. Right click on the database and go to Tasks -> Generate Scripts...

  4. In the Choose Objects step choose Select specific database objects and then click Select All

  5. In the Set Scripting Options section choose Save to new query window and click the Advanced button.

  6. Set your advanced configuration to mimic these settings this is where I spent most of my time

  7. Connect to your target Azure DB server, choose your target database and execute the query. It should execute successfully.

That's it

The advancements of Azure DB and Umbraco have made this process very simple assuming you know which advanced settings to set.

Related Posts

Proudly published with Ghost