MySQL means boosted speed & security in Sage 50!

1 minute read time.

It took a three-round process of elimination to find the database that could meet the software functionality and vision that Sage 50 had in mind. The reason why Sage 50 originally switched to using MySQL as its database standard was because MySQL

 "was head and shoulders above the rest in meeting [needs related] to performance" - mysql.com

 What is MySQL?

"MySQL Community Edition is a freely downloadable version of the world's most popular open source database that is supported by an active community of open source developers and enthusiasts."dev.mysql.com 

Why the switch to v5.7?

Sage 50 continues to use MySQL databases but has moved from version 5.6.10 to version 5.7.18.

v5.7 was originally launched back in 2013! Making Sage's existing database structure formerly running quite old. We're looking forward to the increased security and performance in Sage 50 as much as you!

  •  Features Added in MySQL 5.7
    • View this site: for full technical change details taking place in the backend database structure of your Sage 50 software.

MySQL version 5.7.18 provides increased security and speed.

Potential Upgrade Issues

Note: May slow down database conversion process, so set aside some extra time to upgrade.

Before you upgrade and start working with your database in Sage 50 2018, take a moment to review the 2018 System Requirements as some older operating systems are no longer supported.

*Tips: If you are working on a network check what OS is used by the "Server" machine and all other workstations. We will not be able to downgrade the database structure so also make sure to make a backup of your data.

Create Sage Ideas! Enter and vote on new features

Read this blog in French!