Have an amazing solution built in RAD Studio? Let us know. Looking for discounts? Visit our Special Offers page!
CodeDatabaseDelphiRAD Studio

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

FileContains
IBAdminTool.dprojThe project itself.
dmAdmin.pas/dfmThe data module containing the components and code for the admin tasks.
AdminUtility.pas/fmxThe 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.


Reduce development time and get to market faster with RAD Studio, Delphi, or C++Builder.
Design. Code. Compile. Deploy.
Start Free Trial   Upgrade Today

   Free Delphi Community Edition   Free C++Builder Community Edition

Related posts
C++DelphiNewsRAD Studio

RAD Studio 10.4.2 Silent Installer Makes It Easy To Automate The Installation Process

C++Delphi

Create Native And Secure iOS Wallet Enabled Apps With Delphi And C++ Builder

C++Delphi

GameDev: Fun Multi-Platform Mars Rocket Game For Android, iOS, macOS, And Windows

DelphiShowcase

Exciting Crossword Puzzle Android App Is Made In Delphi

Leave a Reply

This site uses Akismet to reduce spam. Learn how your comment data is processed.

IN THE ARTICLES