DtSQL is a database tools for developers and database administrators to query, edit, browse, and manage database objects. It can access most databases and can be used on all major operating systems. It include tools to browse objects, such as schemas, tables, columns, primary and foreign keys, constraints, views, indexes, triggers, stored procedures, functions, and sequences, tools to edit table data including binary or BLOB and CLOB data types. Filter, sort and search query result. Insert, duplicate, update, and delete table data. Find and replace data, preview generated SQL. Redo or undo last table data change before update is committing, and to edit, format, execute, build select, insert, update, and delete SQL scripts. It allows you to import data from various formats such as CSV files, Excel files, and fixed-width files. Parse import data according to integer, date, time, timestamp, and boolean pattern.
DtSQL supports most databases : Cache, DB2, Derby / JavaDB, Firebird, FrontBase, H2, HSQLDB, Informix, Ingres, JDatastore, MaxDB, Mckoi, Mimer, MySQL, Oracle, Pervasive, Pointbase, Postgres, Solid, SQlite, SQL Server, Sybase SQL Anywhere, Sybase Adaptive Server Enterprise (ASE).
What's new in this version:
Show message if try to export MongoDB data to SQL file