Is there a tool or any online application for converting sql queries to fetch xml queries?

(0) Share

Report

Posted on by Community Member

Hi All,

We are migrating from 2013 onpremise to d365 online dynamics CRM.I have all the reports in 2013 but for D365 for reporting we use fetch xml queries.I have sql queries for all the reports but for using reports in d365 those reports wont be supported and needs to be modified according to fetch xml queries.I want to know whether there is any tool available online for converting the sql quries to fetch xml queries or do i need to write fetch xml queries manually for all the reports.I chceked with sql2fetchxml.com but it gives error for issues like joins.Kindly let me know if anyone had come across any tool for this.

Thanks in advance

Categories:

Customization / Solutions / SDK and API

Other Functionality

All responses (3)

Answers (0)

Community Member on at

Like (0)

Report

RE: Is there a tool or any online application for converting sql queries to fetch xml queries?

thanks Matt.I am trying with query builder in xrm toolbox
Suggested answer

Adrian Begovich 1,025 Super User 2025 Season 1 on at

Like (0)

Report

RE: Is there a tool or any online application for converting sql queries to fetch xml queries?

Hi Priti01,

Some SQL queries cannot be converted to equivalent FetchXML queries. This article presents a list of current FetchXML limitations.
Suggested answer

Matt Collins-Jones 230 User Group Leader on at

Like (0)

Report

RE: Is there a tool or any online application for converting sql queries to fetch xml queries?

Hi Priti

I do not know of any tools to be able to do this automatically. I have previously had to re-write all the queries manually, but the FetchXML builder can help with creating the queries and building outer joins, not possible through advanced finds alone. There is an element of restriction with FetchXML compared to SQL, so it might be that you cannot recreate the report queries exactly. There are ways around this like the data export service to replicate data in an azure hosted SQL db and doing SQL reporting on that server instead of D365, but it depends on the reports, how critical they are and if the expense of this method would be justifiable.

Thanks

Matt