Best Practices/Guidance on upgrading a remote database module about iotedge HOT 3 CLOSED

@tcochunk - Please consider the following documented approaches for interacting with a SQL database using IoT Edge:

1. https://learn.microsoft.com/en-us/azure/iot-edge/tutorial-store-data-sql-server?view=iotedge-1.4
2. https://learn.microsoft.com/en-us/azure/azure-sql-edge/overview

from iotedge.

@nlcamp thank you for the response. I read the articles and it seems like they are about using the database and some maintenance for a local edge device. That is not really what i am asking. I am looking for the ability to run sql commands (maybe to update the schema or update data) for a device that i dont have physical access too because it is at a remote location. I have not been able to find any guidance on this and i have to believe this is a common problem in the iot space.

imagine i develop a product running on a RPI for reading garden soil moisture and store the data in a database. Imagine the database is synced with the cloud so they can get information on their phone. now lets says i figure out how to read the temperature of the soil and need to add a temperature column to the database at all the millions of customers who have bought the product spread across the world. What is the recommended best practice for doing that?

since the data needs to survive container restarts, the container has a mounted volume where the data resides so just deploying a new container with a new schema does not seem like it would retain the data (maybe there is a trick that i dont know about)???

from iotedge.

Hi @tcochunk,

We unfortunately can't give and specific guidance on your individual scenario as this doesn't appear to be an IoT Edge product related question and more about updating distributed databases with new features/scenarios.

Closing for now, please reopen if you have an IoT Edge product related question.

Ryan

from iotedge.