I have a customer that has a very slow organization. Every time we need a backup from the database it takes weeks. So last week I suggested we might be able to generate a backup directly from the code, by clicking a button from within the application. To download it, and then restore it locally. Voila! I thought that was a great idea, but not sure which way to go. I have the database schema, so maybe it is enough to generate (and download) a large SQL insert script. But maybe you have some other ideas!
What DB are you using?
In our case MS SQL Server.