How it Works
Mysql
Loading...
MAESTRO
BROCHURE
353 pgs7.39 Mb0
Table of contents
Loading...

Mysql MAESTRO BROCHURE

MySQL Maestro
User's guide
Copyright © 2002-2009 SQL Maestro Group
MySQL Maestro HelpI
Table of Contents
Foreword 0
I
................................................................................................................................... 31 Installation
................................................................................................................................... 42 Registration
................................................................................................................................... 53 License Agreement
................................................................................................................................... 74 System Requirements
................................................................................................................................... 85 About SQL Maestro Group
................................................................................................................................... 166 What's new
................................................................................................................................... 337 Getting Started
.......................................................................................................................................................... 34Explaining user interface
.......................................................................................................................................................... 35Tabbed MDI
.......................................................................................................................................................... 36First time started
.......................................................................................................................................................... 37Working with databases
.......................................................................................................................................................... 39Switching between windows
Basic principles of working with objects
II
................................................................................................................................... 411 Database Explorer
.......................................................................................................................................................... 44Filtering explorer content
................................................................................................................................... 452 Wizards and Editors
.......................................................................................................................................................... 45Create Object Wizards
......................................................................................................................................................... 46Setting object name
......................................................................................................................................................... 46Viewing commom information
.......................................................................................................................................................... 47Object Editors
......................................................................................................................................................... 48Permissions of the Object
......................................................................................................................................................... 49Object grants
......................................................................................................................................................... 51SQL Definition
......................................................................................................................................................... 52Parameter Editor
......................................................................................................................................................... 53Executing functions and procedures
................................................................................................................................... 553 Object Manager
.......................................................................................................................................................... 56Using popup menu
.......................................................................................................................................................... 56Multiple selecting of objects
................................................................................................................................... 584 Object Browser
.......................................................................................................................................................... 59Sorting database objects
.......................................................................................................................................................... 60Grouping database objects
.......................................................................................................................................................... 60Filtering database objects
................................................................................................................................... 625 Objects Duplicating
.......................................................................................................................................................... 62Duplicate Object Wizard
......................................................................................................................................................... 62Selecting source and destination databases
......................................................................................................................................................... 63Selecting object to duplicate
......................................................................................................................................................... 64Modifying new object definition
.......................................................................................................................................................... 65Duplicate Selected Object
.......................................................................................................................................................... 66Copy, Paste and Drag-n-Drop features
................................................................................................................................... 686 Changing Object Properties
1
40
© 2009 SQL Maestro Group
................................................................................................................................... 697 Describing Object
IIContents
Database Administration
III
................................................................................................................................... 721 Create Database Wizard
.......................................................................................................................................................... 72Setting connection properties
.......................................................................................................................................................... 75Specifying database properties
................................................................................................................................... 772 Database Editor
................................................................................................................................... 793 Creating Database Profiles
.......................................................................................................................................................... 79Setting connection properties
.......................................................................................................................................................... 82Selecting databases
.......................................................................................................................................................... 83Setting profile options
................................................................................................................................... 864 Editing Database Profile
.......................................................................................................................................................... 86Editing connection properties
.......................................................................................................................................................... 89Setting profile options
.......................................................................................................................................................... 90Setting default directories
.......................................................................................................................................................... 91Editing obligatory scripts to execute
.......................................................................................................................................................... 94Setting log options
Database Object Management
IV
................................................................................................................................... 981 Database Object Creation
................................................................................................................................... 992 Tables
.......................................................................................................................................................... 100Create Table Wizard
......................................................................................................................................................... 101Specifying table options
......................................................................................................................................................... 105Adding table subitems
.......................................................................................................................................................... 106Table Editor
......................................................................................................................................................... 107Editing table properties
......................................................................................................................................................... 111Managing table data
.......................................................................................................................................................... 113Fields
......................................................................................................................................................... 115Setting field parameters
.......................................................................................................................................................... 117Indexes
......................................................................................................................................................... 118Index Editor
.......................................................................................................................................................... 119Foreign Keys
......................................................................................................................................................... 120Setting reference options
.......................................................................................................................................................... 121Triggers
......................................................................................................................................................... 123Create Trigger Wizard
......................................................................................................................................... 123Specifying trigger properties
......................................................................................................................................... 124Specifying trigger definition
......................................................................................................................................................... 125Trigger Editor
......................................................................................................................................... 126Editing trigger properties
.......................................................................................................................................................... 127Foreign Key References
.......................................................................................................................................................... 129Partitions
................................................................................................................................... 1303 Views
.......................................................................................................................................................... 131Create View Wizard
......................................................................................................................................................... 132Selecting fields
......................................................................................................................................................... 133Specifing view options
.......................................................................................................................................................... 135View Editor
......................................................................................................................................................... 136Editing view properties
......................................................................................................................................................... 138Viewing data
................................................................................................................................... 1394 Procedures
.......................................................................................................................................................... 140Create Procedure Wizard
70
96
© 2009 SQL Maestro Group
II
MySQL Maestro HelpIII
......................................................................................................................................................... 141Specifying procedure options
......................................................................................................................................................... 143Managing parameters
......................................................................................................................................................... 143Specifying procedure definition
.......................................................................................................................................................... 144Procedure Editor
......................................................................................................................................................... 145Editing properties
......................................................................................................................................................... 146Viewing procedure results
................................................................................................................................... 1485 Functions
.......................................................................................................................................................... 149Create Function Wizard
......................................................................................................................................................... 150Specifying Function properties
......................................................................................................................................................... 152Managing parameters
......................................................................................................................................................... 152Specifying Function Definition
.......................................................................................................................................................... 153Function Editor
......................................................................................................................................................... 154Editing properties
......................................................................................................................................................... 156Viewing Function results
................................................................................................................................... 1586 Events
.......................................................................................................................................................... 159Create Event Wizard
......................................................................................................................................................... 160Setting event properties
......................................................................................................................................................... 161Schedule properties
......................................................................................................................................................... 162Specifying event definition
.......................................................................................................................................................... 163Event Editor
................................................................................................................................... 1667 Remote servers
.......................................................................................................................................................... 167Create Remote Server Wizard
.......................................................................................................................................................... 167Remote Server Editor
Queries
V
................................................................................................................................... 1711 Query Management
................................................................................................................................... 1722 SQL Editor
................................................................................................................................... 1783 Visual Query Builder
................................................................................................................................... 1884 Query Parameters
Server Administration
VI
................................................................................................................................... 1911 Server Editor
................................................................................................................................... 1922 Databases
................................................................................................................................... 1943 Server Variables
................................................................................................................................... 1954 Users
169
.......................................................................................................................................................... 173Working with editor area
.......................................................................................................................................................... 174Using popup menu
.......................................................................................................................................................... 175SQL Formatter
.......................................................................................................................................................... 176Executing query
.......................................................................................................................................................... 178Working with diagram area
.......................................................................................................................................................... 179Joining two objects
.......................................................................................................................................................... 181Setting criteria
.......................................................................................................................................................... 182Setting output fields
.......................................................................................................................................................... 183Setting grouping criteria
.......................................................................................................................................................... 184Setting parameters of sorting
.......................................................................................................................................................... 185Working with editor area
.......................................................................................................................................................... 186Executing query
.......................................................................................................................................................... 188Input Parameters dialog
189
.......................................................................................................................................................... 194Variable Editor
© 2009 SQL Maestro Group
................................................................................................................................... 2035 UDFs
................................................................................................................................... 2086 Character sets
IVContents
.......................................................................................................................................................... 195Create User Wizard
......................................................................................................................................................... 196Specifying user options
......................................................................................................................................................... 198Specifying user permissions
.......................................................................................................................................................... 199User Editor
......................................................................................................................................................... 200Editing user properties
......................................................................................................................................................... 201Managing user objects
.......................................................................................................................................................... 204Create UDF Wizard
......................................................................................................................................................... 204Specifying UDF options
.......................................................................................................................................................... 205UDF Editor
......................................................................................................................................................... 206Editing UDF properties
Working with data in MySQL Maestro
VII
................................................................................................................................... 2101 Data View
.......................................................................................................................................................... 211Working with data grid
.......................................................................................................................................................... 213Grouping data
.......................................................................................................................................................... 213Filtering records
.......................................................................................................................................................... 215Editing grid data
................................................................................................................................... 2172 Filter Builder Dialog
.......................................................................................................................................................... 217Invoking the Filter Builder dialog
.......................................................................................................................................................... 218Adding new condition
.......................................................................................................................................................... 219Setting filter criteria
.......................................................................................................................................................... 220Setting filter operator
.......................................................................................................................................................... 220Setting filter criteria values
.......................................................................................................................................................... 221Adding new group
.......................................................................................................................................................... 222Setting group operator
.......................................................................................................................................................... 223Applying filter conditions
................................................................................................................................... 2243 BLOB Editor
.......................................................................................................................................................... 224Navigating within the BLOB Editor
.......................................................................................................................................................... 225Editing as hexadecimal dump
.......................................................................................................................................................... 226Editing as plain text
.......................................................................................................................................................... 226Editing as HTML
................................................................................................................................... 2284 Export Data Wizard
.......................................................................................................................................................... 228Setting destination file name and format
.......................................................................................................................................................... 229Selecting fields for export
.......................................................................................................................................................... 230Adjusting data formats
.......................................................................................................................................................... 231Setting header and footer
.......................................................................................................................................................... 231Setting format-specific options
......................................................................................................................................................... 231Excel options
......................................................................................................................................................... 232Access options
......................................................................................................................................................... 233Word / RTF options
......................................................................................................................................................... 234HTML options
......................................................................................................................................................... 235PDF options
......................................................................................................................................................... 236TXT options
......................................................................................................................................................... 236CSV options
......................................................................................................................................................... 237XML options
.......................................................................................................................................................... 238Setting common export options
................................................................................................................................... 2395 Get SQL Dump
.......................................................................................................................................................... 240Selecting fields
.......................................................................................................................................................... 240Specifying dump options
209
© 2009 SQL Maestro Group
IV
MySQL Maestro HelpV
................................................................................................................................... 2426 Import Data Wizard
.......................................................................................................................................................... 243Setting source file name and format
.......................................................................................................................................................... 244Selecting data source
.......................................................................................................................................................... 245Setting fields correspondence
......................................................................................................................................................... 245Excel
......................................................................................................................................................... 246Access, DBF, XML
......................................................................................................................................................... 247TXT
......................................................................................................................................................... 248CSV
.......................................................................................................................................................... 249Adjusting data formats
.......................................................................................................................................................... 250Setting advanced field formats
.......................................................................................................................................................... 251Setting import mode
.......................................................................................................................................................... 252Customizing common options
Database Tools
VIII
254
................................................................................................................................... 2551 SQL Script Editor
................................................................................................................................... 2582 Extract Database
.......................................................................................................................................................... 259Selecting the database and the target file name
.......................................................................................................................................................... 259Selecting objects to extract their structure
.......................................................................................................................................................... 260Selecting objects to extract their data
.......................................................................................................................................................... 261Customizing script options
................................................................................................................................... 2633 Generate Database Report
.......................................................................................................................................................... 263Selecting reporting elements and setting other report options
.......................................................................................................................................................... 264Reporting objects and editing styles options
.......................................................................................................................................................... 265Editing database report style
................................................................................................................................... 2664 BLOB Viewer
.......................................................................................................................................................... 266Viewing as hexadecimal dump
.......................................................................................................................................................... 267Viewing as plain text
.......................................................................................................................................................... 268Viewing as image
.......................................................................................................................................................... 269Viewing as HTML
................................................................................................................................... 2715 Diagram Viewer
.......................................................................................................................................................... 271Customizing diagram properties
.......................................................................................................................................................... 273Exporting diagram image
................................................................................................................................... 2756 Data Analysis
.......................................................................................................................................................... 276Input SELECT query
.......................................................................................................................................................... 277Managing report data
................................................................................................................................... 2797 Database Designer
.......................................................................................................................................................... 281Designer Navigation bar
.......................................................................................................................................................... 282Database Designer Toolbox
................................................................................................................................... 2858 Process Browser
................................................................................................................................... 2869 SQL Generator
................................................................................................................................... 28710 Dialogs
.......................................................................................................................................................... 287Find Text dialog
.......................................................................................................................................................... 289Replace Text dialog
MySQL Maestro Options
IX
................................................................................................................................... 2921 Application
.......................................................................................................................................................... 292Preferences
.......................................................................................................................................................... 294Confirmations
.......................................................................................................................................................... 295Tools
291
© 2009 SQL Maestro Group
......................................................................................................................................................... 296Explorer
......................................................................................................................................................... 297Object Manager
......................................................................................................................................................... 297SQL Editor
......................................................................................................................................................... 298SQL Script Editor
......................................................................................................................................................... 299Query Builder
......................................................................................................................................................... 301BLOB Viewer
......................................................................................................................................................... 302Data Export
......................................................................................................................................................... 303Database Designer
.......................................................................................................................................................... 304Object Editors
......................................................................................................................................................... 306Table
.......................................................................................................................................................... 306Data Grid
......................................................................................................................................................... 308Options
......................................................................................................................................................... 309Colors
......................................................................................................................................................... 310Formats
......................................................................................................................................................... 311Filter
................................................................................................................................... 3132 Editors & Viewers
.......................................................................................................................................................... 313General
.......................................................................................................................................................... 315Display
.......................................................................................................................................................... 316SQL highlight
.......................................................................................................................................................... 316XML highlight
.......................................................................................................................................................... 317Code Insight
.......................................................................................................................................................... 318Code Folding
................................................................................................................................... 3203 Appearance
.......................................................................................................................................................... 321Bars and menus
.......................................................................................................................................................... 321Trees and lists
.......................................................................................................................................................... 322Edit controls
.......................................................................................................................................................... 323Check boxes
.......................................................................................................................................................... 324Buttons
.......................................................................................................................................................... 325Page controls
.......................................................................................................................................................... 326Group boxes
.......................................................................................................................................................... 327Splitters
................................................................................................................................... 3294 Export Settings
.......................................................................................................................................................... 329Specifying destination file
.......................................................................................................................................................... 330Selecting setting categories
.......................................................................................................................................................... 331Selecting database profiles
.......................................................................................................................................................... 331Saving settings
VIContents
......................................................................................................................................... 301Colors
Appendix
X
................................................................................................................................... 3341 Specifying WHERE condition
................................................................................................................................... 3392 MySQL identifiers
................................................................................................................................... 3403 Data Formats
© 2009 SQL Maestro Group
333
.......................................................................................................................................................... 334Adding new condition
.......................................................................................................................................................... 334Setting filter criteria
.......................................................................................................................................................... 335Setting filter operator
.......................................................................................................................................................... 336Setting filter criteria values
.......................................................................................................................................................... 336Setting group operator
.......................................................................................................................................................... 337Adding new group
VI
MySQL Maestro HelpVII
Index 341
© 2009 SQL Maestro Group

