SBS Quality Management System software is offered in two varieties:  an access standalone version and a SQL server version. Both versions have identical user interfaces.  The differences reside in where and how the data is stored. There are several benefits in implementing or upgrading to the SQL server version.

• High performance and scalability    In many situations, SQL Server offers better performance than a standalone Access database. SQL Server also provides support for very large, terabyte-sized databases, which is much larger than the current limit for an Access database of two gigabytes. Finally, SQL Server works very efficiently by processing queries in parallel (using multiple native threads within a single process to handle user requests) and minimizing additional memory requirements when more users are added.
• Increased availability    SQL Server allows you to do a dynamic backup, either incremental or complete, of the database while it’s in use. Consequently, you do not have to force users to exit the database to back up data.
• Improved security    SQL Server can integrate with Windows system security to provide a single integrated access to the network and the database, employing the best of both security systems. This makes it much easier to administer complex security schemes.
• Immediate recoverability    In case of system failure (such as an operating system crash or power outage), SQL Server has an automatic recovery mechanism that recovers a database to the last state of consistency in a matter of minutes, with no database administrator intervention.
• Server-based processing    Using SQL Server in a client/server configuration reduces network traffic by processing database queries on the server before sending results to the client. Having the server do the processing is usually much more efficient, especially when working with large data sets.

Your application can also use user-defined functions, stored procedures, and triggers to centralize and share application logic, business rules and policies, complex queries, data validation, and referential integrity code on the server, rather than on the client.

There are many factors that go into deciding which version is best. These include cost, availability of IT resources, security requirements, and other customer specific requirements. Each of these factors should be carefully considered when choosing between the access standalone and the SQL server versions of our products.

We are here to answer any and all questions and to help in the decision-making process. Feel free to contact us at sales@sundaybizsys.com.