Advice on databases

[Ann Marinas]

Hello All!

I need to seek your advice on databases.

I was wondering if you guys have any suggestions on a databases that is
lighter than SQL Server but much more efficient than MS Access.

I am currently designing a C# program that would be deployed on computers
that have no SQL Server nor MS Access installed and is not connected to a
network.

Thank you so much and have a Happy New Year! :D

Ann

[William Ryan]

So each app is a stand alone island and won't need to change in the
forseeable future? SQL Server MSDE is a great database, gives you most of
the bang of it's big brother, but it's free and a heck of a lot better than
access for too many reasons to list. If you can't do this though... I'd use
XML, it's very easy and you can serialize your DataSets using
DataSet.WriteXML(fileName) and deserialize it with DataSet.ReadXML(filename)

You can set the diffgram option as well so you can maintain state.
Howeever, I hope that you aren't going to have a huge number of records and
are sure these files won't need to talk to each other in a few months b/c if
you are, you'll probably need a central repository and a mechanism for
concurrency which is doable with a ton of xml files, but it probably won't
be much fun.

HTH,

Bill
"Ann Marinas" <an*********@xtra.co.nz> wrote in message
news:uR**************@TK2MSFTNGP11.phx.gbl...

Hello All!

I need to seek your advice on databases.

I was wondering if you guys have any suggestions on a databases that is
lighter than SQL Server but much more efficient than MS Access.

I am currently designing a C# program that would be deployed on computers
that have no SQL Server nor MS Access installed and is not connected to a
network.

Thank you so much and have a Happy New Year! :D

Ann

[Ann Marinas]

Thank you so much for the advice. I really do appreciate it! :)

"William Ryan" <do********@nospam.comcast.net> wrote in message
news:OQ*************@tk2msftngp13.phx.gbl...

So each app is a stand alone island and won't need to change in the
forseeable future? SQL Server MSDE is a great database, gives you most of the bang of it's big brother, but it's free and a heck of a lot better than access for too many reasons to list. If you can't do this though... I'd use XML, it's very easy and you can serialize your DataSets using
DataSet.WriteXML(fileName) and deserialize it with DataSet.ReadXML(filename)
You can set the diffgram option as well so you can maintain state.
Howeever, I hope that you aren't going to have a huge number of records and are sure these files won't need to talk to each other in a few months b/c if you are, you'll probably need a central repository and a mechanism for
concurrency which is doable with a ton of xml files, but it probably won't
be much fun.

HTH,

Bill
"Ann Marinas" <an*********@xtra.co.nz> wrote in message
news:uR**************@TK2MSFTNGP11.phx.gbl...

Hello All!

I need to seek your advice on databases.

I was wondering if you guys have any suggestions on a databases that is
lighter than SQL Server but much more efficient than MS Access.

I am currently designing a C# program that would be deployed on computers that have no SQL Server nor MS Access installed and is not connected to a network.

Thank you so much and have a Happy New Year! :D

Ann

[William Ryan]

My pleasure
"Ann Marinas" <an*********@xtra.co.nz> wrote in message
news:%2****************@TK2MSFTNGP11.phx.gbl...

Thank you so much for the advice. I really do appreciate it! :)

"William Ryan" <do********@nospam.comcast.net> wrote in message
news:OQ*************@tk2msftngp13.phx.gbl...

So each app is a stand alone island and won't need to change in the
forseeable future? SQL Server MSDE is a great database, gives you most of

the bang of it's big brother, but it's free and a heck of a lot better

than

access for too many reasons to list. If you can't do this though... I'd

use

XML, it's very easy and you can serialize your DataSets using
DataSet.WriteXML(fileName) and deserialize it with

DataSet.ReadXML(filename)

You can set the diffgram option as well so you can maintain state.
Howeever, I hope that you aren't going to have a huge number of records

and

are sure these files won't need to talk to each other in a few months b/c if

you are, you'll probably need a central repository and a mechanism for
concurrency which is doable with a ton of xml files, but it probably won't be much fun.

HTH,

