Database Gate is SQL editor able to connect to every kind of database using ODBC.
You can write and execute queries, create, alter or drop tables, execute stored procedures, get information about all the objects in the database, the columns list/primary or foreign keys/indexes of a table with the Object and Table browser, export/import data, also in HTML, with or without transaction.Database Gate allows you to connect to different kind of database at the same time and helps you in editing, there are useful shortcuts to minimize the writing of standard SQL statements and formatting text tools.
You have also custom shortcuts by using the macro keys. The Syntax Highlighting, Words and Context Completation helps you in writing your SQL statements. With the batch language you can do in automatic way particular tasks. With the Finder function you can look for objects in the database using many different criteria. Schema Diff finds the difference between two data source.
Database Gate needs only ODBC 32 bit support installed in the system.
Keywords: sql, editor, ODBC, database, table, syntax highlighting, client, server, DSN, schema diff
|
Click to enlarge
|