SQL Anywhere Database Unconventional recovery Tool READASADB usage Introduction

SQL Anywhere database non-routine recovery tool

READASADB---an industry-leading recovery tool that does not rely on database management systems to extract data directly from DB Files!

I. Introduction to SQL Anywhere, Ultralite
SQL Anywhere A maintenance-free, easy-to-manage mobile database.

SQL Anywhere provides enterprise-class functionality, including full transactional processing, unmatched reliability, and functionality, including referential integrity, stored procedures, triggers, row-level locks, automated task scheduling, and auto-recovery capabilities

• Easy to use, easy to manage, and lower end-user overhead!

• Multi-platform Support

• High resource efficiency

• Companion Timing Data Synchronization tool Mobilink

UltraLite is a relational database with synchronization capabilities for small, mobile, and embedded devices

• Robust data management

• Powerful Sync Features

• Direct and concise development

• Multi-platform Availability

You can develop and deploy UltraLite database applications for Windows CE, Palm OS, and Java-based devices!

Second, readasadb function
Unconventional recovery tool capable of extracting data from corrupted SQL anywhere data files (. db) and Ultralite data files (. udb)

1. Available for all versions of SQL Anywhere include: 5.x,6.x,7.x,8.x,9.x,10.x,11.x,12.x

2. Applies to all versions of Ultralite

3. Ability to recover table structure and data

4. Ability to recover custom data types

5. The ability to recover the syntax of objects such as stored procedures

6. Ability to export to the target database

7. Ability to export to SQL file and generate import script

8. Supports multiple character sets including: cp850, cp936, GB18030, UTF8, etc.

9. Ability to recover data from unencrypted or simple encryption types

10. Simple to use

11. Limitation: AES-Encrypted data files are not supported

Three, readasadb applicable scene

Various mis-operation:

1. False truncation tables (TRUNCATE TABLE)

2. Delete Tables by mistake (drop table)

3. Wrong where condition delete data by mistake

4. Deleting a DB or log file by mistake

5. Mistakenly delete a field from a table

Iv. readasadb Data recovery process
About the tool readasadb can also refer to my blog:
Developed a tool to recover data from Sybase SQL anywhere db files
ASA Database Physical storage Structure Analysis (1)
ASA Database Physical storage Structure Analysis (2)

Browse Operation Process Video:

650) this.width=650; "alt=" SQL anywhere Recovery Tool Introduction 1 "src=" http://www.dbainfo.net/wp-content/uploads/2013/04/SQL% 20anywhere%20unusual%20recovery%20tool%20readasadb%20introduction%20%281%29.jpg "/>

650) this.width=650; "alt=" SQL Anywhere Recovery Tool Introduction 2 "src=" http://www.dbainfo.net/wp-content/uploads/2013/04/SQL% 20anywhere%20unusual%20recovery%20tool%20readasadb%20introduction%20%282%29.jpg "/>

650) this.width=650; "alt=" SQL Anywhere Recovery Tool Introduction 3 "Src=" http://www.dbainfo.net/wp-content/uploads/2013/04/SQL% 20anywhere%20unusual%20recovery%20tool%20readasadb%20introduction%20%283%29.jpg "/>

650) this.width=650; "alt=" SQL Anywhere Recovery Tool Introduction 4 "src=" http://www.dbainfo.net/wp-content/uploads/2013/04/SQL% 20anywhere%20unusual%20recovery%20tool%20readasadb%20introduction%20%284%29.jpg "/>

650) this.width=650; "alt=" SQL Anywhere Recovery Tool Introduction 5 "src=" http://www.dbainfo.net/wp-content/uploads/2013/04/SQL% 20anywhere%20unusual%20recovery%20tool%20readasadb%20introduction%20%285%29.jpg "/>

650) this.width=650; "alt=" SQL anywhere Recovery Tool Introduction 6 "src=" http://www.dbainfo.net/wp-content/uploads/2013/04/SQL% 20anywhere%20unusual%20recovery%20tool%20readasadb%20introduction%20%286%29.jpg "/>

650) this.width=650; "alt=" SQL anywhere Recovery Tool Introduction 7 "Src=" http://www.dbainfo.net/wp-content/uploads/2013/04/SQL% 20anywhere%20unusual%20recovery%20tool%20readasadb%20introduction%20%287%29.jpg "/>

650) this.width=650; "alt=" SQL anywhere Recovery Tool Introduction 8 "src=" http://www.dbainfo.net/wp-content/uploads/2013/04/SQL% 20anywhere%20unusual%20recovery%20tool%20readasadb%20introduction%20%288%29.jpg "/>

