Extracter

This tool conects to a catalog of a given database and extract some metadata that can be handy for revision.
The metadata are extracted to a xml file, useful for comparison (see also my project comparator),
Metadata are extracted using JDBC. Supported DBMS: MySQL and PosgreSQL.

The metadata extracted from the catalog are:

Catalog -> name
Tables -> name and if its a view.
Column-> name, type, precision, length, is null
Index -> name, is primary key, is unique, and a list of its fields.

Features

Works on Linux/Windows
Supports MySQL and PostreSQL

Project Activity

See All Activity >

License

Apache License V2.0

Follow Extracter

Extracter Web Site

Other Useful Business Software

Cut Data Warehouse Costs by 54%

Easily migrate from Snowflake, Redshift, or Databricks with free tools.

BigQuery delivers 54% lower TCO with exabyte scale and flexible pricing. Free migration tools handle the SQL translation automatically.

Try Free

Rate This Project

User Reviews

Be the first to post a review of Extracter!

Additional Project Details

Operating Systems

BSD, Linux, Windows

Languages

English

Intended Audience

Developers, Information Technology

User Interface

Console/Terminal

Programming Language

Java

Database Environment

JDBC, MySQL, PostgreSQL (pgsql)

Related Categories

Java Database Software

Registered

2013-01-24

Similar Business Software

DbVisualizer

DbVisualizer is a universal database client for anyone who works with data, from solo developers and startups to professional teams managing complex environments, including developers, DBAs, analysts, and data engineers working with relational and NoSQL databases. It offers a graphical interface...

See Software
Google Cloud SQL

Fully managed relational database service for MySQL, PostgreSQL, and SQL Server with rich extension collections, configuration flags, and developer ecosystems. New customers get $300 in free credits to spend on Cloud SQL. You won’t be charged until you upgrade. Reduce maintenance costs with...

See Software
CompareData

Compare and synchronize sql data visually. CompareData allows you to visually compare and synchronize data between sql databases. Compare table, view or query data and see differences highlighted on the screen. Compare table metadata, generate sql sync script, use the command line and...

See Software
KS DB Merge Tools

KS DB Merge Tools is an easy to use diff & merge tool for MySQL, MariaDB, Oracle Database, SQL Server, PostgreSQL, SQLite, MS Access and Cross-DBMS databases allowing to compare and sync both schema and data. Starting with a schema changes summary, results can be narrowed down to object lists of...

See Software
StrongDM

StrongDM is a People-First Access platform that gives technical staff a direct route to the critical infrastructure they need to be their most productive. End users enjoy fast, intuitive, and auditable access to the resources they need, and administrators leverage simplified workflows to enhance...

See Software
Google Cloud Platform

Google Cloud is a cloud-based service that allows you to create anything from simple websites to complex applications for businesses of all sizes. New customers get $300 in free credits to run, test, and deploy workloads. All customers can use 25+ products for free, up to monthly usage...

See Software