Sage MAS 200 for SQL is a robust, full-fledged implementation that has been thoughtfully created
to take full advantage of the SQL features that are especially beneficial to accounting and
business management software. SQL Server 7.0 combines the power of a relational database with
the ease of use that today's businesses require. Pairing SQL Server 7.0 with the functionality
and flexibility of Sage MAS 200, provides a high-performance, cost-effective, manageable accounting
software solution
Sage MAS 200 Client/Server vs. Sage MAS 200 SQL Server
The major difference between these
two products 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.
Benefits
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
that operates on systems ranging from
laptop computers to symmetric
multiprocessor systems with terabytesized
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, easyto-manage business information
Sage Software, the Sage Software logos, and the Sage Software product and service names mentioned herein are registered trademarks or trademarks of Sage Softare, Inc., or its affiliated entities. All other trademarks are property of their respective owners.