web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

Community site session details

Community site session details

Session Id :
Customer experience | Sales, Customer Insights,...
Suggested Answer

How to get contact schema script in dynamics365 Online?

(0) ShareShare
ReportReport
Posted on by 60

Is this a easy task to generate SQL statement Schema from a contact entity on Dynamics 365 online?

I have the same question (0)
  • Suggested answer
    SS-01100907-0 Profile Picture
    on at

    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.

  • TerryShowman Profile Picture
    60 on at

    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

  • Suggested answer
    SS-01100907-0 Profile Picture
    on at

    Hi,

    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.

Helpful resources

Quick Links

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Neeraj Kumar – Community Spotlight

We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…

Leaderboard > Customer experience | Sales, Customer Insights, CRM

#1
Tom_Gioielli Profile Picture

Tom_Gioielli 170 Super User 2025 Season 2

#2
#ManoVerse Profile Picture

#ManoVerse 70

#3
Jimmy Passeti Profile Picture

Jimmy Passeti 50 Most Valuable Professional

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans