SQL Maestro Group / Products / AnySQL / AnySQL Maestro / AnySQL Maestro vs Specialized tools

AnySQL Maestro vs Specialized Tools

The comparison table below shows the difference between AnySQL Maestro and similar specific tools such as SQL Maestro for MySQL, MS SQL Maestro, Oracle Maestro and others. It is applied to both Freeware and Professional editions of AnySQL Maestro.

Basic features	AnySQL Maestro	Specialized Tools
Creating new tables	*
Changing table properties	*
Dropping tables
Adding columns
Changing column properties
Dropping columns	**
Commenting tables and columns	**
Creating new views	*
Changing view body
Dropping views
Creating new objects	*
Changing object properties	*
Dropping objects
Creating new constraints	*
Changing constraint properties	*
Dropping constraints
Advanced features	AnySQL Maestro	Specialized Tools
Stored Procedures and Functions
Triggers
Domains and User-Defined Types
Partitioning features
Other DBMS-specific objects
Users and Roles
Grants and Permissions
Session Browsing
Dependency Tracking
Code Debugger
Backup and Restore
Other maintenance tools

*	-	There is no GUI to set some DBMS-specific options such as TABLESPACE, PCTFREE, etc.
**	-	If DBMS supports the corresponding statement from SQL:2003.

To learn more about a specialized tool, visit its home page at: