Microsoft Dynamics 365 vs. MySQL vs. Microsoft SQL Server

Provides our company access to manage and customize the folds tailored to our needs. We needed to have certain paragraphs on certain paperwork per customer. MD 365 has those options to customize where needed and remove when not. The system is easy to navigate, and training can be done in a matter of days, even without prior knowledge of the system or similar systems.

Incentivized

MySQL is best suited for applications on platform like high-traffic content-driven websites, small-scale web apps, data warehouses which regards light analytical workloads. However its less suited for areas like enterprise data warehouse, OLAP cubes, large-scale reporting, applications requiring flexible or semi-structured data like event logging systems, product configurations, dynamic forms.

Incentivized

Microsoft SQL is ubiquitous, while MySQL runs under the hood all over the place. Microsoft SQL is the platform taught in colleges and certification courses and is the one most likely to be used by businesses because it is backed by Microsoft. Its interface is friendly (well, as pleasant as SQL can be) and has been used by so many for so long that resources are freely available if you encounter any issues.

Incentivized

• Best to use for AP - like in our organization, there are plenty of AP bills, so with Dynamics, we can quickly enter the same into the Excel utility, which means CSV-based upload, and then we can easily upload the same to the software. It's a time saver.
• Best for Bank reconciliation - MS Dynamics makes Bank reconciliation easy. Banks can easily sync with software and easily get reconciled.
• Generating invoices to customers and directly sending them to their inbox is easy with this software.

Incentivized

• Stable - it just runs, with minimal downtime or errors
• Fast - well-structured data is quickly written and read
• Secure - MySQL is easy to keep data secure from people and applications that shouldn't see it
• Easy to use - SQL is industry standard so no problems with adding, editing and reading data stored in MySQL

Incentivized

• Easy to configure and use with Visual Studio and Dot Net
• Easy integration with MSBI to perform data analysis
• Data Security
• Easy to understand and use
• Very easy to export database and tables in the form of SQL query or a script

Incentivized

• Small learning curve, obviously. You won't figure this out in a day, a week, or even a month. But given time, you can learn to be an expert. Or you can always get a consultant or hire in somebody. But learning the tool isn't out of the questions by any means.
• Licensing can be confusing at times and isn't cheap, but it is cheaper than Salesforce. Plus no additional fees for data calls to better integrate your D365 CE data with other systems.
• The Classic user interface left a bit to be desired, but now with the much-improved Unified Interface, the web client and the mobile client look the same, much more modern, and have more flexibility and power behind them for customizers as well.

Incentivized

• Learning curve: is big. Newbies will face problems in understanding the platform initially. However, with plenty of online resources, one can easily find solutions to problems and learn on the go.
• Backup and restore: MySQL is not very seamless. Although the data is never ruptured or missed, the process involved is not very much user-friendly. Maybe, a new command-line interface for only the backup-restore functionality shall be set up again to make this very important step much easier to perform and maintain.

Incentivized

• Microsoft SQL Server Enterprise edition has a high cost but is the only edition which supports SQL Always On Availability Groups. It would be nice to include this feature in the Standard version.
• Licensing of Microsoft SQL Server is a quite complex matter, it would be good to simplify licensing in the future. For example, per core vs per user CAL licensing, as well as complex licensing scenarios in the Cloud and on Edge locations.
• It would be good to include native tools for converting Oracle, DB2, Postgresql and MySQL/MariaDB databases (schema and data) for import into Microsoft SQL Server.

Incentivized

CRM has allowed us to keep all of our data in one place that is easy for all users within the company to view. I came into the company after they had been using CRM for about 4 years. They have all said that since we have used this it has helped us control work processes better, it has allowed us to be able to track things so much better, and has been something that has helped unite many processes that used to be all over the place. We are currently using CRM 4.0 and are planning on upgrading in the next 18 months to the 2011 version. Support for 4.0 is almost all but dried up. Understandably so. Some of the customization we have done, and a plugins we use, are now contained within the 2011 version so we are looking forward to that upgrade. We use an email marketing company as well, and they primarily support the 2011 version, but their product connects and is integrated within CRM. This is a great benefit as well so that all of our marketing information can be contained in one location.

For teaching Databases and SQL, I would definitely continue to use MySQL. It provides a good, solid foundation to learn about databases. Also to learn about the SQL language and how it works with the creation, insertion, deletion, updating, and manipulation of data, tables, and databases. This SQL language is a foundation and can be used to learn many other database related concepts.

Incentivized

We understand that the Microsoft SQL Server will continue to advance, offering the same robust and reliable platform while adding new features that enable us, as a software center, to create a superior product. That provides excellent performance while reducing the hardware requirements and the total cost of ownership of our solution.

Incentivized

The usability is easily adopted for users familiar with other Microsoft products. Dynamics 365 has several interfaces that cross over browsers and tablets. These multiple interfaces will be phased out and updated to a single unified interface eventually to provide the same usability across all devices. The backend configurations is slowly improving with the introduction of PowerApps compared to pre-D365 Online versions

