Hi, I am using my own server with Sql as database.
I want to know when I delete data froom ODK aggregare, it also deletes data from Sql or it stays inside it.
And I have not created any table in Sql, in which table the data is storing?
Thank you.
Hi, @Bharat_Sharma!
Aggregate will delete data from your database. The data structure is described here: https://github.com/opendatakit/opendatakit/wiki/Aggregate-Database-Structure
1 Like
Si miras, cada formulario no contiene este prefijo _ podrías crear una copia de las tablas que el formulario crea y luego eliminar así no pierdes los datos.
Hi, if you can explain more on this.
And thanks for the suggestion.
Hi, thanks for the valuable response. How I can keep data safe in database. If I delete the data from Aggregate.
How I can keep data safe in database. If I delete the data from Aggregate.
You should backup your database. The process varies depending on the database server you're using and your server's platforms. There's a docs page explaining what to do at https://docs.opendatakit.org/aggregate-backup/