1 Welcome to MySQL Maestro!

MySQL Maestro is the premier Windows GUI admin tool for MySQL management, control and development. It allows you to make all the database operations easy and fast. Using MySQL Maestro you can create, edit, copy, and drop all the database objects such as tables, views, procedures, functions and queries, build queries visually, execute queries and SQL scripts, view and edit data including BLOBs, represent data as diagrams, export and import data to/from most popular file formats, manage MySQL users and use a lot of other tools designed for the easiest and most efficient work with MySQL server.
Basic MySQL Maestro features
Easy database management
MySQL Maestro allows you to create and drop databases quickly. Database profiles give you the opportunity to connect to databases in one touch and work with the selected databases only. See the Database Management for details.
Powerful database object management MySQL Maestro provides you with an ability to manage database objects (tables ,
views , procedures and functions ) in various ways. For example, you can
perform operations with a group of objects as well as with a single object in Object
Manager , sort, group and filter the database objects within Object Browser , copy
an object from one database to another by a drag-and-drop operation inside the explorer tree, use Windows clipboard to copy a set of objects and so on. For details turn to the Database Object Management section.
130 139 148
55 58
96
Welcome to MySQL Maestro! 1
70
99
Working with tables and table subobjects
MySQL Maestro wizards and editors allow you to create, edit and drop tables as well as their fields, indexes, triggers and foreign keys in a couple of simple operations. See the
Tables section to learn more.
99
Building and executing queries
MySQL 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 and so on. You can find the detailed description in the Queries section.
169
Support of the latest MySQL features
Use MySQL Maestro to work with any MySQL server version from 3.23 to 5.2 and higher! Among other features and objects implemented in the latest versions of the server, our software supports stored procedures, functions, triggers, character sets, collations, tables partitioning and so on.
Powerful data management tools With MySQL Maestro you can view and edit table data (including BLOB fields), export and import data to/from MS Excel, MS Access, DBF, XML, TXT, CSV and other formats, get SQL data dump and more. See the Data Management to learn the details.
209
Wide choice of additional tools
MySQL Maestro provides you with a number of tools for working with database metadata and SQL scripts, including code folding. There are such tools are at your disposal as BLOB Viewer, Diagram Viewer, Data Analysis and Database Designer, SQL Generator, and
© 2009 SQL Maestro Group
MySQL Maestro Help2
more. To learn more, see the Database Tools section.
254
Security management
MySQL Maestro provides you with an efficient way to manage access privileges. You can either grant/revoke permissions for a concrete database object such as table or function, or operate with user privileges.
195
Full customization according to your preferences and needs
In MySQL Maestro you can customize the behavior of all its tools, select a user interface scheme and set a lot of other preferences. All the options and their meanings are listed within the Options dialog description.
291
© 2009 SQL Maestro Group

