Exporting CRM data to on premise SQL Server

(0) Share

Report

Posted on by Jason Yeung

Hi,

I currently have Dynamics CRM on the cloud and I need to export the data to an on premise SQL Server. I was wondering what is the best approach to this? I tried to create a flow in Power Automate, but when I tried to query one of the entites in the CRM (e.g Accounts), There is some information about using the Data Export Service, but this is for an Azure SQL Database.

https://docs.microsoft.com/en-us/previous-versions/dynamicscrm-2016/administering-dynamics-365/mt744592(v=crm.8)?redirectedfrom=MSDN

Sincerely,

Jason

All responses (1)

Answers (0)

mobashee on at

Like (0)

Report

Re: Exporting CRM data to on premise SQL Server

Dear Partner,

The only way to export crm data-to-sql is passing from Azure.

Once time you have all your data on sql you can plan to do what you need (like move it to other platform).

This is the best tutorial to do it:

https://d365blogger.com/tag/crm-online-data-export/

Also looking for an increase of the message size, which is currently 100 MB, as listed at https://docs.microsoft.com/en-us/flow/limits-and-config#message-size. More questions regarding this issue can be found in the forums, e.g. https://powerusers.microsoft.com/t5/General-Flow-Discussion/Increase-http-get-bufer/td-p/89475.

Regards,

Mohamed Sanuj Basheer