 |
| ||||
DtSQL is developed as a user-friendly and professional application that allows users to easily manage databases.
The application can create, alter, browse and search database objects, execute SQL scripts and edit database tables. It can access most databases and can be used on all major operating systems.
DtSQL supports for 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) .
Note: You can have professional e-mail technical support if you buy a license from here.
The portable version of the software can be found here.
Here are some key features of "DtSQL":
Database Browser:
· Browse schemas, tables, columns, primary and foreign keys, constraints, views, indexes, triggers, stored procedures, functions, sequences, and so on.
Database Tools:
· Create, alter, view and drop tables, views, indexes, constraints, stored procedures, functions, triggers, sequences, and so on.
Data Management:
· Edit table data including binary/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 commit.
SQL Tools:
· Edit, format and execute SQL scripts.
SQL Builder:
· Help tools to build select, insert, update, delete SQL scripts.
Import Data:
· 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 boole an pattern.
Export Data:
· Export data (single table/multiple tables/query result) in various formats such as CSV files, Excel files, XML, HTML, SQL insert statements and fixed width files. Format export data according to applied integer, date, time, timestamp, and boolean pattern
Requirements:
· Java
What's New in This Release: [ read full changelog ]
Feature:
· Support free version
Bug:
· Error in creating DB2 table
· Error in importing data to DB2 table
· Enable save button after table data is changed
Via: DtSQL 2.1.1 Build 20130202
