![]() ![]() "For smaller companies, they find this solution expensive."."There is no licensing cost for SQL Server."."There is a license required for this solution."."We have an enterprise license, which we consider to be fine.".For using this technique we are happy with it." "In the next release, I would like to see a better user interface and a familiar syntax." "Although I am satisfied with the solution, some clients have asked us to resolve technical issues, such as those involving silver solution and replication." We then do not have any bottleneck in scaling. ![]() We scale a system up to a certain level, and then we move or shift data to the warehouse, which is NoSQL. If your system is very big, you need bigger servers and you have to spend more money. There could be more support to PHP-based websites and to providing direct plugins for connections, and the related services or application services could be improved." "Since this is a relational order system, scalability has a limit. The performance should be improved in the future to allow more scalability." "Performance could be improved. If somebody wants to store more than 10 TB of data querying then the performance really degrades. However, people do use SQL Server for data warehouse environments but the best use case is for very small databases. The licensing costs are high." "SQL is a highly unstable server - there are patch updates on the Windows server every week, which is why we only use it for non-critical systems." "I do not think SQL Server is suited for a typical database warehouse environment. "The treatment of database storage could be improved." "The solution is expensive. So, that's the bit that is lacking on the MySQL open-source platform." I haven't had any particularly difficult issues to troubleshoot on MySQL, but in the past, on Microsoft SQL Server, I had to troubleshoot some difficult issues, and better tools were in place to see what was going on in real-time on the server. It does break down a little at times." "When I run into issues, I really have to research how to fix them." "The availability of tools could be improved in the MySQL open-source platform. On the other hand, others may suggest incorporating a feature that allows for easier visualization of the data, such as what is available in Power BI or other similar tools." "I would rate the stability a seven out of ten. For example, in my scenario, I frequently need to maintain and store data, which can then be utilized to generate reports. This would be very helpful." "The licensing cost of the solution is expensive, which MySQL needs to consider improving." "Clusters are hard to perform so we use no SQL alternates like MongoDB." "Scalability could be improved." "Improvements to MySQL depend on the specific use case. We have two useful features to add or create the table, but there should be some UI features to allow us to drag and drop to create other schemas. For example, when using the flow diagram, we can create a schema. "In an upcoming release, there should be something added similar to EPL. Some users feel that MySQL requires more maintenance and can be a bit buggy and less stable than SQL Server. Service and Support: Overall, users of both solutions are satisfied with their service and support available.Ĭomparison Results: SQL Server comes out ahead in this comparison because it is less demanding on resources and can more easily be integrated with other solutions.Additional licensing options are considered very reasonable. Pricing: Both solutions are open source and have free versions available.Some users feel more enhanced backups and more restore points are needed and that intelligence could be improved. Additionally, they say the integration, SSRS, and SSIS tools are very effective. SQL Server users like the replication feature, user interface, reporting services, and notification services, which they tell us are very good. Some users feel the solution could improve the monitoring and that it should have some code analytical functions. The solution is compatible with a lot of other databases and also a lot of other shared database solutions. Users say the packaging tool development is clear and concise and the data is presented in a way that is very simple to understand. Features: Users say both solutions are very easy to use and very user friendly.Ease of Deployment: For the most part, users of both solutions feel installation and deployment is simple and straightforward.After reading the collected data, you can find our conclusion below. We performed a comparison between MYSQL and SQL Server based on our users’ reviews in four categories. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |