Which one should be used-MySql or SQL server express ?

Question

0.00/5 (No votes)

See more:

SQL

Which free database server is best to use for database connectivity with visual studio?

Posted 16-Mar-15 1:41am

Aparna24

Add a Solution

3 solutions

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

Abhinav S · Answer 1 · 2015-03-16T01:44:00

Solution 1

Check this out - SQL SERVER – Difference between SQL Server Express and MySQL[^].

Posted 16-Mar-15 1:44am

Abhinav S

Comments

Maciej Los 16-Mar-15 7:55am

+5

Abhinav S 16-Mar-15 9:43am

Thank you.

Aparna24 16-Mar-15 8:04am

Good stuff to differentiate the two..mysql and sql server express.

Abhinav S 16-Mar-15 9:43am

Thanks.

W∴ Balboos, *GHB* · Answer 2 · 2015-03-16T01:45:00

Solution 2

If your only concern is connectivity with visual studio, then consider that Micro$oft makes visual studio and Micro$oft makes SQL Express. It's there general (and understandable) business practice to make things much easier if you go with the flow they prefer (SQL Server).

MySQL, on the other hand, is a full-strength addition vs. SQL's somewhat cutdown state. Do you plan on scaling up?

Posted 16-Mar-15 1:45am

W∴ Balboos, GHB

Comments

Maciej Los 16-Mar-15 7:56am

+5

Aparna24 16-Mar-15 8:14am

@W Balboos-
I am developing a portal(web application)which needs dummy data to be created and used.For that I installed mysql.But it seems I need to work with mysql command prompt which I don't want.So need to know other option..

W∴ Balboos, GHB 16-Mar-15 8:23am

On several systems I have installed Vertrigo server - a "LAMP" server, meaning it includes, amongst other things, native MySQL. It has an interface for the MySQL access. The acronym stands for "Linux Apache MySQL PHP" - and so it can server as your portal, as well. Price for Vertrigo is Free.

That being said, I had to install the SQL drivers for php (free from Microsoft) as most of the servers with which I interact are MS SQL.

Finally, however, your question doesn't make sense in that you ask which to use and yet you seem to have already selected MySQL

Maciej Los · Answer 3 · 2015-03-16T02:06:00

Both databases are good from the point of view defined as: "best to use for database connectivity with visual studio", because .NET framework provides a way to connect to almost every database. See: .NET Framework Data Providers[^] and ADO.NET Data Providers[^]

I'd suggest to move your focus to the model of data and sql server features, then you'll be able to solve your issue. Till that moment, each answer must be treated as a preference (opinion based on practice) than anything else.