Hi,
Is it possible to create DB snapshots/savepoints?
Specifically in a case where you're going to do big DB manipulations (partial DB migration) and if there's an error or something that went wrong, being able to come back to the savepoint?
I may use the Database Transaction function but that can't apply here, as it would then mean that i'm able to handle my self the create & commit or rollback my transaction in an interactive way ... which is not possible when working with endpoints or functions.
In a SQL driven context, i would have a script that would duplicate my table to make a backup, and a whole bunch of little scripts to modify the foreign keys to the duplicate table (and dropping the main table) before renaming it.
Thanks for ay feedback :)
Best regards,
Guillaume
PS: if that doesn't exist, it could be transformed into a Feature Request :)