What database can I use that does not need an application to be installed

Question

Hi I am creating a windows application and I need to select a database. I dont want to go out and install sql server express for every person who uses my application.

What database can I use that does not need an application to be installed. I would like to have a database for each customer that is stored locally.

possible duplicate of [Free portable database](http://stackoverflow.com/questions/557632/free-portable-database) — Oskar Kjellin, Aug 09 '11 at 09:22

score 1 · Answer 1 · answered Aug 09 '11 at 08:52

1

It would depend on what you wanted to use it for, if you just want one database for each user then I would look at using SQLite

If you need one database for every user that SQL server installed on a remote server would be ideal

answered Aug 09 '11 at 08:52

Mike Norgate

2,393
3
24
45

score 1 · Answer 2 · answered Aug 09 '11 at 08:53

1

SQLite rocks in these scenarios.

answered Aug 09 '11 at 08:53

Anton Gogolev

113,561
39
200
288

Francesco Baruchelli · Accepted Answer · 2011-08-09T09:02:30.913

1

I use SQLite (http://www.sqlite.org/). It's free and you just have to distribute a dll It allows you to manage up to 14 terabytes sized DBs (http://www.sqlite.org/limits.html)

edited Aug 09 '11 at 09:02

answered Aug 09 '11 at 08:53

Francesco Baruchelli

7,320
2
32
40

I would use something like this. – Bojan Bjelic Aug 09 '11 at 08:55

Pranay Rana · Answer 4 · 2011-08-09T09:29:16.263

1

I think its better to use : SQL Light database might resolve your problem.

Limits In SQLite

edited Aug 09 '11 at 09:29

answered Aug 09 '11 at 08:53

Pranay Rana

175,020
35
237
263

what is the max size of a sql lite and can I use petapoco? – David Aug 09 '11 at 08:56
@user351709 - have look to this for limits http://www.sqlite.org/limits.html or click on second link of my answer – Pranay Rana Aug 09 '11 at 09:29

score 1 · Answer 5 · answered Aug 09 '11 at 08:55

1

Use either SQLite or SQL Server Compact Edition

answered Aug 09 '11 at 08:55

Ranhiru Jude Cooray

19,542
20
83
128

I'm not sure about SQL Lite, but for distribution, you can just xcopy the SQL server CE over during an install. can't get easier than that. However, there are some restrictions (no stored procedures, i think). It is also integrated nicely into visual studio, if thats your bag. – rigamonk Aug 10 '11 at 21:12

score 1 · Answer 6 · answered Aug 09 '11 at 08:57

1

I'd think of using SQLite. It is serverless and requires no preconfiguration on the users part. Each database is simply kept as a single file. Read this SQLite

answered Aug 09 '11 at 08:57

Thomas

41
5

What database can I use that does not need an application to be installed

6 Answers6