Free database with simple deployment?

[Preben Zacho]

I'm developing a small app and need a database for storing data on the fly.
I've looked a little into SQL Server 2005 Express Edition and it seems to be
working fine. I've added it to the prerequisites and performed a publish.
However, when I try to deploy it to a XP/Vista system I get all kinds of
problems. Before I look any further into this, I have a few questions about
deploying and using databases like this one:

1 - Any link to a webpage where I can find a step-by-step description on how
to deploy/publish a stand-alone application so it works?
2 - Is there any other, real simple database that can be recommended? It
should be easy to use and easy to deploy?

Regards

PZ

 

[Mark Rae]

2 - Is there any other, real simple database that can be recommended? It
should be easy to use and easy to deploy?

http://www.microsoft.com/sql/editions/compact/default.mspx

 

[Jiri Sitina]

I'm developing a small app and need a database for storing data on the fly.
I've looked a little into SQL Server 2005 Express Edition and it seems to be
working fine. I've added it to the prerequisites and performed a publish.
However, when I try to deploy it to a XP/Vista system I get all kinds of
problems. Before I look any further into this, I have a few questions about
deploying and using databases like this one:

1 - Any link to a webpage where I can find a step-by-step description on how
to deploy/publish a stand-alone application so it works?
2 - Is there any other, real simple database that can be recommended? It
should be easy to use and easy to deploy?

Regards

PZ

I would recommend Firebird database, which also allows embedded
version - it does not need any database installation on client host
and provides almost full set of sql features. Its licence is very
pleasant as well.

http://www.firebirdsql.org/

Jiri Sitina

 

[Guest]

http://sqlite.phxsoftware.com/

 

[Ignacio Machin \( .NET/ C# MVP \)]

Hi,

What kind of problems are you encountering with SQL Express?

 

[tomisarobot]

sqlite isn't as fully featured as firebird, etc, but if your
requirements are minimal its very usable.