Bill
"Ann Marinas" <an*********@xtra.co.nz> wrote in message
news:uR**************@TK2MSFTNGP11.phx.gbl...

Hello All!

I need to seek your advice on databases.

I was wondering if you guys have any suggestions on a databases that is lighter than SQL Server but much more efficient than MS Access.

I am currently designing a C# program that would be deployed on

computers that have no SQL Server nor MS Access installed and is not connected

to a network.

Thank you so much and have a Happy New Year! :D

Ann

[Miha Markic]

Hi Ann,

In addition to William:
You might consider Firebird
http://firebird.sourceforge.net/

It is an open source free database.
It has a .net managed provider.
And soon .net provider will support embedded database (no *installation*,
only few dlls).

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com
www.rhand.com

"Ann Marinas" <an*********@xtra.co.nz> wrote in message
news:uR**************@TK2MSFTNGP11.phx.gbl...

Hello All!

I need to seek your advice on databases.

I was wondering if you guys have any suggestions on a databases that is
lighter than SQL Server but much more efficient than MS Access.

I am currently designing a C# program that would be deployed on computers
that have no SQL Server nor MS Access installed and is not connected to a
network.

Thank you so much and have a Happy New Year! :D

Ann

[Ann Marinas]

Thank you Miha!

I'll check it out.

Really do appreciate it and God Bless! :)

Ann

"Miha Markic" <miha at rthand com> wrote in message
news:%2****************@TK2MSFTNGP12.phx.gbl...

Hi Ann,

In addition to William:
You might consider Firebird
http://firebird.sourceforge.net/

It is an open source free database.
It has a .net managed provider.
And soon .net provider will support embedded database (no *installation*,
only few dlls).

--
Miha Markic - RightHand .NET consulting & development
miha at rthand com
www.rhand.com

"Ann Marinas" <an*********@xtra.co.nz> wrote in message
news:uR**************@TK2MSFTNGP11.phx.gbl...

Hello All!

I need to seek your advice on databases.

I was wondering if you guys have any suggestions on a databases that is
lighter than SQL Server but much more efficient than MS Access.

I am currently designing a C# program that would be deployed on computers that have no SQL Server nor MS Access installed and is not connected to a network.

Thank you so much and have a Happy New Year! :D

Ann

[Schooner]

What issues are you having with Access? It is typically fine in a
standalone single user environment such as this and there is no requirement
for the system to have a copy of MS Access installed in order to access the
DB from your application.

"Ann Marinas" <an*********@xtra.co.nz> wrote in message
news:uR**************@TK2MSFTNGP11.phx.gbl...

Hello All!

I need to seek your advice on databases.

I was wondering if you guys have any suggestions on a databases that is
lighter than SQL Server but much more efficient than MS Access.

I am currently designing a C# program that would be deployed on computers
that have no SQL Server nor MS Access installed and is not connected to a
network.

Thank you so much and have a Happy New Year! :D

Ann

[Ann Marinas]

Hi, Schooner!

Thank you for your response.

I agree that MS Access is very fine in a stand-alone environment. But then
again, there are some features in my application that I need to implement.
For instance, migrating from a stand-alone application to a network
application (like Mr. William Ryan suggested). I need to anticipate change
in the future, and I think that MS SQL MSDE is the only way to go.

Once again, thank you for your response. I really do appreciate it!

God Bless!

Ann :)

"Schooner" <sc******@accesswave.ca> wrote in message
news:hD**********************@nnrp1.uunet.ca...

What issues are you having with Access? It is typically fine in a
standalone single user environment such as this and there is no requirement for the system to have a copy of MS Access installed in order to access the DB from your application.

"Ann Marinas" <an*********@xtra.co.nz> wrote in message
news:uR**************@TK2MSFTNGP11.phx.gbl...

Hello All!

I need to seek your advice on databases.

I was wondering if you guys have any suggestions on a databases that is
lighter than SQL Server but much more efficient than MS Access.

I am currently designing a C# program that would be deployed on computers that have no SQL Server nor MS Access installed and is not connected to a network.

Thank you so much and have a Happy New Year! :D

Ann