Originally Posted by Old Pedant
You will pardon me if I say that this seems to be a pretty pointless exercise. Why allow any changes, at all, to the database if you are going to reset it each day? Why not simply make all the data READ-ONLY? Then no changes can be made and you'll never need to reset it.
All the cloud applications I have seen do exactly what the OP is asking for with their demo accounts. You can use their demo accounts to try things out and the database updates actually occur. When you press the restore button or after the specified period the database is restored back the way it was.
Making a demo account read only would be a pointless exercise as then the person wouldn't be able to see the effect of their change request.
Helping others to solve their computer problem at http://www.felgall.com/