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.

Database Validate

  • A function use to fix database corrupt

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"