Here’s the Deal

HeidiSQL vs SQL Power Architect

437 69

5 0

When comparing HeidiSQL vs SQL Power Architect, the Slant community recommends SQL Power Architect for most people. In the question“What are the best relational database design and modelling tools?” SQL Power Architect is ranked 3rd while HeidiSQL is ranked 4th. The most important reason people chose SQL Power Architect is:

Can convert databases and copy the data from tables.

Specs

PlatformsWindows

TechnologyDelphi

Database managementPostgreSQL, MariaDB, MySQL, SQL Server, SQLite

LicenseGPL-2.0

PlatformsWindows, Linux, Unix, Mac

TechnologyJava

Ranked in these QuestionsQuestion Ranking

Common Questions

What are the best relational database design and modelling tools?

Pros

Pro
Free

Licensed under GNU GPL.

Pro
Portable

Alongside the possibility of downloading the installer and sourcecode, a portable version of the software is available.

Pro
Great UI and ease of use

HeidiSQL has a comprehensive and intuitive interface.

Pro
Syntax completion

Pro
Lightweight

Pro
Great user management

The user manager of HeidiSQL can easily set privileges on a per-database level or give access to only certain commands.

Pro
Data synchronization

HeidiSQL can compare and synchronize your data and structure between local and remote databases.

Pro
SSH tunnel

HeidiSQL allows connecting to your MySQL database via SSH tunnel.

Pro
Connect to servers via command line

You can use command line parameters to automate connections.

Pro
Works fine with Wine under Linux

Pro
Convert

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

Ad
Cons

Con
Can be buggy

HeidiSQL is known to have some bugs that results in crashes.

Con
Intellisense is not intelligent

No intellisense for columns unless table name is aliased.

Con
UI design is very bad

Generic windows form

Con
No session backup

You cannot recover your session after close or even worse crash.

Con
Works under Linux only with Wine

It works quite well under Wine with Linux, but you must always take notice if the last version of HeidiSQL has been tested, for it may not run at all. There are some bugs in the Wine version that can be annoying and you have to kill the program and restart it. A native Linux version would be great.