1.1 Installation

If you install MySQL Maestro for the first time on your PC:
· download the MySQL Maestro distribution package from the download page at our
site;
· run setup.exe from the local folder and follow the instructions of the installation
wizard;
· find the MySQL Maestro shortcut in the corresponding program group of the
Windows Start menu after the installation is completed.
If you want to upgrade the installed copy of MySQL Maestro to the latest version:
· download the MySQL Maestro executable file from the download page at our site;
· unzip downloaded file to any local folder, e.g. c:\unzipped;
· exit from MySQL Maestro if it is running;
· replace previous version of MySQL Maestro by copying unzipped files to the MySQL
Maestro folder;
· run MySQL Maestro using its shortcut in the Windows Start menu.
You can also use the full distribution package to upgrade your current version of MySQL Maestro. In this case you should repeat the steps of the first-time installation. Note that the full distribution package is larger than a single executable file.
Welcome to MySQL Maestro! 3
© 2009 SQL Maestro Group
MySQL Maestro Help4

1.2 Registration

Thank you for your interest in purchasing MySQL Maestro!
You can select licensing options and register MySQL Maestro at its on-line order page. It is possible to purchase on-line, by fax, mail, toll-free phone call, or place a purchase order. We send the software activation key by email within 24 hours after completion of the order process. If you have not received the activation key within this period, please contact our sales department.
Being a registered user of any of our products, you are granted to get all the upgrades of the product (minor and major) for free within 12 (twelve) months since the purchase date. After this period you may renew your license for the next 12 months with a 30% discount.
Upon purchasing MySQL Maestro you confirm that you have tested the product and you are completely satisfied with its current version.
To obtain technical support, please visit the appropriate section on our website or contact us by email to support@sqlmaestro.com.
© 2009 SQL Maestro Group

1.3 License Agreement

