Technical assessment
Structured review of your current schema, migration targets, and compliance constraints. Deliverable: written findings and risk-ranked recommendations.
Data Schema Consulting
From Hermanus we help Western Cape teams untangle legacy tables, plan PostgreSQL and MySQL migrations, and document schemas that auditors can follow.
Schema work rooted on the Cape south coast
Retailers in George, NGOs in Cape Town, and harbour logistics firms in Hermanus still run mixed SQL Server and open-source stacks. We map foreign keys, naming drift, and migration cut-over risks before anyone writes ETL jobs.
Engagements stay advisory until scope is written down: a technical assessment, a focused schema review session, or a bounded implementation sprint with acceptance checks on each table group.
What we document before migration weekend
We inventory constraints, orphaned lookup tables, and stored procedures that silently enforce business rules. That list becomes the migration backlog your DBA and application team can prioritise together.
When you need hands-on help, we pair on index design, partition boundaries, and rollback scripts — always with fees agreed after the initial inquiry, not from a catalogue price list.
Clear entity diagrams beat heroic weekend restores — we would rather find the duplicate natural keys in Hermanus than debug them in production.
Engagement shapes
Advisory sessions
Time-boxed working meetings on normalization choices, versioning strategy, or cut-over sequencing — billed after scope is confirmed.
Scoped implementation
Bounded build work such as migration scripts, validation queries, or reference DDL packs, with milestones agreed in writing beforehand.
Questions teams ask before booking
- Do you host our databases? We do not sell hosting. We consult on schema design and migration planning; infrastructure stays in your environment or your chosen provider.
- Can you work with our existing DBA? Yes. Assessments and pair sessions are written to complement in-house staff rather than replace them.
- How are fees set? After you describe the systems involved, we propose scope and fees in writing. Nothing is invoiced until you accept that proposal.
- Is on-site work available? We meet clients along the Western Cape when travel is practical; remote working sessions are common for schema reviews.
Send a schema question
Electronic commerce disclosure (ECT Act s43): Data Schema Consulting is a sole proprietorship operated by Sipho Nkosi in South Africa. Physical address: 11,Marine Drive, Hermanus, Western Cape, 7200, South Africa. Contact: +27-28-000-0112, info@data-schema.digital. Representative: Sipho Nkosi.