Upgrading to Advanced Insights 2.1 and later from 1.0.x and 2.0.x versions

Version 2.1 of Advanced Insights removes SQL Server dependency. Configuration data previously stored in SQL Server will now be maintained in a SQLLite database which is stored in %ProgramData%\AdvancedInsights\Data\Api\AdvancedInsightsConfig.db

All data will be migrated to this new database from SQL Server when the application first starts up following upgrade.

Once this is complete (you can confirm this by logging into Advanced Insights post-install) you can safely remove the PMPCAdvancedInsights SQL database. If you had installed SQL Express to support this requirement, this can also be removed.

Last updated