Pearce Ross - SQL Database Schemas

SunSystems and PA Database Schemas

Create extracts for integration into 3rd Party systems like Microsoft Business Central, Data Warehouses and Data Lakes.

Efficient extraction, analysis and remapping of bulk data.

Full audit trail of data migration path from source to target can be provided. Reconciliation of Source to Target records.

A typical SunSystems 4 installation contains around 30 SQL table objects for a single database/ business unit configuration, whilst SunSystems 6 will have between 650 and 750.

Depending on the modules installed, PA data could be held in over 500 SQL table objects.

We understand the data structures, contents and relationships between the underlying data tables, enabling us to provide business specific extracts merging data from all sources.