Miscellaneous
Database Persistence and Migration
These details are for admins who need to know where the data for this plugin is because they are migrating their spaces or pages from one instance to another.
The global settings, as configured by an admin user in the "Survey and Vote" admin tool, are persisted as a CLOB of JSON in the database table AO_ECDDDB_CONFIGURATION_DAO. This data is for global admin settings and is scoped to your entire Confluence instance. It is not per space.
There are only a few settings so the easiest approach for migration is probably to set the settings to whatever you want on the new instance if you are not migrating the AO_ECDDDB_CONFIGURATION_DAO table in your database.
The definition/structure of a survey/vote macro (the questions and/or choices) are in the macro parameters, which are in the Confluence Storage Format for a page.
Therefore, there is no additional migration necessary for survey/vote definitions other than migrating the page itself.
Votes and comments are persisted using Confluence content properties and are scoped to the page that the survey/vote macro is on. The data can be found in the OS_PROPERTYENTRY table with the ENTITY_ID column being the ID of the page that the macro is on and the ENTITY_KEY being a string that starts with "vote." or "survey."
Confluence migrates the values in the OS_PROPERTYENTRY table when you migrate a page.
Migrate to Polls for Confluence Cloud
You can now migrate to Polls for Confluence cloud easily.
On migration, all Vote macros are converted to polls of type Choice or Regular, and Survey macros to polls of type Survey. The macro conversion happens when the page with the macro(s) is loaded in cloud for the first time. After the migration and loading of pages is completed, you can view the macros in the polls list under Polls Administration (app configuration) with type "Regular" or "Survey", and can perform actions with certain limitations.
Though all macros on all pages are migrated to the cloud, it is recommended that administrators look through the pages to ensure there are no errors after migration. Refer to the Polls for Confluence Migration guide to understand the migration.