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
