Oct 23, 2012 at 12:14 AM
Edited Oct 23, 2012 at 1:18 AM
Thanks for the quick answer. Will do.
And I did. And now I remember how I got in this pickle in the first place and it may be instructive for someone else (I took screen shots of each of these in case we might want to use them in documentation).
1. On the Azure WebSite dashboard select the "WebMatrix" button.
2. Web Matrix fires up and and copies the azure web-site files to your local system.
3. You get the "Orchard CMS - we need to install dependencies before downloading the files and database your site might need to run locally". Select "continue".
4. Accept the Orchard Eula.
5. The "Configure Site" message is displayed.
6. And then you get the "Install Failed. Here's what we couldn't install: The database 'vpcms591' could not be created." My azure sql database is named "vpcms" so I assumed it decided that my local
copy should be named "vpcms591".
7. Click "OK". You now have a local copy of your web-site which will run just fine. The settings file has the Data Connection string pointing to the remote SQL azure database. Now both the local and Remote websites
are using the same database.
I mistakenly thought it would be OK to run like this (wishful thinking).
The question is, what do I do to fix it? Can I just:
1. create an empty database on my local SQL Server
2. Change the connection string in the App_Data/Sites/Default/Settings.txt file (in my local copy) to point to the new local database. (This is what I was afraid to do because I got the message "You are about to modify
or remove a core application file or folder. Making this change could cause the application to stop working" and since everything was working I thought it best to leave well enough alone)
3. Then start the site in Web Matrix where I assume it will give me the Orchard start up screen (and I will specify that my new empty local database is to be used)
4. Import my data from the SQL azure database into the local database using the import/export module.