DataBase Tools

What is DataBase Tools?

Database Tools Features

DtSQL is a universal database tool that can create, change, browse, and search database objects, run SQL scripts, and edit tables.

Supported databases

O DtSQL suporta a maioria dos bancos de dados: Cache, DB2, Derby / JavaDB, Firebird, FrontBase, H2, HSQLDB, Informix, Ingres, JDatastore, MariaDB, MaxDB, Mckoi, Mimer, MySQL, MongoDb, Oracle, Pervasive, Pointbase, PostgreSQL, Solid, SQlite , SQL Server, Sybase SQL Anywhere, Sybase Adaptive Server Enterprise (ASE).

Database browser

• Tools to search for table information and content
• Column information
• Table creating DDL
• Primary keys
• Foreign keys
• Table constraints
• Record count

• Tools to search for database view information and content
• Tools to search for database index and DDL information
• Tools to search for database trigger and DDL information
• Tools to search for information about database constraints
• Primary Keys
• Foreign keys
• Check restrictions
• Unique restrictions
• Tools to search for information about database and DDL functions
• Tools to search for information about procedures stored in the database and DDL
• Tools to search for database sequence information

Database tools

• Tools to create, change, rename, truncate, and drop tables
• Add, rename, and drop columns
• Change column data types

• Tools to create, change, rename, and drop Views
• Tools to create, change, rename, and drop indexes
• Tools to create, change, rename, and drop triggers
• Tools to create and eliminate restrictions
• Primary key
• Foreign key
• Check constraint
• Single restriction
• Tools to create, change, rename, and discard Procedures
• Tools to create, change, rename, and drop functions
• Tools to create, rename, and drop sequences

Database Management Tools

• Edit database table data, including binary /BLOB and CLOB data types.
• Format database table data according to the integer applied, timestamp, binary/BLOB, CLOB, and Boolean pattern
• Filter, sort, and search the query result.
• Insert, duplicate, update, and delete data from the table.
• Find and replace data, visualize generated SQL.
• Restore rows from the deleted database table before the update is committed
• Redo or undo changes to database table data before confirming

SQL Tools

• Format SQL scripts according to customization options
• Linked support SQL variables
• Support Run SQL
• In a single statement
• In several SQL statements
• Statement at cursor position
• Text selected as a single SQL statement
• Sort and filter database query results
• View SQL query history
• Print editor content and query to database table results

SQL Constructor

• Help tools to create selection, insert, update, and delete scripts for most databases

Import data

• Import data from the database of various formats
• CSV Files
• Excel Files
• SQL Insertion Statements
• Fixed-width files
• Analyze import database data according to boolean number, date, time, timestamp, and default

Export data

• Export data (single table / multiple tables / query result) in various formats
• CSV Files
• Excel Files
• XML files
• HTML files
• SQL Insertion Statements
• Fixed-width files
• Format export data according to the integer applied, date, time, timestamp, and Boolean pattern

Internal database

The built-in database (HSQLDB) is included in the application without any configuration

System requirements:

CPU: 1.8 GHz dual core processor

RAM: 2 GB

HDD / SSD: 50 GB of free space on the main drive

Operating system: Microsoft Windows 8 32-bit, Microsoft Windows 7 32-bit and Microsoft Windows Vista 32-bit

Resolution: 1024×768