SQL Server Express Edition

Version 8 of Multichannel Order Manager (M.O.M.) on a SQL Server Express plaform is now available. This latest version allows current M.O.M. Standard Edition (Foxpro) customers to take advantage of the speed, reliability, improved reporting and database stability of Microsoft’s Free SQL Server Express Edition.
 

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

Benefits include:

  • 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

To discuss your integration needs or to arrange a free business review to analyse and evaluate your business requirements please call Richard on 020 7801 6181 or contact us here