Answered

Import from SQL database from another organisation

(0) Share

Report

Posted on by ThomasRConnor

We're migrating data held in SQL from a system hosted by a 3rd party. We have no way of connecting to the database directly so need some form of export.

What's the best option for getting the data? Export from SQL to CSV/XML or is there some form of SQL package that can be used to import to Dataverse?

TIA

Categories:

Microsoft Dataverse with Power Apps

I have the same question (0)

All responses (4)

Answers (1)

Verified answer

Michael E. Gernaey 53,360 Super User 2025 Season 2 on at

Like (1)

Report

Hi,

CSV would work great, because then you can use BULK import to import the data. You can also use DSF once you have the files as well.

It depends on how complex the mappings are between tables (relationships), because when you do a mapping and or a custom import of data, you need to be able to do things like
1. Insert data X, get the GUIDS (the autogenerated key of the row for any dataverse table) and make it available as part of an insert of a child record (relationship table).

If its a table that has no direct relationships, then Bulk Import is perfect. It will depend on how many rows you have as to length of time it takes etc though.

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No
a33ik 3,306 Most Valuable Professional on at

Like (1)

Report

Hello,

I would recommend using SSIS + Kingsway Adapters for Dynamics.

Was this reply helpful? Yes No
ThomasRConnor 62 on at

Like (0)

Report

As I have no direct connectivity to the SQL server that hosts the current system, would this be possible???

Was this reply helpful? Yes No
Michael E. Gernaey 53,360 Super User 2025 Season 2 on at

Like (0)

Report

Hi @ThomasRConnor

No you wouldn't be able to use those tools (which is a Shame), I remember you mentioned that, thats why I suggested bulk import & dsf. And to clarify you couldn't use them to "get" the data but you can build pipelines in SSIS.

But if you have some specifics on the data size etc then setting up bulk import and or dsf, or logic apps, or a one time processing via Power Automate would work well.

Cheers
If you like my answer, please Mark it as Resolved, and give it a thumbs up, so it can help others
Thank You
Michael Gernaey MCT | MCSE | MCP | Self-Contractor| Ex-Microsoft
https://gernaeysoftware.com
LinkedIn: https://www.linkedin.com/in/michaelgernaey

Was this reply helpful? Yes No