Certainly if you ask me what is the better, using Microsoft SQL server or MySQL server as a data base to store your application data, I say, of Corse, Microsoft SQL server as it offers more features and demonstrates less number of bugs and problems within a .Net context.
In the bellow paragraph, I try to compare the two products:
Disponibility in the market according to my region (Tunisia):
Microsoft SQL server is less offered by the hosting server machines as they almost use Linux and Unix platforms , moreover, even if they make use of windows server platform MySQL server is more present than Microsoft SQL server. It is rare to find a hosting server machine that offers Microsoft SQL server as a front end data base, and even if you find one, it is more expensive than the equivalent running MySQL server.
The best choice if you are .Net developer is SQL server, it demonstrates the best performance, easy to establish connection, secure and stable. In addition it offers good security features.In the other hand, it is more difficult to connect to MySQL data base, the best and the only way is to use ODBC the 3.51 ODBC connector and the rest, I mean OLEDB connectors, the recent ODBC connectors versions and event the others tools represent a lot of bugs and they are not stables.
Finally, there are several ways to connect to Microsoft SQL server data base. The .Net environment provides special libraries to deal only with SQL server connections. Moreover, you can make use of ODBC and even OLEDB for the older Microsoft SQL server versions. For me SQL server is the best solution
even if MySQL is more present as a data base server solution.
|
| Author: Vidhya 29 Jul 2008 | Member Level: Gold Points : 1 |
hi,
thanks for ur knowledge.
now only i see these differences.
thanks a lot,
regards,
Vidhya
|