Re: Re: [pgsql-es-ayuda] Ingeniería inversa sobre BD existente

Existe otra muy buena llamada Power Architect(http://www.sqlpower.ca/page/architect) desarrollada por la compañia canadiense:
sqlpower.ca.
Esta herramienta es libre y esta desarrollada en Java. Actualmente esta en fase continua de desarrollo y va por la versión 0.9.13.
Aqui les dejo las features de la herramienta:
http://www.sqlpower.ca/page/architect
FEATURES

• Accesses source databases via JDBC
• Connects to multiple source databases concurrently
• Compares data models & database structures and identifies discrepancies
• Drag-and-drop source tables & columns into the playpen
• Remembers the origin of each column
• Generates source-to-target visual Mapping Reports
• Forward-engineers to PostgreSQL, Oracle, MS SQL Server & more
• Saves source data structure snapshots in the project, so you can work remotely
• All project data is stored in an easy-to-parse XML format
• GPL (version 3) licensed

The Power*Architect can also open multiple source databases concurrently, even if they are from competing database vendors. Another key feature of the Power*Architect that sets it apart from other data modeling tools, is that it remembers the origin of each column and is capable of automatically generating the source-to-target data mappings.

Whether you're building or maintaining your Data Warehouse data model, the Power*Architect will provide you a complete view of all required database structures and will expedite every aspect of your data warehouse design.

UPCOMING/RECENT RELEASES & UPDATES

The following table lists upcoming software releases & features for the Power*Architect. Version Release Date Features
0.9.11
"Abiji" July 7, 2008

• Improved Functionality including framework to support multiple languages
• Improved Undo/Redo
• Improved synchronized between the DB Tree and the Playpen
• Checks availability of newer releases
• Improved DB Tree View
• Improved Playpen View
• Easier Installation Guide and Windows Installer
• several Bug Fixes

More information
0.9.12
"Putsuga" Release Candidate:
October 31, 2008

• Added OLAP schema modeling
• Added export OLAP schema to Mondrian XML
• Added ON DELETE and ON UPDATE support to forward & reverse engineering
• Added Playpen Navigator
• Improved Korean translation
• Added Russian translation
• Improved undo/redo functionality
• Improved DDL interface & formatting
• Improved support for SQL Server 2000/2005 forward engineering
• several bug fixes

1.0.0
"Sherman"

Proposed enhancements:

• Implement critics/proofreaders system
• Improved error reporting interface in DB Tree
• Implement support for views, triggers, check constraints, stored procedures

To request changes or feature additions to Power*Architect, please visit our Forum. Power*Architect Reviews & Blogs

"What I'm using now, and recommend, is Power*Architect... I think Power*Architect has a better interface than Mogwai, creating models and generating SQL is quite easy and takes just a few clicks. Power*Architect has been declared open source just a few months ago, way to go guys!"
Ventanazul Webzine

"...delivered an ERD which is as well laid out as I have seen: even high end tools I've tried couldn't make any better job of it in the first pass."
Diary of a Database Geek

"Thank you for making my software development work a little bit more enjoyable and productive with your Power Architect tool."
Tomislav Nakic-Alfirevic

"...best ERD drawing tool I've found"
Jon's Code Blog

P:D: Para trabajar con PostgreSQL, debe ser con versiones mayores a la 8.2
Les dejo la misma a su consideración.
Les adelanto que tiene algunos problemas con el tipo de datos SERIAL ,pero ya eso estará arreglado en la versión 1.0
Saludos

----- Mensaje original -----
De: "Jimmy Raad" <jimmyraadc(at)gmail(dot)com>
Para: "Alvaro Herrera" <alvherre(at)alvh(dot)no-ip(dot)org>
CC: "Reynier Pérez Mira" <rperezm(at)uci(dot)cu>, pgsql-es-ayuda(at)postgresql(dot)org
Enviados: Miércoles, 11 de Marzo de 2009 11:30:15 GMT -05:00 Región oriental EE. UU./Canadá
Asunto: [pgsql-es-ayuda] Re: [pgsql-es-ayuda] Ingeniería inversa sobre BD existente

Tal vez te pueda servir:

Open System Architect (OSA)
http://www.codebydesign.com/

Jimmy

El 11 de marzo de 2009 10:05, Alvaro Herrera < alvherre(at)alvh(dot)no-ip(dot)org > escribió:

Reynier Pérez Mira escribió:

> Todas las que he encontrado ahí son para Windows y la gran mayoría
> propietarias, me parece que lo que me resta es montarme una máquina
> virtual, instalar güindows y ahi usar alguna de estas herramientas.
> ¿Alguna otra solución?

Hmm, una vez me mostraron uno que se llamaba DbWrench, que está en Java.
Es software privativo eso sí.

--
Alvaro Herrera http://www.amazon.com/gp/registry/3BP7BYG9PUGI8
"El hombre nunca sabe de lo que es capaz hasta que lo intenta" (C. Dickens)

--
TIP 10: no uses HTML en tu pregunta, seguro que quien responda no podrá leerlo

--

¨¨Tip 9 : Vacumm es tu amigo.......¨¨¨
Marcos Ortíz Valmaseda
Linux User # 418229
PostgreSQL 8.3.5 && Debian GNU/Linux Experimental User
Facebook Profile:
http://www.facebook.com/profile.php?id=1186800712
My blog:
http://marcosluis21.wordpress.com