When comparing SQL Power Architect vs ERBuilder, the Slant community recommends ERBuilder for most people. In the question“What are the best relational database design and modelling tools?” ERBuilder is ranked 3rd while SQL Power Architect is ranked 6th.
Ranked in these QuestionsQuestion Ranking
Can convert databases and copy the data from tables.
Pro OLAP schema modeling
Cubes, Measures, Dimensions, Hierarchies & Levels.
Pro Reverse engineering
Pro Drag and Drop
Pro Ease of use
Pro Supports many databases
Pro ER Builder is aasy to use and a complete modeling tool
Very interesting tool, powerful and easy to use. Can do reverse and forward engineering, generate SQL script, and more.
Only 8 Mb install size.
Pro Not limited
The free version does not seem limited (for personal use).
Pro Supports Amazon Redshift data modeling
Con Black & white diagrams
No colors in diagrams.
Con The manual is not free
The SQL Power Architect User Guide costs $ 99.