Introduction to the SQL Anywhere Database unconventional recovery tool readasadb

Source: Internet
Author: User

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)

    1. Applicable to All SQL Anywhere versionsIncluding: 5.x, 6.x, 7.x, 8.x, 9.x, 10.x, 11.x, 12.X
    2. Applicable to All ultralite versions
    3. Able to restore table structure and data
    4. Ability to restore Custom Data Types
    5. Ability to restore the syntax of objects such as stored procedures
    6. Ability to export data to the target database
    7. Ability to export to SQL files and generate import scripts
    8. Supports multiple character setsIncluding cp850, cp936, gb18030, and utf8
    9. Ability to recover unencrypted or simple encrypted data
    10. Easy to use
    11. Restrictions: AES-encrypted data files are not supported.

Iii. Applicable scenarios of readasadb

Various misoperations:

    1. Truncate table)
    2. Drop table)
    3. Incorrect where condition accidentally deletes data
    4. Accidental deletion of DB or log files
    5. 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

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.