I need backup Database button

[ypersyntelykos]

Hello

I need to create a button which make backup database in windows

any help ??
thanks

[Villeroy]

Like 99% of Windows users you need a decent backup program to save all your work.

[DACM]

See: Automated file backup upon closing the database: cloud folder versioning/history and other local options

Assuming HSQLDB...

• see also: Automating database backup during a session using CHECKPOINT DEFRAG command
  
  perhaps specifically: send CHECKPOINT DEFRAG using a macro assigned to a button on a Form
  
  In addition, HSQLDB 2.x users may need to initiate automatic backup as noted here and quoted below:

  4c. HSQLDB 2.x does not maintain a .backup file by default, so if you don't see this file in your database folder, then issue the following command using the Tools > SQL console in Base to initiate "full" backup upon CHECKPOINT or SHUTDOWN. You will notice "... INCREMENT FALSE" (below) which enables "full" backup as opposed to "incremental" backup. With very large databases (Gigabyte .data file size) "incremental" backups become necessary to minimize CHECKPOINT processing delays in demanding environments. Either backup mode is sufficient.

  • • Tools > SQL...

      Code: Select all

      SET FILES BACKUP INCREMENT FALSE