650) this.width=650; "alt=" SQL Anywhere Recovery Tool Introduction 9 "src=" http://www.dbainfo.net/wp-content/uploads/2013/04/SQL% 20anywhere%20unusual%20recovery%20tool%20readasadb%20introduction%20%289%29.jpg "/>

650) this.width=650; "alt=" SQL Anywhere Recovery Tool Introduction "src=" http://www.dbainfo.net/wp-content/uploads/2013/04/SQL% 20anywhere%20unusual%20recovery%20tool%20readasadb%20introduction%20%2810%29.jpg "/>

650) this.width=650; "alt=" SQL anywhere recovery Tool Introduction to "src=" http://www.dbainfo.net/wp-content/uploads/2013/04/SQL% 20anywhere%20unusual%20recovery%20tool%20readasadb%20introduction%20%2811%29.jpg "/>

650) this.width=650; "alt=" SQL anywhere recovery Tool Introduction to "src=" http://www.dbainfo.net/wp-content/uploads/2013/04/SQL% 20anywhere%20unusual%20recovery%20tool%20readasadb%20introduction%20%2812%29.jpg "/>

650) this.width=650; "alt=" SQL Anywhere Recovery Tool Introduction "src=" http://www.dbainfo.net/wp-content/uploads/2013/04/SQL% 20anywhere%20unusual%20recovery%20tool%20readasadb%20introduction%20%2813%29.jpg "/>

650) this.width=650; "alt=" SQL Anywhere Recovery Tool Introduction "src=" http://www.dbainfo.net/wp-content/uploads/2013/04/SQL% 20anywhere%20unusual%20recovery%20tool%20readasadb%20introduction%20%2814%29.jpg "/>

650) this.width=650; "alt=" SQL anywhere recovery Tool Introduction to "src=" http://www.dbainfo.net/wp-content/uploads/2013/04/SQL% 20anywhere%20unusual%20recovery%20tool%20readasadb%20introduction%20%2815%29.jpg "/>

650) this.width=650; "alt=" SQL anywhere recovery Tool Introduction to "src=" http://www.dbainfo.net/wp-content/uploads/2013/04/SQL% 20anywhere%20unusual%20recovery%20tool%20readasadb%20introduction%20%2816%29.jpg "/>

650) this.width=650; "alt=" SQL anywhere recovery Tool Introduction to "src=" http://www.dbainfo.net/wp-content/uploads/2013/04/SQL% 20anywhere%20unusual%20recovery%20tool%20readasadb%20introduction%20%2817%29.jpg "/>

650) this.width=650; "alt=" SQL Anywhere Recovery Tool Introduction "src=" http://www.dbainfo.net/wp-content/uploads/2013/04/SQL% 20anywhere%20unusual%20recovery%20tool%20readasadb%20introduction%20%2818%29.jpg "/>

650) this.width=650; "alt=" SQL Anywhere Recovery Tool Introduction "src=" http://www.dbainfo.net/wp-content/uploads/2013/04/SQL% 20anywhere%20unusual%20recovery%20tool%20readasadb%20introduction%20%2819%29.jpg "/>

650) this.width=650; "alt=" SQL Anywhere Recovery Tool Introduction "src=" http://www.dbainfo.net/wp-content/uploads/2013/04/SQL% 20anywhere%20unusual%20recovery%20tool%20readasadb%20introduction%20%2820%29.jpg "/>

650) this.width=650; "alt=" SQL Anywhere Recovery Tool Introduction "src=" http://www.dbainfo.net/wp-content/uploads/2013/04/SQL% 20anywhere%20unusual%20recovery%20tool%20readasadb%20introduction%20%2821%29.jpg "/>

650) this.width=650; "alt=" SQL anywhere recovery Tool Introduction to "src=" http://www.dbainfo.net/wp-content/uploads/2013/04/SQL% 20anywhere%20unusual%20recovery%20tool%20readasadb%20introduction%20%2822%29.jpg "/>

650) this.width=650; "alt=" SQL anywhere Recovery Tool description of "src=" http://www.dbainfo.net/wp-content/uploads/2013/04/SQL% 20anywhere%20unusual%20recovery%20tool%20readasadb%20introduction%20%2823%29.jpg "/>

Video Browse Address: http://www.dbainfo.net/wp-content/uploads/file/SQL_Anywhere_Recovery_Tool-ReadASADB-demo.swf

Slide Format: Introduction to the SQL anywhere recovery tool. ppt

This article is from the Sybase database technology blog, so be sure to keep this source http://dbainfo.blog.51cto.com/202416/1591355

SQL Anywhere Database Unconventional recovery Tool READASADB usage Introduction