Showing posts with label Azure. Show all posts
Showing posts with label Azure. Show all posts

Wednesday, April 24, 2013

Azure


Steve Sanderson gave fabulous presentation on Single Page Applications at TechDays.  Bart Jolling shows how to publish this application to Azure.
I was able to get the Delivery Tracker demo working on Azure after a few tweaks.  I've outlined the details below.  I believe the main problem was that the database gets created on the fly in code.  The Azure version never creates a database and this may be due to the "cluster index" on primary key issue.  Azure SQL requires a "cluster index" and the Delivery Tracker doesn't create one.
Issues to overcome:
  • System.Net.Http version problem on my development system
  • Get code working locally on the development system
  • Preparation on Azure - create empty web site with database
  • Change the Firewall settings on Azure to allow MMSM access
  • Database is created in code, which did not work on Azure
  • Connect to the Azure database in MMSM using server name and user account
  • Export database from development to Azure will fail with Cluster Index error
  • Primary Key needs a Cluster Index for Azure using MMSM script
  • Download the proper publishing profile after all this is done
  • Use "Publish to Azure"  in Visual Studio and load Azure profile

Tuesday, August 28, 2012