I have a working copy of the Umbraco 4.5 database on SQL Azure.. connecting to it from a non-Azure server.. working great...

23 steps to success:  (be patient and follow exactly)

 1. Install umbraco 4.5 locally on sqlexpress
 2. Open SQL Management Studio 2008 RC2
 3. Add primary key to umbracoUserLogins table (contextID, userID)
 4. Right-click on umbraco database
 5. Select Tasks >> Extract Data-tier Application...
 6. Save and note location of .dacpac file
 7. Right-click on umbraco database
 8. Select Tasks >> Generate Scripts...
 9. Select only tables
10. Click Next then click Advanced
11. Find "Types of data to script" and select "Data Only"
12. Click Ok.. (Note .sql file save location)
13. Click Next.. Next
14. Connect to your SQL Azure database in Management Studio
15. Right-click server node
16. Select Tasks >> Deploy Data-tier Application..
17. Select previously saved .dacpac file
18. After deployment, select new database (CLICK IT)
19. Select from menu, File >> Open >> File...
20. Select previously saved .sql file
21. Make sure new database is selected in available database drop-down
22. Click 'Execute' to add data to new database
23. Edit your web.config to point to the SQL Azure database

Done!

Daniel, this is great, I know a bunch of people who've been dying for a step-by-step procedure to install Umbraco on Azure and this is it!

I've created this as a wiki page here.

Best,

Benjamin

Great step-by-step tutorial for getting umbraco to run on Azure, and many thanks for sharing this. +1

Cheers,

/Dirk

Thanks Daniel!

I'll try to follow your steps. One question though, How is this any different when using the SQL Migration Wizard tool from codeplex? have you tried that as well?

One additional question. I have disabled the following section in the web.config as it causes my deployment of Umbraco in Windows Azure to fail. Has anybody encountered this as well?

  <!-- ASPNETAJAX -->
  <system.web.extensions>
    <scripting>
      <scriptResourceHandler enableCompression="true" enableCaching="true" />
    </scripting>
  </system.web.extensions>

Update in Windows Azure deployment:

Encountered the following issues:

• :20000 - Azure existing port issue. port gets added to the actual domain name which causes CSS, JS and some other pages to fail.
• Access denied in web.config - tried to create a workaround here by putting the config files in the Azure Local Resource location. also planned to create a cloud service definition key and value pair for DB connection and status.

Anybody tried and encountered these issues? :)

You can also extract the scripts as Azure SQL scripts after that just run the generate script.

Explanation at:

http://blogs.msdn.com/b/cesardelatorre/archive/2010/06/04/importing-exporting-data-to-sql-azure-databases-using-bcp-and-sql-scripts.aspx

Hi,

I am trying to install Umbraco 4.5.2 and I am running into some difficulties.

I follow the 23 steps exactly but I continue to get a large number of errors when I try and run my Generated Scripts on the Azure server. 

Is there any update to this process? Its been awhile since anyone has posted anything about Umbraco/Azure it seems.

Any help would be great.

Owen

hi , 

 i could succesfully deploy Umbraco on Azure(Database on SQL Azure and Umbraco files wrapped in Azure web role).Although when I try to edit or add new content it is throwing NullReferenceException , both in development environment and on azure.

Kindly let me know if i am missing anything.

Object reference not set to an instance of an object.

Description: An unhandled exception occurred during the execution of the current web request. Please review the stack trace for more information about the error and where it originated in the code.

Exception Details: System.NullReferenceException: Object reference not set to an instance of an object.

Source Error:

An unhandled exception was generated during the execution of the current web request. Information regarding the origin and location of the exception can be identified using the exception stack trace below.

Stack Trace:

[NullReferenceException: Object reference not set to an instance of an object.] umbraco.editorControls.tinyMCE3.TinyMCE..ctor(IData Data, String Configuration) +457 [ArgumentException: Incorrect TinyMCE configuration. Parameter name: Configuration] umbraco.editorControls.tinyMCE3.TinyMCE..ctor(IData Data, String Configuration) +5936 umbraco.editorControls.tinyMCE3.tinyMCE3dataType.get_DataEditor() +123 umbraco.controls.ContentControl.addControlNew(Property p, TabPage tp, String Caption) +145 umbraco.controls.ContentControl.CreateChildControls() +834 System.Web.UI.Control.EnsureChildControls() +182 umbraco.controls.ContentControl.OnInit(EventArgs e) +123 System.Web.UI.Control.InitRecursive(Control namingContainer) +133 System.Web.UI.Control.AddedControl(Control control, Int32 index) +277 umbraco.cms.presentation.editContent.OnInit(EventArgs e) +1005 System.Web.UI.Control.InitRecursive(Control namingContainer) +133 System.Web.UI.Page.ProcessRequestMain(Boolean includeStagesBeforeAsyncPoint, Boolean includeStagesAfterAsyncPoint

Hi, 

I'm too having the problem with the TinyMCE, does anybody found a solution?

is working on a reply...