SQL Anywhere Database unconventional Recovery Tools
Readasadb--- An industry-leading recovery tool that does not rely on the database management system to extract data directly from DB files!
I. Introduction to SQL Anywhere and ultralite
SQL Anywhere is a maintenance-free and easy-to-manage mobile database.
SQL Anywhere provides enterprise-level functions, including full transaction processing, unparalleled reliability and functionality, including integrity, stored procedures, triggers, row-level locks, automatic task scheduling, and automatic recovery.
- Easy to use and manage, reducing end users' daily management fees!
- Multi-platform support
- High Resource Efficiency
- The related time data synchronization tool, MobiLink
Ultralite is a relational database with synchronization functions for small, mobile, and embedded devices.
- Robust Data Management
- Powerful synchronization Functions
- Direct and concise development
- Multi-platform availability
You can develop and deploy ultralite database applications for Windows CE, Palm OS, and Java-based devices.Program!
Ii. readasadb Functions
Unconventional data recovery tools that extract data from corrupted SQL Anywhere data files (. DB) and ultralite data files (. UDB)
- Applicable to All SQL Anywhere versionsIncluding: 5.x, 6.x, 7.x, 8.x, 9.x, 10.x, 11.x, 12.X
- Applicable to All ultralite versions
- Able to restore table structure and data
- Ability to restore Custom Data Types
- Ability to restore the syntax of objects such as stored procedures
- Ability to export data to the target database
- Ability to export to SQL files and generate import scripts
- Supports multiple character setsIncluding cp850, cp936, gb18030, and utf8
- Ability to recover unencrypted or simple encrypted data
- Easy to use
- Restrictions: AES-encrypted data files are not supported.
Iii. Applicable scenarios of readasadb
Various misoperations:
- Truncate table)
- Drop table)
- Incorrect where condition accidentally deletes data
- Accidental deletion of DB or log files
- Accidentally deleting fields in the table
Iv. readasadb data recovery process
For details about the readasadb tool, refer to my blog:
Developed a tool to restore data from the database file of Sybase SQL Anywhere.
Analysis of the physical storage structure of the ASA database (1)
Analysis of the physical storage structure of the ASA database (2)
Slide format: SQL anywhererecovery tool introduction .ppt