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
No comments:
Post a Comment