Automatically backup database binaries prior to any migration operations

[miyconst]

[ubbeK]

What is the proper solution for such implementation?

I want to create a new installer (using WiX) pretty soon, https://github.com/Starcounter/AdminTrack/issues/347#issuecomment-346615058. I was thinking that there should be an opt-out option to copy the current database into some other folder, before installing new binaries.

[miyconst]

I would prefer zipping current databases into a package like database-backup-yyyy.MM.dd.HH.mm.zip where database is the name of the database, and yyyy.MM.dd.HH.mm is the backup date and time.

[k-rus]

I would prefer zipping current databases into a package like database-backup-yyyy.MM.dd.HH.mm.zip where database is the name of the database, and yyyy.MM.dd.HH.mm is the backup date and time.

Note the installer will need to take care if backing up will fail due to different reasons.