Customers
AnySQL Maestro FAQ
You are welcome to look through the following Frequently Asked Questions list for getting to know the answers to the most commonly asked questions about AnySQL Maestro.
If you want to ask a question which is not in the list you may apply to our support team.
What is AnySQL Maestro?
AnySQL Maestro is a multi-purpose admin tool for management, control and development of any database engine (SQL Server, MySQL, MS Access, Oracle, etc.) which is available via ODBC driver or OLE DB provider. AnySQL Maestro provides you with graphical user interface (GUI) which allows you to make database operations easy and fast. Using AnySQL Maestro you can create, edit and drop database objects, build queries as visual diagrams, execute queries and SQL scripts, manage data including BLOBs, design your database as ER diagram, and use a lot of other tools designed for the easiest and most efficient work with AnySQL server.
Are there any graphical tools for building and executing queries implemented?
AnySQL Maestro provides two powerful tools which allow you either to edit query text directly with syntax highlighting and code completion or to build a query diagram visually selecting tables and fields, setting links between tables, etc.
What is the function of Generate Database Report? Does the report include data?
Generate Database Report Wizard allows you to print definitions of the database objects. To run the wizard, select the Tools | Generate Database Report main menu item. The wizard helps you to print all the database object or specify the Categories for printing according to the selected object type. The report does not include database data.
Is code completion implemented in the SQL Editor?
The Editor area is provided for working with the text of the query. For your convenience code completion is enabled. You can activate the completion list by pressing the Ctrl+Space key combination.
I cannot edit the SQL definition using the SQL tab? Why?
The reason is that you are trying to edit SQL definition within the SQL tab of the object editor. Bear in mind that this text is read-only. If you want to modify the object definition, use SQL Editor or SQL Script Editor. You can find the detailed information in the Manual.
What is the difference between Object Manager and Object Browser?
Both Object Manager and Object Browser are tools for operating on database objects designed as extensions of the Database Explorer. AnySQL Maestro provides such operations as multiple selecting of objects (for copying, dropping, etc.) and the ability of using drag-and-drop operations between Object Manager, Object Browser and Database Explorer as well as between instances of the Object Manager or Object Browser. Unlike Object Manager Object Browser represents objects as a grid with according possibilities (sorting, grouping, and filtering).
Is it possible to execute more than one query using SQL Editor?
SQL Editor provides you with an ability to execute several queries simultaneously. Each query is executed in a separate thread, so all AnySQL Maestro features remain available and there is no need to wait for your complex query to be completed.
What is a connection string? How can I make it?
AnySQL Maestro connects to a database via OLE DB provider or ODBC driver. The connection string contains the information that the provider needs to know to be able to establish a connection to the database or the data file. You can find a lot of information that is good to know about when working with connection strings at http://www.connectionstrings.com.
I know that my database contains foreign keys indeed, but your software doesn't represent them.
AnySQL Maestro works with databases via OLE DB provider or ODBC driver. It represents only the information the provider is giving.