PowerDBTools
|
PowerDBTools is the most perfect software for Database Administrators, Developers and System Testers, based on Microsoft OLE DB technologies. It will help you manage, develop and maintain your databases. It is the perfect solution since the same tool can be used on all major operating systems accessing a wide range of databases.
The PowerDBTools (Power Database Tools) is a strong tool which allows you to manage multiple databases (of the same or different type, such as MS Access, MS SQL Server, Oracle, MySQL, etc.) within one application. In general, each type of database provides its own specific tools (such as MS Access Application, Microsoft SQL Server Enterprise Manager, etc.) to manage, which are too specific and require appropriate skills.
PowerDBTools allows managing almost all types of databases in the same way (using the same user-friendly interfaces) as well as provides many additional new features (such as compare, convert, find, etc.) which can be very useful for database users and administrators.
PowerDBTools manages database in terms of database object and its properties (i.e. Table, View, Procedure, Function, Datatype, Sequence, Column, Index, Primary Key, Foreign Key, Trigger, Constraint) and based on Microsoft ADO (ActiveX Data Objects) and DAO (Data Access Objects) technologies. For more information about ADO and DAO technologies, refer to the appropriate manuals or online help.
Features in PowerDBTools: PowerDBTools
1. PowerDBTools is based on Microsoft OLEDB technologies.
2. All databases available via Microsoft Data Link (OLEDB) providers are supported.
Database Browser
1. Navigation through all database objects (tables, columns, indexes, keys, etc.).
2. Browsing object details and invoking management features (create/rename/delete).
Index Browser
1. Navigation through all database indexes (including Primary and Foreign Keys).
2. Checking and correcting indexes/keys names.
3. Indexes/keys validation.
Relations Manager
* Visual relations (Foreign Keys) management tool.
Query Manager
1. SQL editor (SQL templates, built in functions).
2. Visual query builder.
3. Hierarchy data support (shape recordset).
Data Management
1. Showing and editing database data support (created via SQL statement).
2. Showing and editing BLOB type columns data support (image, HTML, RTF).
3. Column data statistics.
Find Engine
* Database objects (tables, columns, etc.) search by name.
Columns search by their default values, descriptions, values and types.
* Unused columns search in the database.
Property Browser
* Navigation through all database object properties.
Tools
1. Compare databases.
2. Convert database (including data).
3. Easy backup, restore, attach, detach databases (SQL Server only).
4. Generate SQL script for database conversion.
Schema Browser
* Navigation through all database schema objects.
Reports
* View/Print database objects reports.
Additional features
* User options, layout customization, lookups creation, etc.
The license of this software is Free Trial Software, the price is $199.00, you can free download and get a free trial.