Notice to users: carefully read the following legal agreement. The use of the software provided with this agreement (the "SOFTWARE") constitutes your acceptance of these terms. If you do not agree to the terms of this agreement, do not install and/or use this software. The use of this software is conditioned upon the user's compliance with the terms of this agreement.
· License grant. SQL Maestro Group grants you a license to use one copy of the
version of this SOFTWARE on any single hardware product for as many licenses as you purchase. "You" means a company, an entity or an individual. "Use" means storing, loading, installing, executing or displaying the SOFTWARE. You may not modify the SOFTWARE or disable any licensing or control features of the SOFTWARE except as an intended part of the SOFTWARE's programming features. This license is not transferable to any other company, entity or individual. You may not publish any registration information (serial numbers, registration keys, etc.) or pass it to any other company, entity or individual.
· Ownership. The SOFTWARE is owned and copyrighted by SQL Maestro Group. Your
license confers no title or ownership of the SOFTWARE and should not be construed as a sale of any rights for the SOFTWARE.
Welcome to MySQL Maestro! 5
· Copyright. The SOFTWARE is protected by the United States copyright law and
international treaty provisions. You acknowledge that no title to the intellectual property in the SOFTWARE is transferred to you. You further acknowledge that title and full ownership rights to the SOFTWARE will remain the exclusive property of SQL
Maestro Group and you will not acquire any rights to the SOFTWARE except as
expressly set forth in this license. You agree that any copies of the SOFTWARE will contain the same proprietary notices which appear on and in the SOFTWARE.
· License and distribution. An unregistered copy of the SOFTWARE ("UNREGISTERED
SOFTWARE") may be used for evaluation purposes. The UNREGISTERED SOFTWARE may be freely copied and distributed to other users for their evaluation. If you offer this UNREGISTERED SOFTWARE installation package for download, then you agree to:
· replace existing version of the UNREGISTERED SOFTWARE installation package with the
new package immediately after a new version of the SOFTWARE is released by SQL Maestro Group, or
· delete an obsolete version of the UNREGISTERED SOFTWARE installation package
immediately upon written email notice by SQL Maestro Group.
A registered copy of the SOFTWARE ("REGISTERED SOFTWARE") allows you to use the SOFTWARE only on a single computer and only by a single user at a time. If you wish to use the SOFTWARE for more than one user, you will need a separate license for each individual user. You are allowed to make one copy of the REGISTERED SOFTWARE for back-up purposes.
· Reverse engineering. You affirm that you will not attempt to reverse compile,
modify, translate, or disassemble the SOFTWARE in whole or in part.
· Unauthorized use. You may not use, copy, rent, lease, sell, modify, decompile,
disassemble, otherwise reverse engineer, or transfer the SOFTWARE except as provided in this agreement. Any such unauthorized use shall result in immediate and
© 2009 SQL Maestro Group
MySQL Maestro Help6
automatic termination of this license.
· No other warranties. SQL Maestro Group does not warrant that the SOFTWARE is
error-free. SQL Maestro Group disclaims all other warranties with respect to the SOFTWARE, either express or implied, including but not limited to implied warranties of merchantability, fitness for a particular purpose and noninfringement of third party rights. Some jurisdictions do not allow the exclusion of implied warranties or limitations on how long an implied warranty may last, or the exclusion or limitation of incidental or consequential damages, so the above given limitations or exclusions may not apply to you. This warranty gives you specific legal rights and you may also have other rights which vary from jurisdiction to jurisdiction.
· Limited warranty. This SOFTWARE is provided on an "AS IS" basis. SQL Maestro
Group disclaims all warranties relating to this SOFTWARE, whether expressed or
implied, including but not limited to any implied warranties of merchantability or fitness for a particular purpose. Neither SQL Maestro Group nor anyone else who has been involved in the creation, production, or delivery of this SOFTWARE shall be liable for any indirect, consequential, or incidental damages arising out of the use or inability to use such SOFTWARE, even if SQL Maestro Group has been advised of the possibility of such damages or claims. The person using the SOFTWARE bears all risk as to the quality and performance of the SOFTWARE.
Some jurisdictions do not allow limitation or exclusion of incidental or consequential damages, so the above given limitations or exclusion may not apply to you to the extent that liability is by law incapable of exclusion or restriction.
· Severability. In the event of invalidity of any provision of this license, the parties
agree that such invalidity shall not affect the validity of the remaining portions of this license.
· No liability for consequential damages. In no event shall SQL Maestro Group or its
suppliers be liable to you for any consequential, special, incidental or indirect damages of any kind arising out of the delivery, performance or use of the SOFTWARE, even if SQL Maestro Group has been advised of the possibility of such damages. In no event will SQL Maestro Group's liability for any claim, whether in contract, tort or any other theory of liability, exceed the license fee paid by you, if any.
· Entire agreement. This is the entire agreement between you and SQL Maestro Group
which supersedes any prior agreement or understanding, whether written or oral, relating to the subject matter of this license.
· Reserved rights. All rights not expressly granted here are reserved to SQL Maestro
Group.
© 2009 SQL Maestro Group

1.4 System Requirements

Client environment
· Pentium PC or higher;
· Windows 9x/ME/NT4/2000/XP/2003;
· 64 MB RAM (128 MB recommended);
· 10 MB of free hard disk space;
· SVGA-compatible video adapter;
· Internet Explorer 4.0 or higher.
Server environment
· MySQL server version from 3.23 to 6.0.
Welcome to MySQL Maestro! 7
© 2009 SQL Maestro Group
MySQL Maestro Help8
MS SQL Maestro is the premier Windows GUI admin tool for Microsoft
SQL Server management, control and development.
MS SQL Maestro gives you wide opportunities to perform all the
necessary database operations such as creating, editing, copying, extracting and dropping database objects; moreover, you can build queries visually, execute queries and SQL scripts, view and edit data including BLOBs, represent data as diagrams, export and import data to/ from most popular file formats, manage Microsoft SQL Server users and their privileges, add jobs and alerts, and use a lot of other tools implemented to make your work with Microsoft SQL Server highly enjoyable and efficient.
Easy installation and intuitive interface in combination with support of all
Microsoft SQL Server latest features make it an irreplaceable tool for Microsoft SQL Server on the web or at your local desktop.
MS SQL Data Wizard is a powerful Windows GUI utility for managing your
Microsoft SQL data.
MS SQL Data Wizard provides you with a number of easy-to-use wizards
for performing the required data manipulation easily and quickly. MS SQL Data Wizard allows you to generate PHP scripts for the selected tables and queries, convert any ADO-compatible database to your MS SQL

1.5 About SQL Maestro Group

SQL Maestro Group is a privately-held company producing high-quality software for database administrators and developers. The united team of eminently qualified developers is pleased to create new software products for commercial, academic and government customers worldwide. We do our best to design and develop products that remove complexity, improve productivity, compress time frames, and increase database performance and availability. We are glad to realize that our products take usual chores upon themselves, so that our customers could have more time left for their creative work.
The company was founded in 2002 as an essential partner for every business that is trying to harness the explosive growth in corporate data. SQL Maestro Group employs an international team concentrating their efforts on cutting-edge DBA tools development.
The slogan of our company is The Shortest Path to SQL. It is aimed to denote that we set to create easy-to-use products meant for those who appreciate comfort, friendly program interface and support when working with SQL servers.
· We are pleased to facilitate your job.
· We aim at being of considerable assistance to our clients.
· We feel contented doing our beloved work.
At present, our company offers a series of Windows GUI admin tools for SQL management, control and development of the following servers: MySQL , Microsoft
SQL Server , PostgreSQL , Oracle , SQL Anywhere , DB2 , SQLite , Firebird
12 14
, and MaxDB .
8 12 9 10 11 13
10
© 2009 SQL Maestro Group
Welcome to MySQL Maestro! 9
database, export data from MS SQL tables and queries to most popular formats, and import data into the tables.
MS SQL Code Factory is a premier SQL Server GUI tool aimed at the SQL
queries and scripts development.
MS SQL Code Factory allows you to manage SQL queries and scripts using such useful features as code folding, code completion and syntax highlighting, build query visually, execute several queries at a time, execute scripts from files, view and edit result data with filtering, sorting and grouping abilities, export data to as many as 14 file formats including Excel, RTF and HTML, import data from Excel, CSV, XML and text files, view and edit BLOBs in various way, build diagrams based on MS SQL data, and much more.
Oracle Maestro is the premier Windows GUI admin tool for Oracle
databases management, control and development.
Oracle Maestro provides you with a number of tools allowing to perform
all the necessary database operations such as creating, editing, and duplicating database objects; moreover, you can build queries visually, execute and optimize SQL queries and SQL scripts, view and edit data including BLOBs, represent data as diagrams, export and import data to/ from most popular file formats, analyze your data summarized into multidimensional views and hierarchies (OLAP cubes), and use a lot of other tools implemented to make your work with Oracle server comfortable and efficient.
Oracle Data Wizard is a powerful Windows GUI utility for managing your
Oracle data.
Oracle Data Wizard provides you with a number of easy-to-use wizards for performing the required data manipulation easily and quickly. Oracle Data Wizard allows you to generate PHP scripts for the selected tables and queries, convert any ADO-compatible database to the Oracle database, export data from Oracle tables and queries to most popular formats, and import data into the tables.
Oracle Code Factory is a premier Oracle GUI tool aimed at the SQL
queries and scripts development.
Oracle Code Factory allows you to manage SQL queries and scripts using such useful features as code folding, code completion and syntax highlighting, build query visually, execute several queries at a time, execute scripts from files, view and edit result data with filtering, sorting and grouping abilities, export data to as many as 14 file formats including Excel, RTF and HTML, import data from Excel, CSV, XML and text files, view and edit BLOBs in various way, build diagrams based on Oracle data, and much more.
© 2009 SQL Maestro Group
MySQL Maestro Help10
SQL Maestro for MySQL is the premier Windows GUI admin tool for
MySQL Server management, control and development.
SQL Maestro for MySQL provides you with the ability to perform all the
necessary database operations such as creating, editing, copying, extracting and dropping database objects; moreover, you can build queries visually, execute queries and SQL scripts, view and edit data including BLOBs, represent data as diagrams, export and import data to/ from most popular file formats, manage MySQL users and their privileges, and use a lot of other tools designed for making your work with MySQL server comfortable and efficient.
Data Wizard for MySQL is a powerful Windows GUI utility for managing
your MySQL data.
Data Wizard for MySQL provides you with a number of easy-to-use
wizards for performing the required data manipulation easily and quickly. The wizards allow you to generate PHP scripts for the selected tables and queries, convert any ADO-compatible database to your MySQL database, export data from MySQL tables and queries to most popular formats, and import data into the tables.
Code Factory for MySQL is a premier MySQL GUI tool aimed at the SQL
queries and scripts development.
Code Factory for MySQL allows you to manage SQL queries and scripts using such useful features as code folding, code completion and syntax highlighting, build query visually, execute several queries at a time, execute scripts from files, view and edit result data with filtering, sorting and grouping abilities, export data to as many as 14 file formats including Excel, RTF and HTML, import data from Excel, CSV, XML and text files, view and edit BLOBs in various way, build diagrams based on MySQL data, and much more.
Service Center for MySQL is a multi-functional Windows GUI utility for
MySQL server maintenance and data reservation.
Service Center for MySQL allows you to create tasks for backing your
data into a script, restoring data from a script, analyzing, checking, repairing and optimizing database tables. In addition to these functions, Service Center for MySQL provides you with a powerful task scheduler, an ability of using scenarios and other useful features.
ASA Maestro is the premier Windows GUI admin tool for Sybase SQL
Anywhere databases management, control and development.
ASA Maestro provides you with a number of tools allowing to perform all
the necessary database operations such as creating, editing, and duplicating database objects; moreover, you can build queries visually, execute and optimize SQL queries and SQL scripts, view and edit data including BLOBs, represent data as diagrams, export and import data to/ from most popular file formats, analyze your data summarized into multidimensional views and hierarchies (OLAP cubes), and use a lot of
© 2009 SQL Maestro Group
Welcome to MySQL Maestro! 11
other tools implemented to make your work with SQL Anywhere server comfortable and efficient
ASA Data Wizard is a powerful Windows GUI utility for managing your
Sybase SQL Anywhere data.
ASA Data Wizard provides you with a number of easy-to-use wizards for performing the required data manipulation easily and quickly. ASA Data Wizard allows you to generate PHP scripts for the selected tables and queries, convert any ADO-compatible database to the SQL Anywhere database, export data from SQL Anywhere tables and queries to most popular formats, and import data into the tables.
ASA Code Factory is a premier Sybase SQL Anywhere GUI tool aimed at
the SQL queries and scripts development.
ASA Code Factory allows you to manage SQL queries and scripts using such useful features as code folding, code completion and syntax highlighting, build query visually, execute several queries at a time, execute scripts from files, view and edit result data with filtering, sorting and grouping abilities, export data to as many as 14 file formats including Excel, RTF and HTML, import data from Excel, CSV, XML and text files, view and edit BLOBs in various way, build diagrams based on SQL Anywhere data, and much more.
DB2 Maestro is the premier Windows GUI admin tool for DB2 databases
management, control and development.
DB2 Maestro provides you with a number of tools allowing to perform all
the necessary database operations such as creating, editing, and duplicating database objects; moreover, you can build queries visually, execute and optimize SQL queries and SQL scripts, view and edit data including BLOBs, represent data as diagrams, export and import data to/ from most popular file formats, analyze your data summarized into multidimensional views and hierarchies (OLAP cubes), and use a lot of other tools implemented to make your work with DB2 server comfortable and efficient.
DB2 Data Wizard is a powerful Windows GUI utility for managing your
DB2 data.
DB2 Data Wizard provides you with a number of easy-to-use wizards for performing the required data manipulation easily and quickly. DB2 Data Wizard allows you to generate PHP scripts for the selected tables and queries, convert any ADO-compatible database to the DB2 database, export data from DB2 tables and queries to most popular formats, and import data into the tables.
DB2 Code Factory is a premier DB2 GUI tool aimed at the SQL queries
and scripts development.
DB2 Code Factory allows you to manage SQL queries and scripts using such useful features as code folding, code completion and syntax
© 2009 SQL Maestro Group
MySQL Maestro Help12
highlighting, build query visually, execute several queries at a time, execute scripts from files, view and edit result data with filtering, sorting and grouping abilities, export data to as many as 14 file formats including Excel, RTF and HTML, import data from Excel, CSV, XML and text files, view and edit BLOBs in various way, build diagrams based on DB2 data, and much more.
PostgreSQL Maestro is the premier Windows GUI admin tool for
PostgreSQL server management, control and development.
PostgreSQL Maestro allows you to create, edit, copy, extract and drop all
the database objects such as schemas, tables, views, functions, domains, rules, sequences, languages, operators, etc., build queries visually, execute queries and SQL scripts, view and edit data including BLOBs, represent data as diagrams, export and import data to/from most popular file formats, manage PostgreSQL roles, users, groups and their privileges, and use a lot of other tools designed for the easiest and most efficient work with PostgreSQL Server.
You are welcome to enjoy the abilities offered by a number of
implemented tools providing excellent performance for all the necessary database operations.
PostgreSQL Data Wizard is a powerful Windows GUI utility for managing
your PostgreSQL PostgreSQL data.
PostgreSQL Data Wizard provides you with a number of easy-to-use
wizards for performing the required data manipulation easily and quickly. PostgreSQL Data Wizard allows you to generate PHP scripts for the selected tables and queries, convert any ADO-compatible database to your PostgreSQL database, export data from PostgreSQL tables and queries to most popular formats, and import data into the tables.
PostgreSQL Code Factory is a premier PostgreSQL GUI tool aimed at the
SQL queries and scripts development.
PostgreSQL Code Factory allows you to manage SQL queries and scripts using such useful features as code folding, code completion and syntax highlighting, build query visually, execute several queries at a time, execute scripts from files, view and edit result data with filtering, sorting and grouping abilities, export data to as many as 14 file formats including Excel, RTF and HTML, import data from Excel, CSV, XML and text files, view and edit BLOBs in various way, build diagrams based on PostgreSQL data, and much more.
Firebird Maestro is the premier Windows GUI admin tool for Firebird
Server management, control and development.
Firebird Maestro allows you to create, edit, copy, extract and drop all the
database objects such as tables, views, procedures, domains, generators, etc., build queries visually, execute queries and SQL scripts, view and edit data including BLOBs, represent data as diagrams, export
© 2009 SQL Maestro Group
Welcome to MySQL Maestro! 13
and import data to/from most popular file formats, manage Firebird users, and their privileges, and use a lot of other tools designed for the easiest and most efficient work with Firebird Server.
Firebird Data Wizard is a powerful Windows GUI utility for managing your
Firebird data.
Firebird Data Wizard provides you with a number of easy-to-use wizards
for performing the required data manipulation easily and quickly. Firebird Data Wizard allows you to generate PHP scripts for the selected tables and queries, convert any ADO-compatible database to your Firebird database, export data from Firebird tables and queries to most popular formats, and import data into the tables.
Firebird Code Factory is a premier Firebird GUI tool aimed at the SQL
queries and scripts development.
Firebird Code Factory allows you to manage SQL queries and scripts using such useful features as code folding, code completion and syntax highlighting, build query visually, execute several queries at a time, execute scripts from files, view and edit result data with filtering, sorting and grouping abilities, export data to as many as 14 file formats including Excel, RTF and HTML, import data from Excel, CSV, XML and text files, view and edit BLOBs in various way, build diagrams based on Firebird data, and much more.
SQLite Maestro allows you to create, edit, copy, extract and drop all
the database objects such as tables, views, build queries visually, execute queries and SQL scripts, view and edit data including BLOBs, represent data as diagrams, export and import data to/from most popular file formats, and use a lot of other tools designed for the easiest and most efficient work with SQLite server.
SQLite Maestro is designed to meet the requirements of SQLite users and
to make the work with the server simpler and more comfortable. Friendly user graphical interface, handy realization of the client application and stable running are evident advantages of using SQLite Maestro.
SQLite Data Wizard is a powerful Windows GUI utility for managing your
SQLite data.
It provides you with a number of easy-to-use wizards for performing the
required data manipulation easily and quickly. SQLite Data Wizard allows you to generate PHP scripts for the selected tables and queries, convert any ADO-compatible database to your SQLite database, export data from SQLite tables and queries to most popular formats, and import data into the tables.
© 2009 SQL Maestro Group
MySQL Maestro Help14
SQLite Code Factory is a premier SQLite GUI tool aimed at the SQL
queries and scripts development.
SQLite Code Factory allows you to manage SQL queries and scripts using such useful features as code folding, code completion and syntax highlighting, build query visually, execute several queries at a time, execute scripts from files, view and edit result data with filtering, sorting and grouping abilities, export data to as many as 14 file formats including Excel, RTF and HTML, import data from Excel, CSV, XML and text files, view and edit BLOBs in various way, build diagrams based on SQLite data, and much more.
MaxDB Maestro is the premier Windows GUI admin tool for MaxDB Server
management, control and development.
You are welcome to appreciate the brilliant performance of MaxDB Maestro. It is implemented with a number of tools allowing you to perform all the necessary database operations such as creating, editing, copying, extracting and dropping database objects; moreover, you can build queries visually, execute queries and SQL scripts, view and edit data including BLOBs, represent data as diagrams, export and import data to/ from most popular file formats, and use a lot of other tools implemented to make your work with MaxDB server comfortable and efficient.
MaxDB Data Wizard is a powerful Windows GUI utility for managing your
MaxDB data.
MaxDB Data Wizard provides you with a number of easy-to-use wizards
for performing the required data manipulation easily and quickly. MaxDB Data Wizard allows you to generate PHP scripts for the selected tables and queries, convert any ADO-compatible database to the MaxDB database, export data from MaxDB tables and queries to most popular formats, and import data into the tables.
MaxDB Code Factory is a premier MaxDB GUI tool aimed at the SQL
queries and scripts development.
MaxDB Code Factory allows you to manage SQL queries and scripts using such useful features as code folding, code completion and syntax highlighting, build query visually, execute several queries at a time, execute scripts from files, view and edit result data with filtering, sorting and grouping abilities, export data to as many as 14 file formats including Excel, RTF and HTML, import data from Excel, CSV, XML and text files, view and edit BLOBs in various way, build diagrams based on MaxDB data, and much more.
Our web-site
www.sqlmaestro.com
The software products are constantly optimized for the latest server versions support.
You can use the following contact information if necessary:
© 2009 SQL Maestro Group
Welcome to MySQL Maestro! 15
Postal address:
SQL Maestro Group
140 Broadway, Suite 706 New York City, New York 10005 United States
Thank you for your interest to our company!
© 2009 SQL Maestro Group
MySQL Maestro Help16

1.6 What's new

02/02/2009 - SQL Maestro for MySQL 9.2 released
Server management extensions:
· Starting with this version it is possible to manage (create, edit and drop) remote
servers i.e. servers that can be later used when creating tables with the FEDERATED storage engine (MySQL 5.1.15 and higher). To create a federated table using such a server, set the Connection property to 'server_name/table_name' within the Create Table wizard .
101
· SQL Editor : support for explicit transaction management has been implemented.
172
Now you can execute queries either in autocommit mode (default behavior) or manage transactions manually. In the second case you have to issue the BEGIN statement to start a transaction and explicitly end the transaction by COMMIT or ROLLBACK statements (it is also possible to use the corresponding links at the editor's navigation bar).
· Field Editor : now it is possible to select some predefined default values such as
113
CURRENT_USER for the string columns or CURRENT_TIMESTAMP for TIMESTAMP columns from the list instead of entering them manually.
Interface improvements:
· Visual Query Builder has been dramatically improved. Now it can produce INSERT,
178
UPDATE and DELETE statements as well as the SELECT statements containing subqueries and/or UNIONs.
· Tabbed MDI interface : a popup menu has been added to each tab.
35
· An Italian localization is now included into the installation package.
· Data grid features the following things:
210
o
Starting with this version it is possible to allow displaying row numbers in grids. Of course you can adjust the corresponding column to yours liking.
o
The contents of string columns can now be encrypted using the md5 algorithm.
10/20/2008 - SQL Maestro for MySQL 8.10 released
Server management extensions:
· An ability of using the LOAD DATA INFILE command has been incorporated into the
Import Data wizard . This feature can speed up the import process up to 10 times
242
so it is recommended to use it always if possible. Also we have added the Empty
table before importing option (can be found at the last step of the wizard).
· Get SQL Dump Wizard and Extract Database Wizard now can generate multi-
239 258
row INSERT statements. Also both the wizards have been redesigned to increase
© 2009 SQL Maestro Group
the usability.
Interface improvements:
Welcome to MySQL Maestro! 17
· Data Grid features the following things:
211
o
Starting with this version it is possible to use the lookup editor for a
215
column, which is linked by a foreign key with a (single) column from another table. The editor displays the contents of parent table’s columns within the dropdown window.
o
A possibility of displaying data in the master-detail form has been incorporated into the Table Editor (multiple detail pages can be displayed for a single
106
master row). Use the Show/Hide details link at the editor’s navigation bar to activate/deactivate this view mode.
o
Filtering, grouping, and sorting features become available for TEXT columns. Also it is possible to edit the contents of such columns in a separate window as well as encrypt it using the md5 algorithm.
· Database Designer settings: the Show hints option has been added. Also it is
279
now possible to select the default graphic file format to export diagrams as images.
· Data Export, Data Import, and Get SQL Dump wizards now store their size and
position.
· Database Explorer : the Data management group has been added to table and
41
view nodes popup menus. Use this group items to run Data Export, Data Import, and Get SQL Dump wizards for the selected table or view without opening its editor (the Empty Table command has been moved to this group too). The Go to foreign
table command is now available for all the foreign keys.
03/20/2008 - SQL Maestro for MySQL 8.3 released
Server management extensions:
· The main feature of the new version is a possibility of connecting to remote MySQL
servers with restricted access via HTTP tunneling. The technology works as follows:
o
o
o
· Starting with this version you can set up default character set and collation in
Create Database Wizard .
© 2009 SQL Maestro Group
Upload the connection PHP script to your website. The script is named
mysql_tunnel.php and can be found under the installation folder, usually C: \Program Files\SQL Maestro Group\SQL Maestro for MySQL.
Test the script in your web-browser (optionally).
Enter the script URL in the Create Profiles Wizard , Create Database Wizard
72 86
, or Edit Database Profile dialog. Of course you should select the "I have
79
to use HTTP tunneling" option in any of these windows.
72
MySQL Maestro Help18
· Now you can specify the client encoding in the connection properties. Default value
is UTF-8 (do not change it without necessity).
· SQL Formatter now understands expressions like INTERVAL 600 MINUTES.
· Quick Connect mode has been implemented. Use it to skip metadata refreshing
when connecting to a database (for example, to execute a query or SQL script).
Interface improvements:
· This version of our software is fully compatible with large fonts (120 DPI).
· Extract database wizard: common database properties and program info are now
included into the result scripts.
· SQL Editor: a popup menu has been added to each query tab. Using this menu you
can create a new query, close existing one, save the query to profile, etc even if editor's navigation bar is closed.
· Create Database Wizard, Create Profiles Wizard, and object creation wizards
become resizable.
· Data import wizard: the interface for adding and editing of replacements has been
slightly improved.
· The F11 key is now used to show/hide the Explorer tree.
· Data grid options: it is now possible to restrict maximum column width.
· SQL Script Editor settings: the "Use script runner for large scripts" option has been
added.
Important fixes:
· Data in UTF-8 encoding are now displayed correctly for MySQL 4.1.
· Extract Database Wizard now works fine even if a user has no permissions to obtain
view definitions.
12/14/2007 - SQL Maestro for MySQL 7.12 released
Server management extensions:
· A new editor for values of the set data type has been implemented.
· Values of the enum ('Y','N') data type are now displayed and edited as checkboxes.
· Foreign keys are now extracted corrected for all MySQL versions.
Interface improvements:
© 2009 SQL Maestro Group
Welcome to MySQL Maestro! 19
· The SQL Generator tool has been implemented. Use this feature to produce
286
various SQL scripts (CREATE, DROP, SELECT, INSERT, etc) for the selected object. The result script can be saved to a file, copied to clipboard, and opened in SQL
Editor or SQL Script Editor .
· Data Grid has been significantly updated:
172 255
211
o
The notification pane is now displayed after simple mode activation (filtering, grouping and sorting features are not supported in this mode). All the related settings can be customized in the Options dialog;
o
The Generate Query command has been added to the Table / View Editor
135
. Use this command to copy current filter conditions to the SQL Editor
106
window as an SQL query. It is also possible to copy filter condition to clipboard as WHERE clause using grid’s popup menu;
o
Now it is possible to encrypt the contents of the selected cell by the md5 algorithm (the corresponding item has been added to grid's popup menu).
· Database designer : the Note and Text tools have been added. You can use
279
them to decorate the diagrams.
· Create Database Profiles wizard : the Hide already registered databases option
79
has been added.
· Object editors, SQL Editor, Database Designer, BLOB Viewer and other database-
dependent windows: only connected databases are now displayed in the drop­down list.
08/23/2007 - SQL Maestro for MySQL 7.8 released
Server management extensions:
· SQL Maestro for MySQL was optimized to work with MySQL servers with a small
timeout;
· Since this version you can reorder fields for existing tables. It is also possible to
107
reorder parameters for a stored procedure/function and reorder partitions (only for newly created tables);
· It is now possible to cancel a long running query execution (MySQL 5) and data
fetching (all MySQL versions);
· Field Editor: the NCHAR and NVARCHAR types are added to the type list;
· Process Browser : session killing is now works correctly for all MySQL versions.
285
Interface improvements:
· The SQL Formatter for DML statements (SELECT, INSERT, UPDATE and DELETE)
is implemented. It can be invoked through the Format SQL link on the SQL Editor's navigation bar (Ctrl+Alt+D shortcut). Also it is now used for view body formatting
© 2009 SQL Maestro Group
175
MySQL Maestro Help20
(MySQL stores view body as a single line)
· Data grid : the editor for ENUM fields displays a lookup list with enumeration
211
values.
· Extract Metadata Wizard is improved. Now it works faster and requires less
258
memory
· Now SQL Maestro for MySQL displays execution time for lengthy operations.
· Get SQL Dump Wizard : the result table is now scripted correctly.
239
· The Row count and Data length columns are added to the table list (Database
Editor , Object Browser ).
77 58
· The database hints in the explorer tree now contain connection ID and default
character set/collation. Hints for tables and columns are also included character set and collation, but only if they are different from database default.
· Data Import Wizard: the speed of loading of Excel files was significantly increased.
· Foreign key editor : now only InnoDB tables are displayed in the foreign table list.
119
Table engine is also now checked for the Relation tool in the Database Designer.
08/21/2007 - Renaming of administration tools family for MySQL
SQL Maestro Group have renamed all MySQL Administration tools family members because of MySQL AB trademark policy.
Since then the new title of MySQL Maestro is SQL Maestro for MySQL.
06/25/2007 - MySQL Maestro 7.6 released
Server management extensions:
· The most important thing added in this version of MySQL Maestro is support of UTF-8 data.
· Process Browser is implemented. This feature is very useful for DBAs who want
285
to monitor the users' activity (in fact, there are potentially thousands of sessions in a database at any one time). You can view details for each session (such as user, connect time, database name, client host, last SQL statement executed and more) as well as group and filter sessions by client host, connected user, database, client application, etc. To access the Process Browser window, select the corresponding item from the Tools menu.
· Now MySQL Maestro displays view body correctly even if you're not the owner of the view.
Interface improvements:
© 2009 SQL Maestro Group
Welcome to MySQL Maestro! 21
· Database Designer : a possibility of locking/unlocking diagram objects is added.
279
This feature prevents your diagram from unforeseen changes: when the diagram is locked, you can neither move/resize/delete existing objects nor add new ones.
· Some new features are incorporated into SQL Editor and SQL Script Editor .
172 255
Now it is possible:
o
comment/uncomment selected text (Shift+Ctrl+. / Shift+Ctrl+, shortcuts respectively). If no text is selected, the whole line will be commented. By the way, it is not necessary to select commented text to uncomment it, just press Shift+Ctrl+, having the cursor inside the commented text. Both kinds of comments (single-line and multi-line) are supported;
o
convert selected text to different cases (lower, UPPER, and NameCase);
o
export the contents of the editor to RTF and HTML formats (to file or to clipboard);
o
print/preview the contents of the editor.
· The Copy to SQL Script Editor command is added to all object editors (available in the Navigation Bar on the SQL tab). Use it for quick copying object’s SQL definition (DDL) to the SQL Script Editor for future modifications;
· Data grid : some advanced filtering abilities were implemented (see Main menu |
211
Tools | Options | Data grid | Filter);
· Explorer tree: the Browse command is added to lists' popup menus (runs the
Object Browser tool).
41
58
02/15/2007 - MySQL Maestro 7.2 released
Server management extensions:
· MySQL Maestro has been successfully tested with the latest MySQL versions up to
5.0.27, 5.1.15 beta and 5.2 alpha;
· Support of the Falcon storage engine from MySQL 5.2 is implemented;
Interface improvements:
· The main feature of the new version is Graphical Database Designer - a case tool
279
for managing your database in a few mouse clicks. This piece of our software is intended for creation of physical Entity Relationship Diagrams that represent objects in your MySQL databases. Each diagram displays the tables of your database and the relationships between them.
o
Handy tools of Designer allow you to create new and edit existing tables and references;
o
© 2009 SQL Maestro Group
The reverse engineering feature will help you to understand the schema
MySQL Maestro Help22
structure and make its modification in an easy and clear way.
o
Now you can quickly and easily print your database structure with a lot of options including header and footer, paper size and orientation, etc;
o
A rich set of options and settings give you a way to see your database in your own look and feel style.
A diagram of your database can help you define operational aspects of your application logic that you might otherwise overlook. Also, a well-defined data diagram that accurately represents your tasks can be helpful in orienting employees to goals and operations.
· SQL Editor : now MySQL Maestro can edit even very large SQL files. Also the
172
speed of editor's work has been significantly improved;
· SQL Editor: queries' tabs can now been displayed at the all sides of the editor
(bottom, top, left or right);
· The hint for foreign keys now contains such information as foreign table name and
field correspondence.
12/08/2006 - MySQL Maestro 6.12 released
Server management extensions:
· The Make primary key and Clear primary key commands are now accessible
anywhere in the software (Table Editor, Explorer Tree, Object Browser, etc);
Interface improvements:
· The tabbed interface is implemented in addition to classic MDI (see screenshot).
You can choose your favorite UI in the Options dialog;
· MySQL Maestro now stores parameters history for procedure execution so you can
choose a set of already used values instead of entering them manually;
· SQL Script Editor : if a user opens a file larger than 100K, MySQL Maestro will
255
suggest him to execute the script file without opening it in the editor. Of course it is also possible to execute any script file using this way: just press the "Execute
script from file" link on the Script Editor navigation bar and specify the filename;
· We have implemented the Data Analysis , a tool to represent your data as OLAP
275
cubes;
· Database profiles are now grouped by host+port+login combination rather than host
+port in the previous versions;
· The Table Editor interface is improved: now all the subitems i.e. fields, indexes,
106
and triggers are displayed at the main editor tab. We found this layout more comfortable;
© 2009 SQL Maestro Group
Loading...
+ 323 hidden pages
Buy Points How it Works FAQ Contact Us Questions and Suggestions Privacy Policy Cookie Policy Terms of Use