Re: ANN: AnySQL Maestro (freeware cross-database tool)

SQL Maestro Group announces the release of AnySQL Maestro software - a
freeware, but powerful cross-database management tool

I've only been testing it for about 15 minutes now, but I have to say
"Wow!" This will very probably replace the in-house tool I've used for
the past several years.

Thank you!

Thank was my initial impression, but it's not a complete tool. For
instance, I am connecting to a SQL Anywhere database, and I don't see a
way to explore and view stored procedures. They don't show up.

There is also no way to manager security.


AnySQL Maestro operates via ADO. It calls OpenSchema to retrieve metadata,
see
http://www.w3schools.com/ado/met_conn_openschema.asp

There is no way to extract view/procedure/trigger bodies, manage users,
grants, etc. Also OpenSchema knows nothing about DBMS specific objects, such
as tablespaces, jobs, partitions, full-text catalogs, etc.

Also AnySQL Maestro strongly depends from OLE DB Provider / ODBC Driver you
have installed. Some providers even do not return indexes and/or foreign
keys. Check constraints are not returned correctly by any driver/provider.

I think it is a very nice application,

Thanks. :)

but it is a teaser to get you to
buy the commercial products.

No (see above). It is a good solution for everyone who need only basic DBMS
features. We also don't restrict any interface features available in
commercial products (export, import, diagrams, BLOBs, etc). On the other
hand we have no objectstions for getting new customers who want complete
tools for a concrete DBMS. :-)

Best Regards,
Vadim Vinokur
SQL Maestro Group
http://www.sqlmaestro.com


.