Totally different concept. In Sage 100 each module has it's own data folder, AR, AP, GL and so on. And in each folder are numerous tables holding data. Customer Master, Vendor Master, Item Master, Invoice History Header, Invoice History Detail. Some tables are historical summary, others are transactional history and others are invoice, sales order and purchase order history. Lots of separate tables. It is written in ProvideX which is actually pretty fast on the processing. There are three different versions, Standard which is a file server system that was originally intended for use with Novell networks. Advanced which is a Client-Server version and the fastest version. It uses a thin client. And Premium which is the SQL version. The processing speed of the SQL version is actually slower than Advanced.

Every company code is it's own "database" but the data files for different areas are separate. With the SQL version every company is its own database and the system files also have their own database.

So our biggest concern is being able to move the data (At some point) from Sage 100 ERP into a bigger system (as we grow), such as SAP or Dynamics. Currently, we are just considering 100 as a temporary solution as our company is changing and we don't have everything worked out yet (this will be a multi-year process) but we need to move away from Sage 50 as soon as possible as it lacks the MRP, CRM and HRM functionalities.

Can someone verify if there are options to transfering the data out of 100 and into a bigger system such as SAP or Dynamics or Epicor? I guess I'm not so concerned about the actual database structure or how its stored, but more on options for exporting data into other systems, and importing data from other systems (for example, if i create my own app for company use that uses an ODBC connection).

If you use the SQL database with Sage 100 then any database programmer can get data out of a SQL database.

Moving the data in and out of Sage 100 is actually pretty easy. It is fully ODBC compliant and sucking the data out is a snap. I think you will find once you get it Sage 100 that it can do a lot. When you say SAP are you talking the full-blown application or SAP Business 1? Honestly if you feel you might outgrow Sage 100 at one point you should also look at X3.