Skip to main content

Notifications

Announcements

No record found.

Microsoft Dynamics CRM forum
Answered

Creating additional schemas and views in Data Export Service

Posted on by 10

is there any impact or limitation on the azure SQL database, where data and entities from CRM dynamics have been replicated using data export service, if an additional schema and views are created in that azure sql database?

e.g. 

CRM replicates dbo.contact, dbo.account and other tables into the Azure sql database, using the data export service.

and

we also create a separate schema [e.g. call 'MyDummySchema", and a view "CRMContactView") where we can build a specific query on dbo.contact, as example; and query from that MyDummySchema.CRMContactView object instead of the dbo.contact.

Is there any documentation stating that impact or no impact? 

Many thanks 

Juan

Categories:
  • Suggested answer
    Juan G Ganduglia Profile Picture
    Juan G Ganduglia 10 on at
    RE: Creating additional schemas and views in Data Export Service

    Thanks Venkatesh for the quick response.

  • Verified answer
    RE: Creating additional schemas and views in Data Export Service

    Hi,

    We don't have any Document for it. However, it will not impact.

    As, the DES only replicates data from CRM to Azure SQL.

    Regards,

    Venkatesh N

Helpful resources

Quick Links

Replay now available! Dynamics 365 Community Call (CRM Edition)

Catch up on the first D365 Community Call held on 7/10

Community Spotlight of the Month

Kudos to Saurav Dhyani!

Congratulations to the June Top 10 community leaders!

These stars go above and beyond . . .

Leaderboard

#1
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 287,986 Super User

#2
Martin Dráb Profile Picture

Martin Dráb 225,588 Super User

#3
nmaenpaa Profile Picture

nmaenpaa 101,148

Leaderboard

Featured topics

Product updates

Dynamics 365 release plans