Sybase Metadata Extractor icon

Sybase Metadata Extractor

4.3/5 7
Demo   

A comprehensive application that reads backup files created for ASE Sybase and collects data in order to restore database structures. #Recover Database  #Extract Metadata  #Build Schema  #Recover  #Database  #Extract  

Description

changelog

Free Download

Sybase Metadata Extractor is a competent software, which runs from the Command Line and allows you to restore database structures or scripts. The software is capable of restructuring a database even in case there is no available information regarding it. The application can extract data from backup files.

Sybase Metadata Extractor is designed to restore schema structures for databases and ASE Sybase servers that feature no metadata or additional information. The software can extract and process the information contained within backup files, then re-build tables, columns and scripts. The software can read the backup files created with multiple editions of ASE Sybase, from version 12 up to 15.

The command line tool can read the backup files, then parse the information regarding structures, data types, columns or indexes. It can store the extracted data in a XML file, then build DDL scripts in order to create database objects and recover structures. It is highly useful, for instance, in case you wish to create a database, relying on an old backup file, which misses pieces of information that the server needs.

The useage of the application itself is simple: just run the command line tool, however, you need to create an ASE Sybase script and deploy it first. The command line parameters include the backup file location, the page size of the server that generated the backup file, as well as the output path for the XML file and the DDL script.

The data collected by the extractor includes schema name, table names, object IDs, lock schemes, columns and indexes. It gathers information regarding the names, sizes, position, data type, scale, precision or nullable variables, when it comes to columns. Also, the tool searches for the primary key, uniqueness indicator or list of columns, in order to build the indexes.

The DDL scripts that Sybase Metadata Extractor can create help you recover a database structure. Simply generate a new database, run the designated DDL script and it can generate the entire required structure.

System requirements

  • Processor: Pentium 4, 2.2 GHz or higher
  • RAM: 1 GB or more
  • HDD with NTFS: 10 MB free space

Limitations in the unregistered version

  • Obfuscates part of object names

What's new in Sybase Metadata Extractor 1.4:

  • In new version Sybase Metadata Extractor enables to recover user-defined data types.
Read the full changelog
User Comments
This enables Disqus, Inc. to process some of your data. Disqus privacy policy

Sybase Metadata Extractor 1.4

add to watchlist add to download basket send us an update REPORT
  runs on:
Windows Server 2012
Windows 2003
Windows 8 64 bit
Windows 7 64 bit
  file size:
1.3 MB
  filename:
SybaseMetadataExtractor.win.x86-64.zip
  main category:
Internet
  developer:
  visit homepage