The modern replacement for Microsoft MDS

Microsoft removed Master Data Services from SQL Server 2025. Primentra runs on your own SQL Server and brings your MDS models across in under an hour.

Free for 60 days, with every feature. No credit card.

Runs on SQL Server 2017+ and Windows Server 2016+. People sign in with their Active Directory account.

primentra — Retail Operations / Store
The Primentra data grid showing 4,018 stores, with columns for code, name, region, format, employees, floor area, opening date and active status.

Works with your Microsoft stack

  • SQL Serverholds every record
  • SSISloads the staging tables
  • Excelpaste in, export out
  • Power BIreads the Integration Views

MDS stops at SQL Server 2022

SQL Server 2022 is the last version with MDS, and its mainstream support ends on 11 January 2028. Primentra connects to your MDS database, so you can move before that date at your own pace.

  1. ConnectPoint Primentra at your MDS database. It only reads. MDS stays as it is.
  2. Check the dry runSee what will be created and what clashes before Primentra writes anything.
  3. Run itModels, entities, members and domain links arrive in one run. A typical migration takes under an hour.

No connection to the MDS server? Run our two export scripts and upload the two files instead.

MDS Direct Migration in Primentra: the Connect step, with server, port and a read-only user

Scan your MDS

Run one read-only query on your MDS database and paste the result here. The report shows what comes over to Primentra and what does not. There is nothing to install.

Example report
Models
10
Entities
34
Attributes
79
Members
114 to 119
Domain-based attributes
15
Hierarchies
6
Business rules
75

Estimated run time: about 2 to 6 minutes.

This is the run itself. We measured 1,000,000 members in about 11 minutes and added a margin for a slower server.

Numbers from our MDS test lab.

The same customer is in ERP, CRM and Excel in three spellings, Primentra sees that they match, the three records merge into one, and that one record goes to Power BI, SSIS and the data warehouse.

Find the duplicates in your lists

Lookalikes finds records that are the same thing typed in different ways, and you merge them into one.

Lookalikes works inside one entity. Records from ERP, CRM or Excel are merged once they are in Primentra, by import or the API. Primentra keeps no link back to the copy in each source system.

The rule of an entity: Name must be close with Typos, VAT number and City are extra proof

Tap or click the picture to see the full screen.

AI assist can give a second opinion on a group. It is optional and off by default.

What it looks like

Real screens from the product. Pick one.

Product grid with failing rows: SKU cells outlined in red and prices outlined in orange

Tap or click the picture to see the full screen.

What else is in it

  • Grid editing

    Type, paste from Excel, sort and filter. Like a spreadsheet, but Primentra checks every cell.

  • Hierarchies and domains

    Link entities to each other, so a region picks its country from a list.

  • Roles per entity and attribute

    Decide who can read or edit each entity, down to a single column.

  • Staging tables

    Load batches from SSIS or any ETL tool. The same rules apply as on screen.

  • REST API

    Read and write records from other systems with an API key.

  • Import and export

    Excel, CSV and JSON, one entity at a time or a whole model.

Ronald Kraijesteijn

Founder

Why we built Primentra

After 20 years in data management, we were tired of tools that needed a six-month project before anyone could use them.

So we built one you install on Monday and work in on Tuesday. Support mail reaches the people who build it, and what customers ask for decides what we build next.

One price per production server

€7,500per year, excl. VAT

  • The price covers your dev, test and acceptance servers.
  • Unlimited users, models and entities, and every feature.
See pricing details

Try it on your own SQL Server

Free for 60 days. No credit card.

Download the trialOr try the demo first