Migrate Standard Data Model Sites to Enhanced Data Model (Preview)

We are excited to announce that the Power Pages CLI now supports the pac powerpages migrate-datamodel command, currently in preview. This new feature facilitates the migration of your existing standard data model site to an enhanced data model.

Note: This feature requires Microsoft Power Platform CLI version 1.31.6 or above. Install latest Power Platform CLI

At present, we only support the migration of sites created using the following Power Pages templates that are compatible with the enhanced data model. We plan to extend support to more templates soon:

  • Starter layout 1-5
  • Application processing
  • Blank page
  • Program registration
  • Schedule and manage meetings

Key Features and Capabilities

The new feature introduces the following capabilities:

  1. Generate a site customization report
  2. Migrate configuration data and configuration data references
  3. Monitor migration status
  4. Upgrade site data model version to the enhanced data model
  5. Revert the migrated site’s data model version back to the standard data model

Generate a Site Customization Report

This capability allows you to identify customizations in the standard data model site that may not be compatible with the enhanced data model site. You can run the following command to generate a report and address highlighted issues after migrating site configuration data to the enhanced data model.

pac powerpages migrate-datamodel --webSiteId d46d6546-1af0-ee11-904b-6045bdefabe9 --siteCustomizationReportPath "C:\\code\\demo-edm-migration"

To find solutions for the highlighted issues in report, please refer to the Considerations for site customization when migrating sites from standard to enhanced data model section in the document.

Note
In the enhanced data model, changes to the configuration tables are not allowed, whereas such modifications were permitted in the adx tables (standard data model tables prefixed with adx_. Refer to the Virtual tables document section for more information). If you’ve made any modifications in the standard data model, these will need to be accommodated in the enhanced data model. Here are some typical modifications you may have made in the standard data model on configuration tables, which are not compatible with the enhanced data model. To learn how to handle these in the enhanced data model, please follow the corresponding links.

Migrate Configuration Data and Configuration Data References

This feature assists in migrating configuration data and configuration data references to the enhanced data model.

pac powerpages migrate-datamodel --webSiteId 076bf556-9ae6-ee11-a203-6045bdf0328e –-mode all

Monitor Migration Status

Depending on the complexity of the site, the migration process may take some time. You can use the following command to check the status of the migration.

pac powerpages migrate-datamodel --webSiteId 076bf556-9ae6-ee11-a203-6045bdf0328e --checkMigrationStatus

Upgrade Site Data Model Version to the Enhanced Data Model

Once all site configuration data and configuration data references have been migrated to the enhanced data model, you can use this final command to update your site to use the migrated enhanced data model website record.

pac powerpages migrate-datamodel --webSiteId 076bf556-9ae6-ee11-a203-6045bdf0328e --updateDatamodelVersion --portalId 04435d71-c45a-4a05-9702-8f127559e48e

Please note that users will encounter an error in the console if they do not have the appropriate roles. This admin action requires users to have one of the following admin roles:

Revert the Migrated Site’s Data Model Version Back to the Standard Data Model

After your site has been updated to use the enhanced data model, you can test it to ensure everything is functioning correctly. If you encounter any issues, you can revert back to the standard data model using the following command. This is an admin action and requires users to have one of the admin roles mentioned above.

pac powerpages migrate-datamodel --webSiteId 076bf556-9ae6-ee11-a203-6045bdf0328e --revertToStandardDataModel --portalId 07f35d71-c45a-4a05-9702-8f127559e48e

We Value Your Feedback

Your feedback is crucial in helping us enhance and improve the capabilities of this feature. We are eager to hear from you!

For more details about this feature, please refer to the documentation.