Flexible InterBase AdminUtility Sample Tours You Through Powerful InterBase Features

The sample also admits authentication.

Apart from the parameters to connect to an InterBase server, the sample has four tabs to perform administrative tasks:

• Server Users Tab:
  • Click Refresh Users to get all the users from the InterBase server.
• Backup Tab:
  • Use this tab to backup a database. Introduce the Database Path to specify the InterBase database and the Backup Path to specify the backup destination file (*.ibk). You can also select several options to perform the backup.
  • Click Backup to start the backup.
• Restore Tab:
  • Use this tab to restore a database from a backup. Introduce the Backup Path to specify the backup source file (*.ibk) and the Restore Path to specify the InterBase database. You can also select several options to restore the backup.
  • Click Restore to start the restoration.
• Validate Tab:
  • Use this tab to validate the integrity of an InterBase database.
  • Click Validate to start the validation.

Location

You can find the AdminUtility project at:

• Start | Programs | Embarcadero RAD Studio Sydney | Samples and then navigate to:
  • Object PascalDatabaseFireDACSamplesDBMS SpecificInterBaseAdmin
• Subversion Repository:
  • You can find Delphi code samples in GitHub Repositories. Search by name into the samples repositories according to your RAD Studio version.

How to Use the Sample

1. Navigate to the location given above and open IBAdminTool.dproj.
2. Press F9 or choose Run > Run.
3. Use the parameters by default to connect to the local InterBase server with the default SYSDBA user.
4. You can perform administrative tasks with the functionality of the four tabs.

Files

File	Contains
IBAdminTool.dproj	The project itself.
dmAdmin.pas/dfm	The data module containing the components and code for the admin tasks.
AdminUtility.pas/fmx	The main form and code calling the data module methods to perform admin tasks.

Implementation

The main functionality of the project is implemented on dmAdmin where the FireDAC components are placed. It uses TFDPhysIBDriverLink and TFDGUIxWaitCursor to connect to the InterBase server.

The sample uses a TFDMemTable from dmAdmin to display the table with the InterBase server users on the TStringGrid of the main form.

The TOpenDialog component is used to open a dialog to select the paths on the admin tasks filtering the InterBase Backups: *.ibk.

For more information and extra links to other information please refer to the below link:

http://docwiki.embarcadero.com/CodeExamples/Sydney/en/FireDAC.InterBase_AdminUtility_Sample

Head over and check out the full source code for the InterBase AdminUtility sample in Embarcadero’s GitHub.