SQL Server Express for ASP.NET Intranet? -
We are looking to create a custom ASP.NET application for the customer, though they are a non-profit and Just like the budget is limited.
ASP.NET Web and Desktop Apps are usually developed to connect to a central SQL Server 200X database, meaning that the full version of SQL Server is running on a networked Windows server. In this case we will not have a full version available.
Is there any problem in using SQL Server Express in this type of system? IIS and SQL Server Express will run on the same physical server, to serve users on local intranet pages.
Any real difference should be known regarding the development of the app or about deployment? This would be a fairly standard app, as well as SQL is used primarily for datastore with table and SP, except that SQL Server is not really specific.
The SQL Server Express version should be corrected for this scenario, but it has all the main features of the full product, but As you said that you are only actually using it for data collection and some SP, you will not need additional functionality (i.e. reporting and analysis services) available in other versions. There are some limitations for the express edition (the largest database size is 4 GB), but they should not actually affect you unless you are creating a very busy ASP.NET application.
Some public-facing websites, SQL Server Express is used as a database server (DotNatakTax can be remembered only at the same time) without any problem.
Comments
Post a Comment