SQL Diagnosis: Difference between revisions

From eStream Software
Line 41: Line 41:
==Database Validate==
==Database Validate==
* A function use to fix database corrupt
* A function use to fix database corrupt
===Steps===
:01. Click '''Database Validate''' button (Icon B).
[[File:SQLDiagnosis-DatabaseValidate-01.jpg|center]]
:02. Click This button to select the SQL Firebird Database.
:03. Click '''Validate''' button.
<div style="float: right;">  [[#top|[top]]]</div>
<div style="float: right;">  [[#top|[top]]]</div>



Revision as of 04:33, 26 November 2016

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

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.

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.