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