which db should i use

Sign in to answer this question.

• 

  Mahesh Chand16y agoPosted Sep 30, 2010, 12:04 PM

  Accepted 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.
   
• EK

  Erdinc Kolukisa16y agoPosted Oct 1, 2010, 10:25 AM

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

  Mahesh Chand16y agoPosted Oct 1, 2010, 10:18 AM

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

  Erdinc Kolukisa16y agoPosted Oct 1, 2010, 8:36 AM

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

  Sam Hobbs16y agoPosted Oct 1, 2010, 3:35 AM

  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.
  
• EK

  Erdinc Kolukisa16y agoPosted Oct 1, 2010, 3:17 AM

  
  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 Hobbs16y agoPosted Oct 1, 2010, 3:03 AM

  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.
  
• EK

  Erdinc Kolukisa16y agoPosted Oct 1, 2010, 2:47 AM

  
  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
• EK

  Erdinc Kolukisa16y agoPosted Oct 1, 2010, 2:47 AM

  
  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 Palaniswamy16y agoPosted Oct 1, 2010, 2:29 AM

  Hi friend,
  SQL is good.
• 

  Mahesh Chand16y agoPosted Sep 30, 2010, 9:16 PM

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

  Sam Hobbs16y agoPosted Sep 30, 2010, 6:57 PM

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