victor-wiki/DatabaseManager

README

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

UI - Convert Database

UI - Compare Schema

UI - Compare Data

UI - Table Designer

UI - Edit Data

UI - Translate Script