GeoMate
← All modules database/
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.
TABLES
Collar
Survey
Assay
Lithology
Recovery
Assay rows 12,480
HoleIDPK
SampleIDtext
mFromnum
mTonum
Au_ppmnum
Cu_pctnum
🗄 MS Access ⇄ SQL Server
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.
In practice
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