Moving from Microsoft Power platform

[nishidp]

Hello folks,

This requesting post is seeking your help, please share solution when you come across to this.

I want to shut the services I have been using from Microsoft  Power platform like PowerApps and Dataverse. What i need is to get backup of my data locally. There are some options available to export data using excel/csv file but it is time taking and tedious process and I won't be getting relationships with those file between the tables. Is there any way possible to get backup of dataverse data as we do backup of sql databases like making .bak files and restoring them as some other databases. 

I need help with some guidance and procedures by which I can move my dataverse data into some other databases like Ms-sql or Mysql.

[rampprakash]

Hi @nishidp 

Am afraid it is not possible, lets wait for others comments as well.

Please mark as Answer if it is helpful and provide Kudos

Subscribe : https://www.youtube.com/channel/UCnGNN3hdlKBOr6PXotskNLA
Follow me on Twitter : @rampprakashd
Blog : https://microsoftcrmtechie.blogspot.com

[ben-thompson]

The official approach from Microsoft was to keep a single per user licence open as that will ensure Microsoft retained the data you need.

If you really want to export all the data and completely leave Microsoft you will need to export the data either manually or by using a separate tool (either SQL4CDS or Kingswaysoft)

[Anonymous]

FetchXML Builder

is the freeware and open source (hosted on GitHub) tool you should check out.

The encouraging product tagline is "Build queries for Microsoft Dataverse, Dynamics 365 and the Power Platform. Investigate data. Get code. Empower yourself to achieve more."

It and its developer, Jonas Rapp, have a long history with MSFT cloud. Jonas explains: "The Power Platform uses FetchXML internally to query the Common Data Service (CDS) for information."

He adds:

FetchXML is the proprietary query language of Microsoft Dynamics CRM.
Which has been renamed to Microsoft Dynamics 365 Customer Engagement.
Which has transformed into the Common Data Service for the Power Platform.

Through all these transitions, FetchXML has persisted as the go-to query language for the platform.

SQL

FetchXML can be explained as the “select equivalent of SQL”. Granted, SQL is a much more colorful querying language, with full CRUD capabilities as well as functions, stored procedures etc. FetchXML does not compare to SQL in that way.
But it reads data from the Common Data Service natively. And it does it well.

[Fubar]

If you search on the Web you will find several options (just ignore the ones that come up as the deprecated Data Export service).

In the old days if you were leaving you could request a database from MSFT, but you had to load it into an Enterprise SQL Server.

Other options:

• Pretty much any tool that has an oData connector can connect and read data (most ETL tools will have this)
• SSIS, build your own packages from scratch or KingswaySoft have an SSIS toolkit that is already Dataverse aware 
• Scribe (now owned by Tibco) had Dynamics 365/Dataverse connectors

[nishidp]

The Other options you have suggested might read data from a single table at a time as I already tried kingswaySoft but it required a lot of configurations even for a single table like connecting it to destination database, create tables in destination database and then map columns with source tables to get data.

Using 1 of these 3 options mentioned would I be able to capture data in Hard disk storage?