MirraSQL - Dataverse to SQL Tables
A straightforward and reliable command line utility for exporting Dataverse entities to SQL Server tables
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.
If your intrested in finding out more about MirraSQL please contact us at support@simego.com for more information.