All-in-One Database

SyteLine uses just one database named the All-in-One (AIO) database. This database holds all of the application data, such as customer, item, customer order, etc. It is made up of hundreds of tables, stored procedures, triggers, user defined data types, and indexes. The database also holds all of the information about each form; components such as text boxes, labels, tabs, radio groups, buttons, and all of the associated properties (size, color, validation, events) and it stores the IDO metadata.

Because all schema and data is contained in a single database, there are fewer databases and backups to manage compared to a multi-database system.