final year project - which database?

[laura301019]

Hi, I am starting my final year project and was looking for some advice on what more experienced coders think the best database for me to use would be?

On placement I was using visual studio to code and sql server for stored procs, is this the best way for me to continue? And this may sound stupid but can I use sql server on my own laptop when I don't have a server to access?

I also used MySQL in second year at university so have experience with it to. Any advice that anyone could give me would be great

Thanks in advance

[JorgeM]

I was using visual studio to code and sql server for stored procs, is this the best way for me to continue?

If you are using visual studio, a natural choice for the db is MS SQL server mainly because of the integration. there's nothing you need to do with regard to referencing external DLLs, assemblies, etc..

And this may sound stupid but can I use sql server on my own laptop when I don't have a server to access?

Its a valide question. Yes, you can download and install a free version of SQL server (express edition) and run it locally on your laptop.

I also used MySQL in second year at university so have experience with it to. Any advice that anyone could give me would be great

Also a great choice for a db. To integrate with your .net projects, you simply need to download the DLLs from the MySQL site and integrate with your projects.

[IIM]

best database for me to use would be?

This is an interesting question.If would like to reiterate that i always do-"It all depends upon your need".
If you wish to use it with microsoft products like .NET ,C# than SQL Server will be more http://www.microsoft.com/en-in/sqlserver/product-info/competitor-compare.aspx refer this.

But if you want to use open source RDMS then you can go for MySQL.

http://www.dba-oracle.com/t_cost_sql_server_vs_oracle.htm and http://www.oracle.com/us/products/enterprise-manager/db-cost-comp-study-1428473.pdf even this may help you in this respect