Delphifreak suggested a GUI for a command line utility that goes with Firebird. This is how he/she specified it:
Interbase/Firebird does not release disk space if you delete records. So our testing database was growing and some folk came and asked me if I could shrink it because they want to make a small setup.exe. I ended up with the command line tool called "gbak" which is included in the firebird-server installation.
So since yesterday I am thinking of making a little GUI for "gbak" to make this task more user friendly.
This will export the database:
gbak -v -t -l -k -g -user SYSDBA -password "masterkey" SourceDB.gdb SourceDBBackup.fbk
This will create and import the database:
gbak -c -v -k -user SYSDBA -password "masterkey" SourceDBBackup.fbk TargetDB.gdb
Here are the requirements for this little app:
- a setting to let the user choose the path to the gbak file.
- a setting to choose the source database.
- a setting to choose the name of the target database.
- a button called "Shrink" to export/import in one go.
- two fields to let the user enter login/password.
Extra points can be awarded to entries that run on Linux as well as on Windows. And extra points are also awarded for entries that have the above command lines as configurable options in the software so the GUI can be used for more command line programs.