New to mysql requirements

Question

0.00/5 (No votes)

See more:

I'm new to mysql databases ,i worked on microsoft sql server for long time but in ms sql server the free database is limited to 10GB, and i working now on a project of a hospital that needs to save the data up to (10) years for example. and i heard that mysql is unlimited or at least reaches a 2TB free database size and more. first question: is that true? i want a direct answer please, what is the maximum of mysql database size(free) that used by a c# WinFormsApp? second: in ms sql server i need to setup the sqlserver express and sql server management studio(database design environment) and setup sqlserver express only on the client pc. what about mysql? what i need to setup on developer pc and what to setup on the clients pc?

What I have tried:

when i searched for mysql i found a lot of titles that made me lost, download Mysql installer, download Mysql server, download Mysql workbench, download Mysql Connectors. i want to know what exactly i need to download on the developer pc(my pc) and what to install on the client pc to run my program for example when i setup my application on the hospital PCs, what is the database requirements or engines that must be installed?

Posted 4-Jan-18 14:33pm

XRushdy

Updated 5-Jan-18 2:57am

PIEBALDconsult

Add a Solution

4 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)

Maciej Los · Answer 1 · 2018-01-04T23:34:00

Seems, you answered your first question...
A comparision of MySql Server and MS Sql Server is here: Microsoft SQL Server vs. MySQL Comparison[^]
Ranking:

Rank	DBMS			Database Model		Score
1.		Oracle 			Relational DBMS		1341.94	
2.		MySQL 			Relational DBMS		1299.71	
3.		MS SQL Server 	Relational DBMS		1148.07

As to the others...

Quote:
i want to know what exactly i need to download on the developer pc(my pc) and what to install on the client pc to run my program

1. MySQL Server[^]
2. one of MySQL connectors[^]

Quote:
what is the database requirements or engines that must be installed?

The same as above, but MySQL server should be installed once and connector with your standalone executable application on every workstation (client).

Richard MacCutchan · Answer 2 · 2018-01-04T23:11:00

Solution 1

If this is a real hospital then they need to pay for a proper robust and supported database system. Microsoft SQL server would be a much better choice. And get together with an experienced database designer to help you.

Posted 4-Jan-18 23:11pm

Richard MacCutchan

markkuk · Answer 3 · 2018-01-05T02:07:00

Quote:
i want a direct answer please, what is the maximum of mysql database size(free) that used by a c# WinFormsApp?

According to MySQL 5.7 Reference Manual Appendix C.10[^],

Quote:
The effective maximum table size for MySQL databases is usually determined by operating system constraints on file sizes, not by MySQL internal limits.

This means that a single table can be up to 256TB in size on Windows 8 or later, the total size of a database is only limited by disk capacity.

A_Griffin · Answer 4 · 2018-01-05T02:57:00

Solution 4

You might want to look at HeidiSQL[^] for a GUI management tool for MySQL.

Posted 5-Jan-18 2:57am

A_Griffin

New to mysql requirements

4 solutions

Solution 2

Solution 1

Solution 3

Solution 4

Add your solution here

Preview 0