Share
ReportIs this a easy task to generate SQL statement Schema from a contact entity on Dynamics 365 online?
Categories:
You’re offline. This is a read only version of the page.
60
Is this a easy task to generate SQL statement Schema from a contact entity on Dynamics 365 online?
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
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
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.
Stay up to date on forum activity by subscribing. You can also customize your in-app and email Notification settings across all subscriptions.
#1
André Arnaud de Cal...
290,532
Super User 2024 Season 2
#2
Martin Dráb
228,501
Most Valuable Professional
#3
nmaenpaa
101,148
All responses (
Answers (