Migrate from Microsoft MDS
Move your models, entities, attributes, and data from SQL Server Master Data Services to Primentra in minutes — not months. No consultants, no downtime, no risk.
How it works
Two wizards handle the full migration — first structure, then data
Wizard 1 — Models & Entities
Export your metadata structure and import it into Primentra
Export
Run a simple SQL query against your MDS database to export models, entities, and attributes as JSON.
FOR JSON PATH
Upload
Upload the JSON file. Primentra parses and validates your models, entities, and attributes automatically.
Import
Preview what will be imported, resolve conflicts (skip or overwrite), then click Import.
Wizard 2 — Master Data
Export your actual records and import them entity by entity
Generate SQL
The wizard generates a dynamic SQL query based on your imported entities. Save it as a .sql file.
FOR JSON PATH
Run with sqlcmd
Execute the query using sqlcmd (not SSMS — it truncates large datasets). Output is saved as a JSON file.
-o data.json -h -1 -y 0
Import per entity
Upload the JSON and choose per entity: Import new, Overwrite existing, or Delete and reimport. Parent entities are imported first.
What gets migrated
Everything you need, automatically handled
Fully migrated
Handled automatically
Migration comparison
See the difference yourself
Traditional MDM migration
The old way
Migration with Primentra
The modern way
The migration wizard is specifically built for SQL Server Master Data Services (Microsoft MDS). Export your metadata with a provided SQL query and import directly into Primentra.