I have a staging and production environment which holds my drupal instance. When ever I launch changes from staging to production I run into the issue of losing submissions that are coming in from the production environment, since the form uses the drupal database.
I'm trying to find a way to read and write submissions from another database which would prevent me from losing submission data. I couldn't find an easy to read the data from another database considering that webform relies on the node table in drupal.
Does anyone have a suggestion for this problem? Other than using the webhooks, which doesn't help with reading. The most important part of this problem is reading from the write DB.