I use appsheet with appsheet database as the source of data.
When I make a copy of the app (with Save app to DATABASE)…sometimes it copies the data perfectly which is amazing cause I dont have to write a backup and restore script in Appscript.
but sometimes it copies only the schema??? It is weird. what coulkd be the possible causes?
Any way to automate this copy thing??
Hello @Sherin_Premkumar,
Welcome to the AppSheet community! I looked through the existing posts and I found the following related article
I hope this helps!
Thank you very much. But I am also looking for a way to automate it instead of manually doing it every time.
When you copy your app, you should be given the option of copying the data, too, not just the schema:
Thanks a lot, Steve.
Anyway I can automate this instead of manually doing it every time?
I am using Appsheet DB by the way.
The options I identified should copy the data automatically. Do they not? If not, it’s a bug and you should report it to Support. If this is not what you want automated, you’ll need to help me better understand what you want.
If you’re just looking for a general backup and restore feature for your app’s data, that’s not something AppSheet itself can do. You’d have to find an external solution.
Hello Steve,
I am actually looking for a general backup and restore option (like something that does this copy everyday at 2 AM) instead of me manually doing it.
AppSheet itself doesn’t provide that feature, so you’ll have to look elsewhere.
Got it 
Thank you very much!
