SQL Diagnosis

From eStream Software

Introduction

Is External Utility to Fixing & Managing SQL Firebird Database.

SQLDiagnosis-01.jpg

Program

History New/Updates/Changes

--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.

Todo

  • Batch Backup

Database Patch

  • A min console use to manipulate the data including edit, delete and append data.
  • There are 2 type of patch
  1. Patch From Estream
  2. Build In Patch

Steps

01. Click Database Patch button (Icon A).
SQLDiagnosis-DatabasePatch-01.jpg
02. Click This button to select the SQL Firebird Database.

Patch From Estream

03. Right Click Here
SQLDiagnosis-DatabasePatch-02.jpg
04. Select Load From File...
SQLDiagnosis-DatabasePatch-03.jpg
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.
04. Click Execute button.
Patch Type Description
AR/AP Copy Paste Error... It will
  • Create EstreamAR (Customer) & EstreamAP (Supplier)
  • Set the Invalid Transaction code to the EstreamAR/EstreamAP code...
  • After patch please go to the respective doc no, Maintain customer & maintain supplier to delete it...
Change Cash To Bank Type Change Account Type from Cash To Bank Type
  • Make sure Change the Account Code to CH2BA before run this patch
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
  • Stock Group
  • Stock Location
  • Stock Price Tag
  • Stock Batch
  • Stock Category
Remove > Default Currency Code Delete Default Currency
Remove > InValid Credit Note Remove the redundancy AR/AP Credit Note Record in GL Ledger

Database Validate

  • A function use to fix database corrupt

Steps

01. Click Database Validate button (Icon B).
SQLDiagnosis-DatabaseValidate-01.jpg
02. Click This button to select the SQL Firebird Database.
03. Click Validate button.

Template.Tips-01.jpg

You can Click few times Validate button to make sure it can maximise the database fixing


04. Click Backup button.

Adhoc Backup

  • A function use to backup the database

Steps

01. Click Adhoc Backup button (Icon C).
SQLDiagnosis-AdhocBackup-01.jpg
02. Click This button to select the SQL Firebird Database.
03. Click Backup button.
SQLDiagnosis-AdhocBackup-02.jpg
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).
SQLDiagnosis-DatabaseOnline-01.jpg
03. Click This button to select the SQL Firebird Database.