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.
Congratulations to our 2026 Super Stars!
We are thrilled to have these Champions in our Community!
These are the community rock stars!
Stay up to date on forum activity by subscribing.
ManoVerse 103 Super User 2026 Season 1
11manish 83
Muhammad Shahzad Sh... 69 Most Valuable Professional
