web

You’re offline. This is a read only version of the page.

News and Announcements icon

Power Platform CommunityForums Power Apps - Microsoft Dataverse Is there a way to expo...

Power Apps - Microsoft Dataverse

Unanswered

Is there a way to export Dataverse table schema as SQL Script?

Like (1) Share

Report

Report

Posted on 27 Sep 2024 11:10:28 by Jitendra_FT

72

Hello,

Is there a way to export Dataverse table schemas in SQL Script?

I would like to move my solution from Dataverse to SQL.

Regards,
Jitendra

Categories:

Microsoft Dataverse

All responses Img

All responses (1)

Answers Img

Answers (0)

Suggested answer

Shashank Bhide 940 Moderator on 30 Sep 2024 at 03:37:21

Like (0)

Report

Is there a way to export Dataverse table schema as SQL Script?

Yes, enable TDS endpoint on your Dataverse, then connect to Dataverse using SSMS and create scripts for desired tables, however, remember that SQL for Dataverse is slightly different than general T-SQL.

https://learn.microsoft.com/en-us/power-apps/developer/data-platform/dataverse-sql-query#limitations

Helpful resources

News and Announcements

Now Available: 2025 Release Wave 2

Welcome to the Power Platform Communities

Announcing our 2025 Season 2 Super Users!

Quick Links

Subscribe to this forum!

Stay up to date on forum activity by subscribing.

Leaderboard > Power Apps

#1

WarrenBelz 791 Most Valuable Professional

#2

MS.Ragavendar 410 Super User 2025 Season 2

#3

mmbr1606 275 Super User 2025 Season 2

Last month Overall leaderboard

Featured topics

Product updates

Microsoft Power Platform Community release plans