gem-hunter

Convert database schemas and migrate data.

Compare database schema and data, generate scripts of differences or synchronize differences to target database.

Generate scripts of database objects, including schema and data.

It supports pagination, sort and filter for single table or view.

Edit single table data.

Import data from CSV/EXCEL file using custom column mappings; Export data to CSV/EXCEL file.

Clone table schema and copy data to another database.

The translate form can translate script to one database kind to another without database connection.

Generate table column documentation.

Dislplay all tables in one diagram, including their relations.

Delete data of all tables.

• Diagnose invalid records of table that values are empty but columns definded as not null, and that referenced values are as same as themselves.
• Diagnose referenced name not match as they are defined in routine scripts.

Delete all objects of a database.