Skip to content

victor-wiki/DatabaseManager

Repository files navigation

Database management tool for: SqlServer, MySql, Oracle, Postgres and SQLite.

Features

Convert Database

Convert database schemas and migrate data.

Compare Database

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

Generate Scripts

Generate scripts of database objects, including schema and data.

View Data

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

Edit Data

Edit single table data.

Import & Export Data

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

Table Copy

Clone table schema and copy data to another database.

Translate Script

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

Generate Documentation

Generate table column documentation.

Database Diagram

Dislplay all tables in one diagram, including their relations.

Clear Data

Delete data of all tables.

Diagnose Database

  • 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.

Empty Database

Delete all objects of a database.

UI - Main Page

Main Page

UI - Convert Database

Convert Database

UI - Compare Schema

Compare Schema

UI - Compare Data

Compare Data

UI - Table Designer

Table Designer

UI - Edit Data

Edit Data

UI - Translate Script

Translate Script