cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
KD203
Helper II
Helper II

Creating a database schema.

Hello!

I was wondering if there is a way to export MS Dataverse tables, their fields and the table relationships as a scheme so i can use it to create an SQL database?

 

Thanks in advance.

1 ACCEPTED SOLUTION

Accepted Solutions
EricRegnier
Super User
Super User

Hi @KD203,

Unfortunately no there's not. You can export them with a solution and deploy to another Dataverse environment but not directly to SQL Server/Azure SQL. Solutions are xml files so you can write some script to read those xmls and generate your SQL tables.

 

Feel free to submit that idea at: https://powerusers.microsoft.com/t5/Power-Apps-Ideas/idb-p/PowerAppsIdeas

Hope this helps...

View solution in original post

1 REPLY 1
EricRegnier
Super User
Super User

Hi @KD203,

Unfortunately no there's not. You can export them with a solution and deploy to another Dataverse environment but not directly to SQL Server/Azure SQL. Solutions are xml files so you can write some script to read those xmls and generate your SQL tables.

 

Feel free to submit that idea at: https://powerusers.microsoft.com/t5/Power-Apps-Ideas/idb-p/PowerAppsIdeas

Hope this helps...

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!

Users online (1,375)