Notifications
Announcements
No record found.
Is this a easy task to generate SQL statement Schema from a contact entity on Dynamics 365 online?
Hi,
Not sure about the requirement here, but if you want to interact with online CRM org database please use XRM tool box, there you will find a connection called SQL 4 CDS. This plugin will allow you to interact with online CRM org database.
That is a nice plugin, I want replicate some tables on Azure SQL. Any tool that you suggest. you know that generates me something like SQL script.
create table account(
field .....
...
..
)
i want to replicate for using like a staging table to integrated with Azure data factory
From XRM toolbox you can copy data and then create manual insert script to insert data into azure SQL DB.
But if you want automation I recommend to use DES (Data Export service) , this will automatically replicate all the data into Azure SQL db as well as it will continue to replicate all the update or changes happened to any record in CRM into Azure
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
Tom_Gioielli 170 Super User 2025 Season 2
#ManoVerse 70
Jimmy Passeti 50 Most Valuable Professional
