[en] Migrate user activity historic data

[en] This section describes migration of user activity historic data from version 9.10 to 9.12 of Snow License Manager.

[en] Snow Event Warehouse

[en] Microsoft 365 event-sourced data is saved in the Snow License Manager database in the ew schema. Upgrading to 9.12 will install Snow Event Warehouse v1.1.7. For more information about how event data is stored, see [en] Snow Event Warehouse.

[en] SQL database changes

[en] The database schema o365 will change when upgrading to Snow License Manager 9.12. New tables are added to ew and o365 schema that are required to support the migration process.

[en] List of table changes:

[en] Table name

[en] Description

[en] [ew].[EventsRequestResultCache]

[en] Contains the copy of user activity events for the tenant.

[en] [o365].[MigrationHistoricalActivitiesProgress]

[en] Contains status of the migration process.

[en] [o365].[MigrationHistoricalActivitiesServiceActivity]

[en] Contains aggregated historical data for service activity.

[en] [o365].[MigrationHistoricalActivitiesSubscriptionPlanActivity]

[en] Contains aggregated historical data for service plan activities.

[en] [o365].[MigrationHistoricalActivitiesUserActivity]

[en] Contains aggregated historical data for total users.

[en] Preparations

[en] Before the upgrade, verify that no data aggregation from Snow Integration Manager is running or scheduled. There is no need to take a backup of the EventStore.

[en] Data migration

[en] Snow License Manager is upgraded to version 9.12 through the Snow Update Service.

[en] As soon as the upgrade is completed, the ew and o365 schema is recreated in Snow License Manager MSSQL database and the data migration process is initiated.

[en] The progress of the data migration can be seen in the Office365 logs. It is not possible to see in Snow Update Service whether data migration has been successful or not. Snow Update Service will only display when the upgrade to version 9.12 has completed, and then trigger the start of data migration.

Note

[en] The migration time depends on the Microsoft 365 data size and the number of historical events. You can not see any Microsoft 365 data in the Snow License Manager user interface before the migration has completed, so you should plan for this if you have a large event store. However, the Snow License Manager application will still be available during the migration.

[en] Important

[en] It is recommended not to run the migration in parallel with the data update job. Check that the migration process is successfully finished and then run the data update import.

[en] Track the progress of the data migration

[en] Read the Office365 log to track the data migration progress and verify its completion. The following texts will appear in the log in this given order:

  1. [en] "Starting migration"

    migration1.png
  2. [en] "Migration completed"

    migration2.png

[en] Run another Snow Integration Manager aggregation

[en] After the migration and the ReadModels have completed, run a new Snow Integration Manager aggregation to ensure that all links between users and subscriptions plans, and users and countries, are updated correctly.