which db should i use

Question

hey guys..i want to develop a windows application in C..it will be used in a network in the office with 6 or 7 clients maybe more in time...but the point is which db system should i use ? MSSql,MySql or Access.. i dont know their benefits or some features if they have like stored procedure or triggers or etc
so which one u suggest me to use ?

Mahesh Chand · Answer

I think you should either use SQL Server or MySQL. Access is not good for a client-server application on a network. While MySQL is complecated to use with non-friendly UI and lot of command line execution, IT IS FREE. SQL Server is very easy, with very friendly user interface but it will cost you. For development purpose, you can use a free (Express) version but for production, you or your client will need to spend money.

Erdinc Kolukisa · Answer

thanks man.. i think i will use Sql Server Express Edition...

Mahesh Chand · Answer

You can run all three (MySQL, SQL Server, and SQL Server Expression version) on same machine.

Erdinc Kolukisa · Answer

ok man...but does it chnge anything when i install sql express in that machine also...does it make any problem ?

Sam Hobbs · Answer

You did not say in your original question that MySQL was already installed and being used in the server. It really helps to include information such as that in the original question.

Erdinc Kolukisa · Answer

ok guys but i have one more question...if the server machine has Mysql server installed in it...does it mkae any problem if i install MsSql also ? because Mysql is insipensable for that machine ...

Sam Hobbs · Answer

When using Visual Studio, SQL Server is better in terms of integration with VS. So you on the right track of learning SQL Server for now. Later you can explore other possibilities but we can't learn everything all at once.

Erdinc Kolukisa · Answer

thanks guys for your help...i think i will work with Sql Express after your suggestions..actually i like it already :) i just wanted to learn new things but it seem i will postpone it for a while thanks again for your help

Erdinc Kolukisa · Answer

thanks guys for your help...i think i will work with Sql Express after your suggestions..actually i like it already :) i just wanted to learn new things but it seem i will postpone it for a while thanks again for your help

Gomathi Palaniswamy · Answer

Hi friend, SQL is good.

Mahesh Chand · Answer

I agree with Sam. Access is good for one user and on local machine only. So SQL Server Express.

Sam Hobbs · Answer

Access is not designed for use by multiple users at a time.