What’s the Difference Between “Standard” MAS 200 and MAS 200 for SQL? The major difference is how your data is stored; the application programs and functionality are identical in both products. In the “Standard” version the data is stored in individual b-tree type files on your server’s hard disk. In the SQL version the data is stored in normalized tables within a relational database. While both products provide access to the data via ODBC, data stored within a SQL database can provide a better foundation for reporting, analysis, and integration.

Reliability
The commit/rollback features of SQL Server enable you to easily roll back and retroactively post data should an interruption occur. Robust backup/ restore and mirroring systems are also available to further protect your data.

Scalability
SQL Server is a single database engine and operates on systems ranging from laptop computers to symmetric multiprocessor systems with terabyte-sized databases running Windows NT Server Enterprise Edition.

Manageability
This innovative back-office solution reduces your cost of ownership by simplifying the way you manage your database, while still providing sophisticated tools for complex operations.

Access to data
Using Open Database Connectivity (ODBC), the SQL data is readily available for access via the reporting tool of choice.

Performance
Microsoft SQL Server is designed to provide optimum performance even during peak load times or as you add more users to the system.

OLAP
Online Analytical Processing allows you to turn data stored within the SQL database into meaningful, easy-to-manage business information.

Microsoft SQL Server represents the culmination of significant initiatives from Microsoft in terms of ease of use, scalability and data management. Current versions of SQL Server have been designed for businesses that cannot afford to spend excessive time maintaining their computer systems. MAS 200 for SQL Server is a robust, full-fledged implementation that has been thoughtfully createdto take full advantage of the SQL features that are especially beneficial to accounting and business management software. SQL Server combines the power of a relational database with the ease of use that today’s businesses require. Pairing SQL Server with the functionality and flexibility of MAS 200, provides a high-performance, cost-effective, manageable accounting software solution.