Menu
Are there any drawbacks to such a configuration?
426
Answer: Yes, SQL Server and MySQL can coexist as they are totally separate entities. Both are irrelevant to each other and communicate on different ports. The default port for MySQL is 3306 and the default ports for SQL Server are 1433 & 1434. Thus, there would be no issues for running both of them on the same machine.
Both platforms support Windows and Linux, although there are certain “home court advantages” to each one. Using SQL Server makes a little more sense if you're already a Windows and . NET shop. On the other hand, if you use Linux and Python/Java/PHP, MySQL is probably the better choice here.
You can install multiple instances of SQL Server, or install SQL Server on a computer where earlier SQL Server versions are already installed. The following SQL Server-related items are compatible with the installation of multiple instances on the same computer: Database Engine.
SQL Server 2019 allows you to directly upgrade from SQL Server 2008/R2 and keep the database compatibility to the earlier version.
These two databases are totally separate entities and you should have no problems running both of them on the same machine.
Short story: I wanted to test Hibernate with various database dialects, so I ended up installing these databases on one machine:
and I had no problems with all of them running at once. Yes, it was a test server and the poor thing was totally running out of memory, but everything did work.
Only imaginable problem you could run into: configuring the same port for multiple databases. But you wouldn't do that, so it's not a problem.
75
Aside from the resources they would both consume (memory, disk, cpu); barring any purposeful conflicting configuration (by default they will listen on different ports), it would work fine.
31
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
