SQL Server Express Edition

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