GeoMate
Geoscience database
One canonical geoscience schema that runs on MS Access or SQL Server / LocalDB — so you own your database and choose where it lives.
Everything in GeoMate sits on one canonical geoscience schema. Because that schema is backend-agnostic, the exact same project can live in a single MS Access file or in an enterprise SQL Server instance — and move between them without redesigning a table. Table and relationship designers, reference lookups and one-step provisioning keep the structure clean as the project grows.
The schema ships with the drillhole tables an exploration project actually needs — DHCollar, DHSurvey, DHLithology, DHSamples, DHStructuralMeasurements, DHRecovery, DHDensity and the rest — plus interpretation tables for composites, domains and targets. Relationships, lookups and coded lists are declared once, so a value typed on a rig follows the same vocabulary as a value read by a resource geologist.
A junior explorer starts a project as a single Access file on a laptop. Two years and three rigs later, the same database is migrated to SQL Server for the whole team — in one guided step, without redesigning a single table.
What’s inside
- Backend-agnostic schema — Access (.accdb) and SQL Server from the same model
- Visual Table Designer and Relationships Designer
- Provision a new database from the canonical template in one step
- Built-in reference / lookup data (rf* tables)
- One-click Access → SQL Server migration
All modules