A simple command line utility to import Dataverse (Dynamics 365 / Power Platform) entities into SQL Server tables. MirraSQL connects to your Dataverse environment and SQL Server database, allowing you to select specific entities to import. It handles sql schema sychronisation, data mapping, and incremental updates, ensuring your SQL Server tables are always up-to-date with the latest data from Dataverse.

MirraSQL Example

How to import account, contact and systemuser entities

MirraSql import account contact systemuser

MirraSql Version 1.0.0
Copyright 2026 Simego Ltd

Using profile: [default]

√ Connected to Dataverse
√ Connected to SQL Server

Importing 3 entities...

[1/3] [account] 186 inserted, 0 updated, 0 deleted (4.92s)
[2/3] [contact] 570 inserted, 0 updated, 0 deleted (2.92s)
[3/3] [systemuser] 199 inserted, 0 updated, 0 deleted (2.33s)

√ Import complete
√ 3 entities, total records 955 inserted, 0 updated, 0 deleted
√ Total time: 10.17 seconds

In this example MirraSQL will automatically create 3 SQL Server Tables account, contact and systemuser in the target SQL database matching the schema from Dataverse and import the records. If you run it again only changed records will then be applied to the SQL Tables.