SQL Server Express Edition of M.O.M is now available
SQL Server Express is a free version of SQL Server with a database size restriction of 10 GB and a memory limitation. Our tests show that SQL Server Express will outperform the Visual FoxPro version for smaller merchants with low database storage needs.
What does this mean for you?
- Moving forward, the M.O.M. Standard Edition database will be SQL Server Express and not the Visual FoxPro database
- You can stay on your current Standard Edition version as long as it remains supported (we announced the end of support renewals for M.O.M. Version 6 effective from the 1st of July 2013)
- If you are already on Version 8, you can migrate to the SQL Server Express database for a small incremental fee
- Increased Database Security – Open access to the .dbf’s presents a potential operational and security risk as any of those workstations have permissions to delete or overwrite any of the tables. SQL Express Edition permissions ensure that only an appointed Database Administrator can access, query and modify the database directly
- Speed – Increased performance over the current Visual FoxPro database. Beta customer results reveal notable performance improvements of up to 30% over current M.O.M. Standard Edition. (Please note that your performance may vary based upon your unique hardware and software configuration)
- Database Stability – Fail-safe procedures inherent in the SQL Server Express database minimise environmental instabilities
- Incremental Back-ups – Customers have the ability to process incremental automatic backups throughout the day without users logging out of M.O.M.
- Improved Reporting Capabilities – Customers can take advantage of the additional reporting programs and options that are available to SQL databases
- Affordability – no license fee for SQL Server Express makes relational database power more affordable
- Improved Audit Tracking – Due to the 2GB table limit size inherent to Microsoft Visual FoxPro, only certain PCI required data can be stored for audit tracking. This is not so in the SQL Express Version of M.O.M. This type of visibility ensures that data from key events can be recovered from an accidental mistake or intentional deletion and the user can be identified