Introduction
Is External Utility to Fixing & Managing SQL Firebird Database.
Program
- Version (2.5.0.21) - 08 Dec 2016 (Beta)
- http://www.estream.com.my/downloadfile/Fairy/SQLDiagnosisV2.zip
- MD5 :
History New/Updates/Changes
--Build 21--
- Upgrade to Version 2.5.
- Fix unable open fdb in LocalHost.
- Add Batch Backup.
- Add Schedule Backup.
- Fix AR/AP Copy Paste Patch not working in some situation.
- Fix still unable to backup in some situation.
- Fix Backup Metadata setting not correct for FB3.0 unicode
- Add Firebird Version label for Patch, Validate & Adhoc Backup.
--Build 20--
- Fix Application Name Error.
- Add DB Online function.
- Add Remove InValid CN Patch.
--Build 19--
- Fix unable to backup.
- Add Load From File... for DB Patch...
--Build 18--
- Upgrade to Version 2.4.
- Enable Support Firebird 3.0.
- Enhance Validate to support IBPump.
- Find Tune SQL Patch for New Patch Generator.
- Add Remove Maintain Customer, Supplier, Stock Item & Other Stock Maintenance.
- Add AR/AP Copy Paste Error Patch.
- Add Change Cash To Bank Type Patch.
- Add Reset Grid Layout Patch.
- Add Delete Default Currency Patch.
Requirement
- Firebird Server (even is Standalone user)
Todo
Database Patch
- A min console use to manipulate the data including edit, delete and append data.
- There are 2 type of patch
- Patch From Estream
- Build In Patch
Steps
- 01. Click Database Patch button (Icon A).
- 02. Click This button to select the SQL Firebird Database.
Patch From Estream
- 03. Right Click Here
- 04. Select Load From File...
- 05. Look for patch file (Norm begin with Patch-XXXX.sql)
- 06. Click Open button.
- 07. Click Execute... button (In Step 3 Section).
Build In Patch
- 03. Click the Arrow down button near the Execute... button.
- 04. Select the Patch from the available list.
- 05. Click Execute... button (In Steps 3 Section).
| Patch Type | Description |
|---|---|
| AR/AP Copy Paste Error... | It will
|
| Change Cash To Bank Type | Change Account Type from Cash To Bank Type
|
| Rest Grid Layout | Reset all Layout to Default. |
| Remove > InValid Payment Method... | Delete Invalid Record in Maintain Payment Method |
| Remove > Non-Stock Control Opening Balance... | Delete all Non-Stock Control Opening Balance |
| Remove > All Customer... | Delete All Maintain Customer Records |
| Remove > All Supplier... | Delete All Maintain Supplier Records |
| Remove > All Stock Item... | Delete All Maintain Item Records |
| Remove > All Other Stock Maintenance... | Delete All Other Stock Maintenance
|
| Remove > Default Currency Code | Delete Default Currency |
| Remove > InValid Credit Note | Remove the redundancy AR/AP Credit Note Detail Records in GL Ledger |
Database Validate
- A function use to fix database corrupt
Steps
- 01. Stop the Firebird Service.
- 02. Copy the database & Paste to Desktop or any folder you wanted.
- 03. Click Database Validate button (Icon B).
- 04. Click This button to select the Copied SQL Firebird Database.
- 05. Click Validate button.
|
- 06. Click Backup... button.
| Function | Description |
|---|---|
| Backup Metadata... | To Extract Empty Database Structure for IB Pump to copy to New Database. |
| IB Pump... | Open the Database Pump which use to Copy data to New Database. |
| Direct Zip... | Use this to Zip & upload to Estream if still unable to fix the problem. |
Adhoc Backup
- A function use to backup the database
Steps
- 01. Click Adhoc Backup button (Icon C).
- 02. Click This button to select the SQL Firebird Database.
- 03. Click Backup button.
- 04. Select the Backup Folder (Default will Save to Desktop).
- 05. Click OK to Start Backup.
Database Online
- A function to bring back the database online when facing error "Database Shutdown"
Steps
- 01. Restart the Firebird.
- 02. Click Database Online button (Icon D).
- 03. Click This button to select the SQL Firebird Database.
Batch Backup
- A function to batch backup for all database using 1 button click.
Steps
- 01.