<<How to install nopCommerce on Azure with (Azure's) Sql Database (not SQLServer Compact) >>
[Make SQL Database]
1. Sign in Azure portal.
http://manage.windowsazure.com/
2. Create SQL Databse by clicking [+NEW] -- [SQL DATABASE] -- [QUICK CREATE] and input your database name.
3. After creation, click "SQL DATABASES" menu in the left panel and click your database name.
4. Click "Show connection strings" and copy the connection string.
[Installing nopCommerce]
1. In a browser of the local machine, navigate Azure URL (http://xxxxx.cloudapp.net)/install
2. In the first installation page of nopCommerce, select SQLServer (not SQLServer Compact).
3. Paste the connection string mentioned above.
4. Get started installation.
5. Installation will be completed. It will take much time.
[Actual nopCommerce running on Azure with Sql Database]
The following is an actual nopCommerce on Azure with Sql Database.
http://www.digipubrank.net/
I feel that it is a little slower than SQLServer Compact.
How to install nopCommerce on Azure
- 399
- 2377
- 5/17/2012
- United States
infiniti wrote:
I managed to do this with nopCommerce 2.70.
It was not that hard. The hardest part was trying to figure how to use the ftp from my computer to the azure website.
I do want to use a database that I have created on my computer with all of the settings that I need. I will figure that out next.
Update: Installing an existing database was not that hard either. I used this to do it: http://sqlazuremw.codeplex.com/
Thanks for this information.
Tony
Ohtsu,
I don't think this is a website hosted on Azure. Its just a VM hosted on Azure on which you installed nopC. Its not even on SQL Server its on SQL Compact. That is why there are issues as VMs are naturally resource hungry and you are running a whole OS just to run a website.
Azure is much more than that. Unless a website is hosted in Azure fabric you can't leverage the true power of Azure.
To install nopC on Azure don't use the VM role, there is a separate website role for this. I have installed an instance of nopC on Azure and its extremely fast although I have given it the minimum compute time and resources.
I am pretty much impressed with Azure and hope that nopC Team will consider it in v2.7 (although MULTI STORE is more important :)... ). There are many out-of-the-box websites in the gallery and it would be very nice to see nopCommerce also in the gallery. It will be a very good marketing opprtunity for our community.
The website is hosted at http://nopc.azurewebsites.net/
The best thing is that its absolutely free for upto 10 websites and certain other storage and traffic constratints. You can see the details at http://www.windowsazure.com/en-us/pricing/details/
If you need any help about creating the website please do let me know.
I don't think this is a website hosted on Azure. Its just a VM hosted on Azure on which you installed nopC. Its not even on SQL Server its on SQL Compact. That is why there are issues as VMs are naturally resource hungry and you are running a whole OS just to run a website.
Azure is much more than that. Unless a website is hosted in Azure fabric you can't leverage the true power of Azure.
To install nopC on Azure don't use the VM role, there is a separate website role for this. I have installed an instance of nopC on Azure and its extremely fast although I have given it the minimum compute time and resources.
I am pretty much impressed with Azure and hope that nopC Team will consider it in v2.7 (although MULTI STORE is more important :)... ). There are many out-of-the-box websites in the gallery and it would be very nice to see nopCommerce also in the gallery. It will be a very good marketing opprtunity for our community.
The website is hosted at http://nopc.azurewebsites.net/
The best thing is that its absolutely free for upto 10 websites and certain other storage and traffic constratints. You can see the details at http://www.windowsazure.com/en-us/pricing/details/
If you need any help about creating the website please do let me know.
I managed to do this with nopCommerce 2.70.
It was not that hard. The hardest part was trying to figure how to use the ftp from my computer to the azure website.
I do want to use a database that I have created on my computer with all of the settings that I need. I will figure that out next.
Update: Installing an existing database was not that hard either. I used this to do it: http://sqlazuremw.codeplex.com/
Thanks for this information.
Tony
Team Member
- 16618
- 155935
- 10/22/2008
- Armenia
Just in case if someone is interested, now when Azure Web Sites are available it became very easy to install nopCommerce in Azure:
1. Create a web site and database in Azure management portal
2. Upload nopCommerce package to Azure via FTP (details are available on web site details page in Azure portal). Important: do not use a deployment profile because nopCommerce cannot be deployed from VS.
3. Install it
So the steps are absolutely the same as on any other hosting.
P.S. The package for installing nopCommerce from WebSites portal gallery will be available very soon (so no FTP upload will be required)
P.P.S. Currently only one instance is supported
1. Create a web site and database in Azure management portal
2. Upload nopCommerce package to Azure via FTP (details are available on web site details page in Azure portal). Important: do not use a deployment profile because nopCommerce cannot be deployed from VS.
3. Install it
So the steps are absolutely the same as on any other hosting.
P.S. The package for installing nopCommerce from WebSites portal gallery will be available very soon (so no FTP upload will be required)
P.P.S. Currently only one instance is supported
- 2
- 10
- 10/24/2012
- Spain
Hi,
First of all. Thanks AM for your reply. It's very interesting to know that you are working with Azure in mind! 8·)
So, I have a question. For what you say I assume that all SQL querys used in nopCommerce are compatible with AzureSQL.
But what about the file system? Does nopCommerce use the file system to store something? (Image files, for example?) If so, how is that addressed? Is it possible to write to the file system from within a Azure website without loosing the changes after some restart? (it happens with Azure WebRoles).
Thank you in advance for your help!
luis
First of all. Thanks AM for your reply. It's very interesting to know that you are working with Azure in mind! 8·)
So, I have a question. For what you say I assume that all SQL querys used in nopCommerce are compatible with AzureSQL.
But what about the file system? Does nopCommerce use the file system to store something? (Image files, for example?) If so, how is that addressed? Is it possible to write to the file system from within a Azure website without loosing the changes after some restart? (it happens with Azure WebRoles).
Thank you in advance for your help!
luis
- 38
- 553
- 1/4/2011
- United States
Some inputs from a real user of Azure:
I tested pocomaru.com on Azure for about 2 month, and finally decide to move away from it. The reasons for that are:
1. In my opinion, Azure is mainly for scalability. At this stage, our website do not have that scalability requirement.
2. DO NOT expect Azure to boot your website performance, because it wont. I rented two nodes, each one has 8 core, and 8G memory. It's faster, but didn't meet my expectation at all.
3. Expensive. remember once you use the VM, even you do not use it at all, you will still be charged. I didn't notice this until one day our account manager told me that we had an extra 300$ charge per month for 3 months!!! and this happens after I moved away from azure.
4. Storage speed is horrible. Since you asked about file system, I used Azure blob storage. Reading every thing(mainly pictures) from blog is horrible. (maybe i did something wrong)
Hope that helps.
lwalker wrote:
I tested pocomaru.com on Azure for about 2 month, and finally decide to move away from it. The reasons for that are:
1. In my opinion, Azure is mainly for scalability. At this stage, our website do not have that scalability requirement.
2. DO NOT expect Azure to boot your website performance, because it wont. I rented two nodes, each one has 8 core, and 8G memory. It's faster, but didn't meet my expectation at all.
3. Expensive. remember once you use the VM, even you do not use it at all, you will still be charged. I didn't notice this until one day our account manager told me that we had an extra 300$ charge per month for 3 months!!! and this happens after I moved away from azure.
4. Storage speed is horrible. Since you asked about file system, I used Azure blob storage. Reading every thing(mainly pictures) from blog is horrible. (maybe i did something wrong)
Hope that helps.
lwalker wrote:
Hi,
First of all. Thanks AM for your reply. It's very interesting to know that you are working with Azure in mind! 8·)
So, I have a question. For what you say I assume that all SQL querys used in nopCommerce are compatible with AzureSQL.
But what about the file system? Does nopCommerce use the file system to store something? (Image files, for example?) If so, how is that addressed? Is it possible to write to the file system from within a Azure website without loosing the changes after some restart? (it happens with Azure WebRoles).
Thank you in advance for your help!
luis
First of all. Thanks AM for your reply. It's very interesting to know that you are working with Azure in mind! 8·)
So, I have a question. For what you say I assume that all SQL querys used in nopCommerce are compatible with AzureSQL.
But what about the file system? Does nopCommerce use the file system to store something? (Image files, for example?) If so, how is that addressed? Is it possible to write to the file system from within a Azure website without loosing the changes after some restart? (it happens with Azure WebRoles).
Thank you in advance for your help!
luis
- 275
- 2987
- 10/4/2011
- Pakistan
I also started using Azure and I totally agree with cynosureabu as I also moved away from it soon due to the above reasons. Secondly it lacks a lot of features required primarily for websites such as easy configuration of sub-domains and mailing addresses to name a few. It maybe good for application hosting on the cloud but not for website hosting as things get over complicated without any benefits and higher charges too.
- 5
- 35
- 12/19/2012
- Australia
Why nopcommerce hosted site in Windows Azure Hosting is too slow?. Is it any performance problem with nopcommerce or Azure. I hosted few sites with azure and not any issue.
With Azure lot of advantages like sql datasync etc.
I hope nopcommerce team will look in to the azure hosting seriously.
Regards
Rama
With Azure lot of advantages like sql datasync etc.
I hope nopcommerce team will look in to the azure hosting seriously.
Regards
Rama