Fictional example

Example: Legacy Check of a Delphi inventory management system

An inventory management system in Delphi 7, a developer close to retirement and mandatory e-invoicing around the corner: this fictional example shows how a Legacy Check assesses such a situation – and which path leads out of it. You can download both parts of the report as PDFs.

The situation

Muster Haustechnik Großhandel GmbH (fictional) – Wholesaler of plumbing and heating supplies with 85 employees, a central warehouse and two trade counters.

Complete inventory management and ERP: article and price maintenance for about 1.4 million articles, quotes, orders, delivery notes and invoices, purchasing, warehouse and picking, and project business with project prices for installer firms.

MERKUR has been developed since 1998 by a one-person software company and is still maintained by the same developer. He has announced that he will retire at the end of 2027; the rights to the source code were transferred by contract in 2025. At the same time, mandatory e-invoicing is around the corner, and the installer customers expect digital ordering. Management wanted to know whether MERKUR has a future – and if not, how to switch without disrupting day-to-day business.

  • Assess MERKUR's future and the risks for operations
  • Meet the e-invoicing obligation in time
  • Secure the developer's knowledge while he is still available

Scope of the Legacy Check
Fixed price €2,499 net · Completed within 2 calendar weeks

  • Analysis of the complete source code and database schema (anonymised copy, no live data)
  • AI-assisted code analysis with the right model for each task and proven prompts, all findings reviewed by experienced developers
  • Two interviews: business department (sales and warehouse) and the current developer
  • Review of infrastructure, operations, third-party components and licences
  • Results presentation (online, 60 minutes) and this report

The result

Strong for the business, technically at the end of its life cycle

MERKUR maps Muster Haustechnik's business in great depth – pricing logic and project business are real strengths. The technical foundation, however, is exhausted: Delphi 7 and Firebird 2.5 are no longer developed, and all knowledge sits with one developer who retires at the end of 2027. Two issues cannot wait: the database reachable from the internet and mandatory e-invoicing from 1 January 2027. After that, we recommend replacing MERKUR step by step with a web application.

Traffic-light rating

  • RedIT securityDatabase reachable from the internet; all clients use SYSDBA with an unchanged password; Firebird 2.5 without updates.
  • RedLegal requirementsE-invoices (XRechnung, ZUGFeRD) cannot be created – mandatory from 1 January 2027.
  • RedKnowledge & documentationA single developer, retiring at the end of 2027; approx. 30 of an estimated 260 business rules described.
  • RedTechnology outlookDelphi 7 (2002) without Unicode or 64-bit; key components discontinued; Delphi developers are scarce.
  • AmberMaintainability & code qualityOrganised by business area, but approx. 55% of the logic in forms, 18% duplicates, no tests.
  • AmberOperations & infrastructureRestores tested regularly; but server support ends 01/2027, build only on the developer's computer.
  • AmberDatabase & dataClean core model; but character set problems, duplicate articles and approx. 40% of the logic in triggers and procedures.
  • GreenBusiness fitCovers trading, warehouse and project business very well; pricing logic as a competitive advantage.

The five biggest risks

No.RiskRatingAction
R1E-invoicing obligation from 2027 cannot be metMERKUR creates invoices only as PDFs. From 2027 the company (prior-year turnover above €800,000) must issue invoices to domestic business customers as e-invoices.CriticalE-invoicing service (XRechnung, ZUGFeRD) next to MERKUR – ready by 31 December 2026.
R2Database reachable from the internetFor the nightly shop sync, the Firebird port is open in the firewall; access is unencrypted and uses SYSDBA.CriticalClose the port immediately, sync through a secured interface, accounts with minimal rights.
R3Knowledge monopoly with an expiry dateAll technical knowledge sits with one external developer who retires at the end of 2027.HighAgree a knowledge transfer by contract, document the business rules.
R4Platform without a futureDelphi 7, Firebird 2.5 and key components are no longer maintained; Windows Server 2016 loses support in January 2027.HighShort term Firebird 5 and Windows Server 2025, medium term replacement.
R5No source code managementSource code and compiler licence are on the developer's computer; versions are stored as ZIP archives.HighGit and build environment in the company, licences in the company's name.