Incentivized

I give MySQL a 9/10 overall because I really like it but I feel like there are a lot of tech people who would hate it if I gave it a 10/10. I've never had any problems with it or reached any of its limitations but I know a few people who have so I can't give it a 10/10 based on those complaints.

SQL Server mostly 'just works' or generates error messages to help you sort out the trouble. You can usually count on the product to get the job done and keep an eye on your potential mistakes. Interaction with other Microsoft products makes operating as a Windows user pretty straight forward. Digging through the multitude of dialogs and wizards can be a pain, but the answer is usually there somewhere.

Incentivized

Its does not have outages.

Incentivized

SSAS data cubes may some time slow down your Excel reports.

Incentivized

Our partner, Ledgeview Partners has been FANTASTIC to work with. They are always timely in their response and have taken time to understand our business and our specific needs. We've made a lot of advanced customizations and they have been a great help in making those updates.

Incentivized

We have never contacted MySQL enterprise support team for any issues related to MySQL. This is because we have been using primarily the MySQL Server community edition and have been using the MySQL support forums for any questions and practical guidance that we needed before and during the technical implementations. Overall, the support community has been very helpful and allowed us to make the most out of the community edition.

Incentivized

We managed to handle most of our problems by looking into Microsoft's official documentation that has everything explained and almost every function has an example that illustrates in detail how a particular functionality works. Just like PowerShell has the ability to show you an example of how some cmdlet works, that is the case also here, and in my opinion, it is a very good practice and I like it.

Incentivized

It was good

Incentivized

very hands on and detailed training

Incentivized

We used a data warehouse to house our data, and our IT team and implementation vendor worked diligently ahead of time to construct idea implementation plans. Out of millions of records- we had less than a dozen errors, which is remarkable. My major insight is simply having a group of completely devoted individuals working towards your goal who fully understand the desired outcome. Focused resources for implementation season are critical to success.

1. Estimate your data size. 2. Test, test, and test.

Incentivized

Other than SQL taking quite a bit of time to actually install there are no problems with installation. Even on hardware that has good performance SQL can still take close to an hour to install a typical server with management and reporting services.

Incentivized

Microsoft Dynamics was part of a system overhaul for a local school, and we looked at many products. If we had used it for a company with low turnover, then it might have been more feasible. They needed something a new person could learn quickly, someone who might also be learning marketing terms at the same time - especially if there is nobody to train the individual now expected to know the system. Similar issues occurred with all of these programs (we called it being too big for their britches), and one of the bigger things we liked was that it is more compatible with MS Office products in both technical and visual appeal. If you have a steady employees who use a CRM consistently, low turnover, and those who are very familiar with Office products, Dynamics would be the smartest option for you. Unfortunately, this was just not true for the school environment

Incentivized

MongoDB has a dynamic schema for how data is stored in 'documents' whereas MySQL is more structured with tables, columns, and rows. MongoDB was built for high availability whereas MySQL can be a challenge when it comes to replication of the data and making everything redundant in the event of a DR or outage.

Incentivized

[Microsoft] SQL Server has a much better community and professional support and is overall just a more reliable system with Microsoft behind it. I've used MySQL in the past and SQL Server has just become more comfortable for me and is my go to RDBMS.

Incentivized

On our purchase, I'd been interrogated about our usage. Our needs are met by Microsoft Dynamics 365, which is simple to use. With so much data and information available, we must ensure that it is presented correctly to managers. Due to a lack of use, we don't have to spend as much money on Salesforce.

SQL server does handle growing demands of a mid sized company.

Incentivized

My company's preferred program right now is Microsoft Dynamics 365. We use it to keep track of customers and important sales metrics in a streamlined manner. Anyone familiar with CRMs will find the tool extremely useful. Considering that we have a good turnover, this product will be used for its basic segments. As a result, there are few chances of error with Microsoft dynamics because it is so easy to use. Many options for recording data on these leads are available. It meets our needs and pays off.

• For those without a centralized, all in one solution for major HR, Finance and other departments, Microsoft Dynamics 365 has vastly improved employee time utilization and profit.
• Migrating clients from on-premise to the cloud has reaped benefits including better security, no unscheduled downtime and frequent updates to functionality.
• Those transferring from cheaper solutions have lost money in the aim to be better integrated with other Microsoft products and AI they don't really utilize.

Incentivized

• As it is an open source solution through community solution, we can use it in a multitude of projects without cost license
• The acquisition by Oracle makes you need to contract support for the enterprise version
• If you have knowledge about oracle databases, you can get more out of the enterprise version

Incentivized

• Increased accuracy - We went from multiple users having different versions of an Excel spreadsheet to a single source of truth for our reporting.
• Increased Efficiency - We can now generate reports at any time from a single source rather than multiple users spending their time collating data and generating reports.
• Improved Security - Enterprise level security on a dedicated server rather than financial files on multiple laptop hard drives.

Incentivized