Microsoft SQL Server represents the culmination of significant initiatives from Microsoft in terms of ease of use, scalability and data management.  SQL Server has been designed for businesses that cannot afford to spend excessive time maintaining their computer systems.  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 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 Sage MAS 200, provides a high-performance, cost-effective, manageable accounting software solution.

What's the Difference Between "Standard" Sage MAS 200 and Sage 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.

Business Applications and Appropriate Technology

Implementing new technologies is an important business decision that should enhance a process or solve a problem.  Here are some of the key reasons why SQL Server may be the right choice for your business:

Industry Standard - Proven technologies, which have already been in use at successful businesses, allow you to stay current with appropriate solutions.

Rapid Deployment - The SQL Server database installs quickly and easily, so consulting costs are minimized.

Road Tested - Microsoft SQL Server is a road-tested, industry-standard database fully equipped for the task of running you mission-critical business applications.

Open Architecture - Access to data is one of the biggest benefits of open architecture.  Data stored in SQL Server is available outside the accounting system.

Features:

Commit/Roll Back - If an interruption occurs, the process allows you to "roll back" to a point in time before the interruption occurred.

Stored Procedures/ Triggers - Program commands that are executed at the database level run faster.  Since the commands and associated data do not have to travel across the network to be executed, application performance is enhanced.

Three-Tier Architecture - Sage MAS 200 for SQL Server features classic three-tier client/server architecture.  This architecture provides the greatest flexibility in configuration for performance and control because the three components - database, application and user-interface - are separate and can therefore reside on separate machines.

Concurrency - Proper concurrency control operates a set of rules to maximize multi-user access while maintaining data integrity and control.  This feature of SQL Server is particularly beneficial to accounting systems such as Sage MAS 200, where many users need to enter transactions simultaneously.

Data Security - Mission-critical data is stored in one secure place, where only those with specific user privileges can access it.  Using Role-based Security, users can be given access to specified portions of the database for reporting and querying, while other sensitive data, such as payroll information is protected.

Data Warehousing and DTS - The Sage MAS 200 data is stored in a format designed for optimum performance for the accounting system.  Certain forms of data analysis require a different view of the data.  Data Transformation Services (DTS) let you relate data from multiple diverse sources and store the results in a single "data warehouse" for easy reporting.

OLAP - OLAP provides many benefits to the analytical user.  For example:  easy to select, navigate, and explore multi-dimensional data power to quickly explore complex business data relationships.  Create new views of data based on a rich array ad hoc calculation functions.

Send us an email to schedule an appointment with a Sage MAS 90 ▪ Sage MAS 200 sales consultant. 

Features:

• Commit / Rollback

• Stored Procedures / Triggers

• Three-Tier Architecture

• Concurrency

• Data Security

• Data Warehousing and DTS

• OLAP