MYdbPAL is a fully functional, high performance database design, development and ETL toolkit. It is the dbPAL family that has received tremendous interest in database administrator and software developer communities around the world since it was first release in 2001. MYdbPAL will import seamlessly from most DBMS types offering powerful data import, mapping and schema conversion capability.
DATABASE DESIGN STUDIO
dbPAL's STUDIO provides a multi-dimension, desktop database approach that is uniform across all common DBMS formats. Powerful editing and viewing facilities, including cut & paste, can dramatically enhance developer performance. Also included is a powerful Data Modeling facility that allows you to create entity-relationship models from existing schemas, or to create and model new schemas.
The STUDIO breaks free from traditional schema editors allowing the user complete access to all tables, fields and other schema objects within a single viewer. The STUDIO's unique ability to cut/past/drag/drop objects within and between multiple schemas allows fast development of new and updated schemas. Conversion between database types becomes much easier with dbPAL's ability to view multiple DBMS types against each other, with differences highlighted to alert you to potential loss of data or intelligence. The Studio Editor provides complete version control, allowing users to track changes and to operate a single schema with differing database versions.
METADATA AND ETL WORKSHOP
The dbPAL WORKSHOP offers a truly extraordinary graphical environment for database operations. Simple graphical commands are used to reverse-engineer schemas, to create databases and to execute schema changes.
All schema-related commands can be output and executed as SQL scripts. Further data management commands range from simple data extraction and loads - automating data conversion along the way - to complex de-normalization and normalization techniques as well as data synchronization facilities.
Fully supporting MySQL production versions 3 and 4, MYdbPAL for MySQL provides a complete design Studio environment for application developers and database administrators. Using MYdbPAL users can achieve rapid database conversions from most modern DBMS types, then continue to use MYdbPAL for ongoing database life-cycle maintenance.