Try our script https://github.com/appronto/scripts/blob/master/restorebackupDRAGBACKUPGZ_HERE.bat
and feel free the contribute on the script :)
Arthur,
the cloud environments use postgres as database, so with an installed postgres database locally things are pretty straightforward.