Database Gate 2.0 Description:

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.

Database Gate needs only ODBC 32 bit support installed in the system.

Database Gate 2.0 Features:

· Command execution
With Database Gate you can write queries, create, alter or drop tables, execute stored procedures, also using transactions (commit/rollback operation).
· Limits depend only on the driver ODBC used.
· Useful editing functions
· Database Gate helps you in editing, there are useful shortcuts to minimize the writing of standard SQL statements. There are also smart shortcuts, you have only to select the name of a table and it writes for you the columns list for the select or insert statement.
· You have also custom shortcuts by using the macro keys.
· A query history helps you in recalling your previous statements. You can have the tables list in the edit box to easily choose the name you need without to write it.
· Bookmark signs make easy the browsing in your SQL code.

· Syntax Highlighting
The Syntax Highlighting helps you in writing your SQL statements. The Word and Context Completation funtions make faster your tipying.

· Schema Browser
You can get information about all the tables available in the database (system or user ones), or get the columns list, primary key, foreign keys, indexes of a table. You can get information also about stored procedures and their parameters. There is an useful object browser to see this kind of information in a graphic way.

· Import/Export functions
Database Gate allows you also to export data of a table from a database and import the same data into a different database, with an unique transaction or with a transaction for every record imported, always using only ODBC.
Export records can be done also in HTML or XML format to easily publish your database data into the web.

· Multiple servers support
Database Gate allows you to connect to different kind of database at the same time (it's a MDI Application). You can also open multiple query windows for every connection.

· Batch execution
With the batch language you can do in automatic way particular tasks (SQL commands, import o export operations).

· Schema Diff
Schema diff compares two different data sources and finds table differences for columns type, size, nullability, primary and foreign keys.

· Schema and Data Retrieving
· Schema and data retrieving gets the tables and views structure, with primary and foreign keys that can be written in the create statements or with alter table statements.
It also retrieves the records, optionally with a record quantity limit.

· Easy to install
Database Gate is a 32 bit .exe file for Windows, it needs only ODBC 32 bit support installed in the system, and the ODBC drivers you want to use. No other DLL/OCX are required, no setup, no registry keys written. You can run it also from a floppy.

· Other functions
· You can print SQL statements or only the selected text or the result set in the grid.
· You can manage the Data Source Names in your system directly in Database Gate.
· You can copy into the clipboard the selected query in the following format: Visual Basic, C++, C#

Related searches:

universal sql editor - aglowsoft sql query tools

Database Gate security information

You cannot download any crack or serial number for Database Gate on this page. Every software that you are able to download on our site is legal. There is no crack, serial number, hack or activation key for Database Gate present here. Our collection also doesn't contain any keygens, because keygen programs are being used in illegal ways which we do not support. All software that you can find here is freely downloadable and legal.

Database Gate installation package is prepared to be downloaded from our fast download servers. It is checked for possible viruses and is proven to be 100% clean and safe. Various leading antiviruses have been used to test Database Gate, if it contains any viruses. No infections have been found and downloading Database Gate is completelly problem free because of that reason. Our experts on malware detection tested Database Gate with various spyware and malware detection programs, including fyxm.net custom malware and spyware detection, and absolutelly no malware or spyware was found in Database Gate.

All software that you can find on our servers, including Database Gate, is either freeware, shareware or open-source, some of the software packages are demo, trial or patch versions and if possible (public domain licence), we also host official full versions of software.

Because we want to be one of the fastest download sites on the web, we host all the software including Database Gate on our servers. You cannot find here any torrents or download links that would lead you to dangerous sites.

Fyxm.net does support free software, however we do not support warez or illegal downloads. Warez is harming producers of the software.

Enjoy!