Database Utilities 5

GiPo@DB_Utilities is a set of utilities for Windows 95/98/ME/NT/2000/XP that provide an easy way to work with different OLE DB- and ODBC-compatible databases and data sources such as Microsoft SQL Server 7.0/2000, Oracle DBMS, Informix, MySQL, DB2, Microsoft Access, dBase, Paradox, FoxPro, Visual FoxPro and many other databases that have OLE DB providers.

The GiPo@DB_Utilities pack contains the following components:

* GiPo@DB_Explorer - the Windows Explorer-like program that can be used for the database visual editing and navigation.
* GiPo@DB_Viewer - the special version of the GiPo@DB_Explorer for the read-only access to database.
* GiPo@DB_Console - the program that can execute SQL Queries and display their results as a plain text.


The GiPo@DB_Explorer allows the database management in the Windows Explorer-like way. It provides the data tree, the data list, and the SQL query window. You can open a database and explore data structure without any problems. You can also view and edit LONG TEXT and BLOB fields in the special BLOB-preview window. The tool allows to manage (view and change) BLOB fields that contain images. Many popular image formats are supported (BMP, JPEG, GIF, etc.).

Main features of GiPo@DB_Utilities:

* provides the visual browsing and editing for OLEDB- and ODBC-compatible databases.
* supports the connection to a DB using Microsoft Universal Data Link (UDL) files.
* supports the connecting to ODBC sources.
* provides the special connection dialog for the most popular databases (Microsoft SQL Server, Oracle, Inprice Interbase, FireBird, Yaffil, MySql, Microsoft Access, Microsoft FoxPro, dBase, Microsoft Excel).
* supports saving an existing connection to a Microsoft Universal Data Link (UDL) file.
* displays tables, table views, store procedure list, system tables, and system views.
* allows to view and edit the existing rows and to insert new rows.
* allows to view and edit LONG TEXT and BLOB fields.
* provides the image management for BLOB fields.
* provides the quick database navigation and search.
* allows to export rows to an external file, or to copy them to the Clipboard.
* allows to view the table information (columns, indexes).
* allows to view the stored procedure information (parameters, columns).
* provides the stored procedure execution.
* provides the SQL queries execution.
* supports the SQL queries with parameters.
* provides the table management (create table, drop table, add column, alter column, drop column).
* provides the table view management (create view, drop view).
* provides the stored procedure management (create, drop procedure).
* provides the SELECT Query Wizard.
* provides the SQL editor with the syntax highlight.
* provides the 'read-only' and 'DB editing' work modes.
* displays query results as a plain text.
* provides special tools for Microsoft Access (create a new database; compact, encrypt, protect an existing database).