Choice of Database?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

I am planning to develop a simple CRM (Customer Relationship Management)
tool in Visual C# .NET but I am not sure whether I should use MS Access or MS
SQL Server. The interaction with database would be very straightforward.

I personally prefer SQL Server because I am familiar with it and I think it
works easily with .NET. But I'm not sure about Access.

Also, I'm not sure if SQL Server will be good for users. If I use SQL Server
what would a user need to be able to make use of the application? Do they
need to have the client version of SQL Server or is there a less costly and
easier way to deal with this issue?

Any comment would be appreciated.
 
Nad said:
I am planning to develop a simple CRM (Customer Relationship Management)
tool in Visual C# .NET but I am not sure whether I should use MS Access or MS
SQL Server. The interaction with database would be very straightforward.

I personally prefer SQL Server because I am familiar with it and I think it
works easily with .NET. But I'm not sure about Access.

Also, I'm not sure if SQL Server will be good for users. If I use SQL Server
what would a user need to be able to make use of the application? Do they
need to have the client version of SQL Server or is there a less costly and
easier way to deal with this issue?

Any comment would be appreciated.
Click to expand...

Have a look at MSDE - it's basically a free version of the SQL Server
engine with a few limitations (such as the database not growing beyond
2GB, IIRC). It's designed to be bundled with applications. You use the
normal SQL Server drivers, so you could offer your customers the choice
of using MSDE or a "real" SQL Server they already have - that means
they can use a corporate database with all the backup etc in place if
they want.

See http://www.microsoft.com/sql/msde/default.asp for more information.
 
Thanks Jon,

Good idea! Would I be able to include that in my install program and have it
installed automatically?
 
I'm not quite clearon install/deployment issue of MSDE.
It looks like a trap (like, yeah, you could embed it, it's just you have
this 50MB insatll to do first..)

Try out these 2:
http://www.sqlite.org
http://firebird.sourceforge.net/

I personally prefer the former, but the later is biger (2MB instead of
270Kb), a tad slower and with more stuff (such as stored procedure, missing
in SQLite)
 
Nad said:
Good idea! Would I be able to include that in my install program and have it
installed automatically?
Click to expand...

Absolutely. As Lloyd mentions, it does mean your installer will be a
lot bigger than it would be otherwise, but whether or not that's an
issue for you will entirely depend on your customer base and your
normal distribution channel.
 
Thanks Lloyd for your reply,

These are great links. But I want to sell my little product ultimately; are
these tools reliable and do they work with ADO.NET?
 
Thanks Lloyd for your reply,
These are great links. But I want to sell my little product ultimately;
are
these tools reliable and do they work with ADO.NET?
Click to expand...

yes to both question.
what do you expect?
 
Back
Top