FireDAC.InterBase AdminUtility Sample

From RAD Studio Code Examples
Jump to: navigation, search

This is an InterBase demo to show how to implement admin tasks using FireDAC.

Location

You can find the AdminUtility project at:

  • Start | Programs | Embarcadero RAD Studio Alexandria | Samples and then navigate to:
    • Object Pascal\Database\FireDAC\Samples\DBMS Specific\InterBase\Admin
  • Subversion Repository:
    • You can find Delphi code samples in GitHub Repositories. Search by name into the samples repositories according to your RAD Studio version.

Description

The demo establishes a connection to the Interbase localhost server by default, using the SYSDBA user. You can change these parameters to connect to a different InterBase server using a valid user name and password.

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.

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.

The InterBase components on dmAdmin are used to perform the admin tasks:

Uses

See Also

Retrieved from "http://docwiki.embarcadero.com/CodeExamples/Alexandria/e/index.php?title=FireDAC.InterBase_AdminUtility_Sample&oldid=31740"