Unanswered

Dynamics 365 Customer service How to export database and store it on local SQL server

(0) Share

Report

Posted on by carav

We are looking to close down a production environment of our Dynamics 365 customer service.

We want to export and store the data somewhere so that we don't have to pay for licenses and still have access to the data.

Could anyone advise the best way to do this?

Categories:

Building Power Apps

I have the same question (0)

All responses (3)

Answers (0)

pavanmanideep 495 Power Up Champ - 2025 on at

Like (0)

Report

Hi @carav

On which version of Dynamics 365 you were using. Are you using Online or Onprem.

Cheers,
PMDY

Was this reply helpful? Yes No
carav on at

Like (0)

Report

Hi @Pavan_Mani_Deep
I am using Dynamics 365 online.
Thanks

Was this reply helpful? Yes No
pavanmanideep 495 Power Up Champ - 2025 on at

Like (0)

Report

Hi @carav

These are the few options you have, you may choose the one relevant to you..

Use Data Export Service:
Microsoft provides the Data Export Service, which can replicate your Dynamics 365 data to a Microsoft Azure SQL Database. From there, you can use Azure SQL Database tools to export the data to a local SQL Server.

Use Data Integration Tools:
You can use third-party data integration tools like KingswaySoft, Scribe, or SSIS (SQL Server Integration Services) to extract data from Dynamics 365 Online and load it into a local SQL Server. These tools provide connectors and adapters for Dynamics 365 Online and SQL Server.

I would suggest you to try out with Data Integration tools.

Hope this helps..

If I have answered your question, please mark your post as Solved.
If you like my response or got a direction forward to proceed, please give it a Thumbs Up. Appreciate your Kudos. You can accept more than one post as a solution.

If you were still facing any issue or challenge, please do let me know so that I can try to check for you. Happy to help you further.

Blog:https://ecellorscrm.com

Cheers,
PMDY

Was this reply helpful? Yes No