The options compared

OptionEffort without AIDuration without AISaving with AIAssessment
ASecure and meet obligationsE-invoicing service, shield the database, Firebird 5 and Windows Server 2025, Git and build in-house; MERKUR itself stays unchanged.55–70 PD3–4 months30–40%Essential and immediate
BUpgrade to current DelphiCurrent Delphi version with Unicode and 64-bit, replacement of discontinued components; user interface and processes stay the same.470–630 PD18–24 months50–70%Feasible, but does not solve the skills shortage
CStep-by-step replacement with a web applicationrecommendedNew application with ASP.NET Core (C#), Angular and PostgreSQL, module by module using the strangler fig pattern; MERKUR runs in parallel until the last module has been taken over.840–1,080 PD36–42 months50–60%Recommended (after option A)
DIndustry software for wholesalersIntroduction of a standard inventory management system for plumbing and heating wholesalers, with customisation.high (plus licences)15–23 monthsapprox. 20%Secondary – high customisation needs

Effort and duration estimated without AI. Our AI-assisted development reduces time and cost by the range shown; the roadmap already includes AI.

Recommendation and roadmap

We recommend handling the obligations and critical risks immediately (option A), then replacing MERKUR step by step with a web application (option C). The e-invoicing service comes first, built as part of the new architecture. Securing the developer's knowledge while he is available is crucial.

  1. Phase 1

    Obligations and security

    Months 1–3 · 35–45 PD

    E-invoicing service by 31 December 2026, shield the database, Firebird 5 and Windows Server 2025, Git and build in-house

  2. Phase 2

    Knowledge and foundation

    Months 3–6 · 60–80 PD

    Document business rules with the developer, interface layer (API) on top of the database, test cases from real documents

  3. Phase 3

    Modular replacement

    Months 6–20 · 280–350 PD

    Master data and prices, sales, purchasing, warehouse with mobile data capture in the browser

  4. Phase 4

    Migration and shutdown

    Months 20–24 · 40–55 PD

    Move to PostgreSQL, end parallel operation, archive and switch off MERKUR

All four phases: 415–530 PD over approx. 24 months with AI – approx. 895–1,150 PD without AI. Accuracy ±25%. Phase 1 must be completed by 31 December 2026.

Download the report

The report has two parts: a compact summary for management and a detailed analysis for IT. Click a page to enlarge it.

Part 1: Management summary

PDF · 4 pages · 420 KB

Download PDF
  • Part 1: Management summary, Page 1
  • Part 1: Management summary, Page 2
  • Part 1: Management summary, Page 3
  • Part 1: Management summary, Page 4

Part 2: Detailed analysis

PDF · 10 pages · 664 KB

Download PDF
  • Part 2: Detailed analysis, Page 1
  • Part 2: Detailed analysis, Page 3
  • Part 2: Detailed analysis, Page 4
  • Part 2: Detailed analysis, Page 7
  • Part 2: Detailed analysis, Page 9
  • Part 2: Detailed analysis, Page 10

More example reports

Every application is different – and so is the right path. These fictional examples show the Legacy Check for other technologies.

  • .NET 4.8 · VB.NET · SQL Server

    .NET 4.8 application in manufacturing

    VB.NET and SQL Server: remove security risks, keep valuable business logic and modernise the technology.

  • IBM i · RPG · COBOL · Db2

    IBM i application in logistics

    RPG, COBOL and Db2: staffing risk, missing interfaces – add APIs first, then replace modules step by step.

Your own Legacy Check

Fixed price €2,499 net, results usually within two weeks – with a report, a results presentation and a concrete recommendation for your application.

Request a Legacy Check