Search code examples
.netsql-server-expresslocal-database

Single User single computer app : Local database vs. database on a sql express

I'm building an application for a client, single user single computer only.

If I use a local database, I want to know if a client would need to install SQL 2008 express edition to run the application? Where is the local DB located (for backup purposes) if this was published as a click once application? (OR) Would it be better if I moved the DB over to the SQL Express and wired the application to use the data from the DB on express.

All your help is appreciated in advance.

Solution

  • Since you will be using one user database locally I would suggest that you consider integrating it in your application and use databases like SQL Server compact or SQLite (it has a .NET library that you can download and use and it's pretty fast and compact).