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

Enterprise-grade ITSM, for every business

Give your IT, operations, and business teams the ability to deliver exceptional services—without the complexity.

Freshservice is an intuitive, AI-powered platform that helps IT, operations, and business teams deliver exceptional service without the usual complexity. Automate repetitive tasks, resolve issues faster, and provide seamless support across the organization. From managing incidents and assets to driving smarter decisions, Freshservice makes it easy to stay efficient and scale with confidence.

Try it 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 developers, DBAs, analysts, and data engineers working with relational and NoSQL databases. It provides a graphical interface for database development, SQL querying, data exploration, and database admin. The tool includes a powerful SQL editor...

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