Delphi Flexible InterBase AdminUtility Sample Tours You Through Powerful InterBase Features

[FireWind]

Flexible InterBase AdminUtility Sample Tours You Through Powerful InterBase Features
February 11, 2021 By Konstantin Tomov

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 UsersTab:
  • Click Refresh Users to get all the users from the InterBase server.
• BackupTab:
  • 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.
• RestoreTab:
  • 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.
• ValidateTab:
  • 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 | Samplesand then navigate to:
  • Object PascalDatabaseFireDACSamplesDBMS SpecificInterBaseAdmin
• Subversion Repository:
  • You can find Delphi code samples in Для просмотра ссылки Войди или Зарегистрируйся. 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 Для просмотра ссылки Войди или Зарегистрируйся and Для просмотра ссылки Войди или Зарегистрируйся to connect to the InterBase server.

The sample uses a Для просмотра ссылки Войди или Зарегистрируйся from dmAdmin to display the table with the InterBase server users on the Для просмотра ссылки Войди или Зарегистрируйся of the main form.

The Для просмотра ссылки Войди или Зарегистрируйся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:

Для просмотра ссылки Войди или Зарегистрируйся
Для просмотра ссылки Войди или Зарегистрируйся