Power Platform Community Forum Thread Details

We have a model-driven app that we distribute to clients in a managed solution. Occasionally, there is a dataverse change made, like a new field added, that requires a sql script to populate or modify some data values. We would want each client to run the script in SQL4CDS when they upgrade to the new solution version. What is the best practice for distributing the sql script and getting the client to run it? Is there a better way than to share the sql script along with the solution zip and adding a note to release documentation? Should the sql script be included in the web resources perhaps?

Thanks for your input.

Categories:

Power Apps Pro Dev & ISV