Need some advice on sql server vs. mysql

bankadmin
bankadmin used Ask the Experts™
on
We have a server running sql server 2008 (the server is x64 server 2008). The our vendor of the software that runs on the server said that we need mysql because sql server only allows a 10GB database and ours needs to be much larger than that. Does this sound correct? Could you provide me a link to the appropriate download that we need.
Comment
Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®
I don't think 10 GB is a true limit.  http://msdn.microsoft.com/en-us/library/ms143432.aspx

I would avoid changing unless you have a compelling reason to do so.  Perhaps your vendor has a SQL Server database size limitation, or your vendor is thinking about an older SQL Server version or maybe an Express version.
Your vendor might be thinking of SQL Server 2008 Express.  That has a 10 GB limitation.  

http://blogs.msdn.com/b/sqlexpress/archive/2010/04/21/database-size-limit-increased-to-10gb-in-sql-server-2008-r2-express.aspx

Author

Commented:
The vendor is telling me to change but I will verify what specific version they want me to switch to.
Acronis in Gartner 2019 MQ for datacenter backup

It is an honor to be featured in Gartner 2019 Magic Quadrant for Datacenter Backup and Recovery Solutions. Gartner’s MQ sets a high standard and earning a place on their grid is a great affirmation that Acronis is delivering on our mission to protect all data, apps, and systems.

If you are in fact using an express version and need to choose between a full implementation of SQL Server or mySQL, take into consideration performance of one database type vs the other when using your vendor's product.
Did you get anywhere with the vendor?

Author

Commented:
There was alot of good information..

Thanks

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial