[power]Datamanager 1.0.3


Contents
1. Overview
2. Functions
  2.1 Database
  2.2 Table
  2.3 SQL
  2.4 Tools
  2.5 Search and Filter
  2.6 Further Information
3. Versions
4. Installation & Updates
5. Information & Registration

1. Overview
[power]Datamanager is a high-performance tool for processing and administering different databases. [power]Datamanager includes the following features:
  • Supported by a clear presentation, simple and quick access to OBDC- /BDE data sources, direct access to xBase, MySQL InterBase, MS SQL and Oracle
  • High-performance SQL Editor for the effective development of SQL statements with syntax-highlighting, SQL Builder, automatic code-completion, hotkeys and a lot more
  • Administration of SQL scripts
  • Search, filtering and sorting of tables, copying of records
  • Processing of BLOB fields as hex, memo or image format
  • Compiling of simple reports
  • Data export in various formats, such as XML, SQL script, xBase etc.
 

2. Functions

2.1 Database
Freeware Functions
  1. Open database
  2. Close database
  3. Change database log-in
  4. Renew loading of tables
  5. Add database registration, only for xBase, MySQL, InterBase, MS-SQL, Oracle
  6. Remove database registration, only for xBase, MySQL, InterBase, MS-SQL, Oracle
Standard Functions
  1. Selected tables in the tree view are opened directly when this button is activated
  2. Display SQL monitor (only MySQL, InterBase, MS-SQL, Oracle)
  3. Delete selected table in the tree view
  4. Delete selected column in the tree view
  5. Delete selected index in the tree view
  6. Rename table (only MySQL)
Database-Explorer

2.2 Table
Freeware Functions
  1. Table start
  2. 10 records back
  3. 1 record back
  4. 1 record forward
  5. 10 records forward
  6. Proceed to end of table
  7. Adjust all table columns to suitable width for displaying all columns
  8. Duplicate record
  9. Attach new record
  10. Insert new record
  11. Edit record
  12. Delete record
  13. Reject changes
  14. Save changes
  15. Reload table
  16. BLOB-/Memo editor
  17. Insert or fade out edit window
  18. Print table structure

2.3 SQL
Freeware Functions
  1. Table start
  2. 10 records back
  3. 1 record back
  4. 1 record forward
  5. 10 records forward
  6. Proceed to end of table
  7. Adjust all table columns to suitable width for displaying all columns
  8. Execute SQL statement
  9. New SQL statement
  10. Delete current SQL statement
  11. Previous SQL statement from SQL history
  12. Open SQL history as a list with all executed statements
  13. Next SQL statement from SQL history
  14. Save current statement
  15. Open a saved statement
  16. BLOB-/Memo-Viewer

2.4 Tools
Table
  1. Export function
  2. Table report
  3. Empty table
  4. Pack table (xBase only)
  5. Re-index table (xBase only)
SQL
  1. Batch-Mode on/off: execute several SQL commands one after another
  2. Parameter check on/off
  3. SQL-Builder
  4. New table
  5. New table columns
  6. New index
  7. New SQL-Editor
  8. Automatic SQL code-completion on/off
  9. Export function
  10. Table report

2.5 Search and Filter
  1. Field to be filtered
  2. Filter value
  3. Activate/deactivate filter
  4. Activate filter for the field selected in data grid with the corresponding field value
  5. Open the search dialogue. The find function enables the parallel search of a category in several selectable fields of a table. The search dialogue remains activated when the table is changed in the database explorer.



  6. Current record number : number of records

2.6 Further Information
SQL-Server
[power]Datamanager supports in its standard version the following SQL servers: MySQL, InterBase, MS-SQL and Oracle. Access to these servers requires the client libraries necessary for the corresponding SQL server.
The following server extensions are planned for in the future: PostgreSQL, DB2, SQLBase, Sybase, and Informix
 
SQL-Editor
Up to 9 SQL Editors can be opened parallel with the button . Every Editor can be activated via one of the tabs SQL1 through to SQL9 or with the keyboard combinations ALT-1 through to ALT-9.
The automatic code-completion (button ) enables a rapid and simple lay out of SQL statements. The selection of a table from the database proceeds by entering the first letter of the name of the desired table. In the selection list, the table can be selected with Return or by a double click. By entering a dot behind the name of the table, a selection list displaying the field names for the corresponding table appears, and these can in turn be selected per Return or double click. The selection list can be deactivated at all times with Esc.
 
-->

Via drag & drop of tables or fields from the database explorer, SELECT statements can be compiled in quick time without any tiresome key entering.

Frequently used SQL commands are available through the hotkeys F2, F3, F4, F5, F6, F7, F8, F9, F11, F12 (incl. the combinations with SHIFT and CTRL). The hotkeys can be can be adjusted through the hotkey editor (Menü -> Tools -> SQL -> Hotkeys...).
 


3. Versions
Freeware
The Freeware version supports the functions as described in 2.1 (except standard functions), 2.2, 2.3 and 2.5. For the purposes of evaluation, it is possible at all times to switch from the freeware version to the standard version (shareware) by activating the standard version via the menu Version -> Standard (Shareware). All further functions are activated without any running time restrictions when switching to the standard version; however, prior to every use of the standard function a notice dialogue appears and the storing of the registered SQL server is deactivated.
 
Standard (Shareware)
The registered standard version supports all the functions described here without any restrictions. For evaluation purposes the standard version can be activated from the freeware version as shareware (see above).
 
Professional (Shareware)
The Professional version of [power]Datamanager is expected to be available in summer/autumn 2002 and, in addition to aforementioned functions, it will offer the following features:
  • Integration of further SQL servers
  • Data dictionary with table and database history
  • ER diagrams
  • Database-user management
  • SQL code manager
  • Master detail views
  • Overview of other database objects such as views, trigger, stored procedures
  • Automatic generation of components and source code for Borland Delphi and Borland C++Builder
  • Extended report functions
  • ...

4. Installation & Updates
[power]Datamanager can be installed with or without BDE (Borland Database Engine ®). When BDE is not installed, ODBC/BDE data sources are not available.
Updates and bug fixes are made available at irregular intervals as installation version and as binaries from our web site at http://www.ruhrsoft.com/download/.

Installation Requirements:
  • Operating system: Microsoft Windows 9x, ME, NT 4.0, 2000, XP
  • Pentium 133 MHz, 16 MB RAM
  • Hard disk space: min. 12 MB
  • At least one installed print driver

5. Information & Registration
Information
RuhrSoft Softwareentwicklung
Paderborner Str. 21
44143 Dortmund, Germany
Tel. 0049/231/289516, Fax 0049/231/289517
Internet http://www.ruhrsoft.com
E-Mail: info@ruhrsoft.com
 
Registration
Registration fee: 250 EUR
Registration is possible either per Fax (0049/231/289517) or at http://www.ruhrsoft.com/download/