Sage 100 Premium (SQL) does not include payroll,  timecard,  job cost,  work order  (any legacy module). Did I miss any?

Not sure about 3rd party developers.

MRP (material requirements planning) is also not available in the SQL version.

A) Only modules that are in the Business Framework are available with Sage ERP Premium SQL version.

Library Master

General Ledger

Accounts Payable

Accounts Receivable

Bank Reconciliation

Bar Code

Bill of Materials

Business Insights Dashboard

Business Insights Explorer

Common Information

Custom Office

Inventory Management

Library Master

Paperless Office

Purchase Order

Return Merchandise Authorization

Sales Order

Visual Integrator

Web Services

B) Some of the typical Third-Party Products Available.

Microsoft Windows Faxing (WinFax is not supported)

Aatrix - 1099 reporting in Accounts Payable

Avatax

ScanCo Barcode

Crystal Reports Version 11.5

Ship Link

Compupay - Used as a payroll solution

Sage Payment Solutions

C) 3rd party developers can create their products for both versions.  But of course get the answer from the developer and the mod you need.

D) Typically companies that move to Premium will:

1) Already have SQL Server Databases

2) Plan on having a DBA available to setup database tuning and maintenance.

3) Plan on taking on advantage of the “open” database tables. en.wikipedia.org/.../Advantage_Database_Server

4) Will have a large database set: several million rows on many tables

5) Will have large amount of users 50+.

E) GENERIC DIFFERENCE BETWEEN FLAT FILES (PVX) AND SQL (Premium).

1) FLAT FILES (PVX):

• Available and versatile: You can create and save data in any operating system's file system. You don't need to install any extra software. Additionally, text data stored in flat files can be read by a variety of software programs, such as word processors or spreadsheets.

• Easy to use: You don't need to do any extra preparation, such as install database software, design a database, create a database, and so on. Just create the file and store the data with statements in your PHP script.

• Smaller: Flat files store data by using less disk space than databases.

A flat file is quick and easy and takes less space than a database. It is ideal for storing small amounts of information quickly, such as a simple list or small piece of information. Flat files are particularly useful for making information available to other software, such as an editing program or a spreadsheet. Flat files can be looked at by anyone with access to the computer directory where they are stored, so they are useful when information needs to be made available to other people.

2) SQL (Premium).

• Security: A database provides a security layer of its own, in addition to the security provided by the operating system. A database protects the data from outside intrusion better than a flat file.

• Accessibility of data: You can store data in a database by using a very complex data structure, specifying data types and relationships among the data. The organization of the data makes it easy to search the data and retrieve what you need.

• Ability to handle multiple users: When many users store or access data in a single file, such as a file containing names and addresses, a database ensures that users take their turn with the file to avoid overwriting each other's data.

Databases require more start-up effort and use more space than a flat file, but are much more suitable for handling complex information. The database handles the internal organization of the data, making data retrieval much simpler. A database provides more security, making it more suitable for sensitive, private information. Databases can more easily and efficiently handle high traffic when many users may try to access the data almost simultaneously.

That is my two cents.  Start a case with Sage Support and it can be reviewed further.

Wow!  Now that is the most complete and detailed answer I have ever seen.  Thank you for taking the time.

Paula, I've not worked with the the standard version but I can tell you the Premium version gives you the option of doing quite a bit outside of the Sage environment using Microsoft Access and an ODBC connection. You can save a lot of money on custom software that way. Some things have to be done within the Sage environment but we've done a lot in Access and saved a ton on the development.