- Convert database objects (table, function, view, procedure, trigger).
- Copy table data (support bulkcopy).
Compare database schemas, generate changed scripts and sync changes to target database.
Design table with columns, primary key, foreign keys, indexes, and check constraints, and it can generate table schema changed scripts from context menu.
Create new query or open existing sql file to execute select, insert, update, delete, create and alter statements. It supports intellisense.
- Generate database objects create scripts.
- Generate table insert data scripts.
Translate scripts from one database object to another. Compared to convert, this doesn't need connection to target databse.
It supports pagination, sort and filter for single table.
Clone table schema and copy data to same or different database.
Delete data of all tables.
For Oracle and MySql, it uses client tool exp and mysqldump to do that, and it can also zip file.
Diagnose invalid records of table that values are empty but columns definded as not null, and that referenced values are as same as themselves.
Delete all objects of a database, including table, view, function, procedure, and table trigger.
