• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 459
  • Last Modified:

Best way to provide db components to end user to use my application


I would like to provide along with my application, a simple SQL Server database which would be easily installable, via an installer, on even a virgin machine. (1)How would that work? Right now I am looking at either using a SQL Server compact db or the SQL Server Express Local DB. More likely the Local DB option.

(2)Is there any better way of doing this?
(3)With the localDB option, once the end user runs the install for the localDB, what is the standard way of installing all the db objects needed for him to use the app?
(4)What are the local DBs limitations?

1 Solution
SQL Server compact (SQL Server CE) is embedded in the application, and is mobile-enabled. It is by far the easiest to implement, BUT has a size limit of 4GB compared to the 10 GB limit of SQL Express 2012, and has a limited feature set.

SQL Express also allows for stored procedures, views, and triggers. These are critical for most of my applications, so I've primarily used SQL Server Express for storing transactional data, and SQL Server CE for storing membership information for my application.

I'll typically including the .MDF file in my projects app_data folder, and then attach the file in the database connection string.

When implementing the solution, I have to make sure that the process identity (<hostname>\aspnet or >hostname\network service) has write access to the data applications folder of the project on the web server to avoid potential errors.

Other than that, the only requirement is that the host actually has SQL Server Express installed (not required with SQL Server Compact).

I don't have any experience to offer with localDB.
Jerry Nixon wrote a great article that evaluates the merits of each of these.


I would definitely recommend reading it.
rondotorugantiatgmaildotcomAuthor Commented:
Great! Decided to go with SqlLocalDb. Thanks.

Featured Post

Granular recovery for Microsoft Exchange

With Veeam Explorer for Microsoft Exchange you can choose the Exchange Servers and restore points you’re interested in, and Veeam Explorer will present the contents of those mailbox stores for browsing, searching and exporting.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now