User manual MYSQL MAESTRO

MySQL Maestro User's guide Copyright © 2002-2009 SQL Maestro Group I MySQL Maestro Help Table of Contents Foreword 0 I Welcome to MySQL Maestro! 1 Installation ................................................................................................................................... 2 Registration ................................................................................................................................... 3 License Agreement ................................................................................................................................... 4 System................................................................................................................................... Requirements 5 About SQL Maestro Group ................................................................................................................................... 6 What's new ................................................................................................................................... 7 Getting Started ................................................................................................................................... 1 3 4 5 7 8 16 33 Explaining user interface .......................................................................................................................................................... 34 Tabbed MDI .......................................................................................................................................................... 35 First time started .......................................................................................................................................................... 36 Working with .......................................................................................................................................................... 37 databases Switching between windows .......................................................................................................................................................... 39 II Basic principles of working with objects 1 Database Explorer ................................................................................................................................... 2 Wizards and Editors ................................................................................................................................... 40 41 45 Filtering explorer content .......................................................................................................................................................... 44 Create Object.......................................................................................................................................................... 45 Wizards Setting object name ......................................................................................................................................................... 46 Viewing commom information ......................................................................................................................................................... 46 Object Editors .......................................................................................................................................................... 47 Permissions of the Object ......................................................................................................................................................... 48 Object grants ......................................................................................................................................................... 49 SQL Definition ......................................................................................................................................................... 51 Parameter ......................................................................................................................................................... 52 Editor Executing ......................................................................................................................................................... 53 functions and procedures 3 Object................................................................................................................................... Manager 55 Using popup .......................................................................................................................................................... 56 menu Multiple selecting of objects .......................................................................................................................................................... 56 4 Object................................................................................................................................... Browser 58 Sorting database objects .......................................................................................................................................................... 59 Grouping database objects .......................................................................................................................................................... 60 Filtering database objects .......................................................................................................................................................... 60 5 Objects Duplicating ................................................................................................................................... 62 Duplicate Object Wizard .......................................................................................................................................................... 62 Selecting source and destination databases ......................................................................................................................................................... 62 Selecting object to duplicate ......................................................................................................................................................... 63 Modifying new object definition ......................................................................................................................................................... 64 Duplicate Selected Object .......................................................................................................................................................... 65 Copy, Paste and Drag-n-Drop features .......................................................................................................................................................... 66 6 Changing Object Properties ................................................................................................................................... 68 © 2009 SQL Maestro Group Contents 7 Describing Object ................................................................................................................................... II 69 III Database Administration 1 Create................................................................................................................................... Database Wizard 70 72 Setting connection properties .......................................................................................................................................................... 72 Specifying database properties .......................................................................................................................................................... 75 2 Database Editor ................................................................................................................................... 3 Creating Database Profiles ................................................................................................................................... 77 79 Setting connection properties .......................................................................................................................................................... 79 Selecting databases .......................................................................................................................................................... 82 Setting profile options .......................................................................................................................................................... 83 4 Editing Database Profile ................................................................................................................................... Editing Setting Setting Editing Setting 86 connection properties .......................................................................................................................................................... 86 profile options .......................................................................................................................................................... 89 default directories .......................................................................................................................................................... 90 obligatory scripts to execute .......................................................................................................................................................... 91 log options .......................................................................................................................................................... 94 IV Database Object Management 1 Database Object Creation ................................................................................................................................... 2 Tables ................................................................................................................................... 96 98 99 Create Table.......................................................................................................................................................... 100 Wizard Specifying table options ......................................................................................................................................................... 101 Adding table subitems ......................................................................................................................................................... 105 Table Editor .......................................................................................................................................................... 106 Editing table properties ......................................................................................................................................................... 107 Managing table data ......................................................................................................................................................... 111 Fields .......................................................................................................................................................... 113 Setting field parameters ......................................................................................................................................................... 115 Indexes .......................................................................................................................................................... 117 Index Editor ......................................................................................................................................................... 118 Foreign Keys .......................................................................................................................................................... 119 Setting reference options ......................................................................................................................................................... 120 Triggers .......................................................................................................................................................... 121 Create Trigger Wizard ......................................................................................................................................................... 123 Specifying trigger properties ......................................................................................................................................... 123 Specifying trigger definition ......................................................................................................................................... 124 Trigger Editor ......................................................................................................................................................... 125 Editing trigger properties ......................................................................................................................................... 126 Foreign Key .......................................................................................................................................................... 127 References Partitions .......................................................................................................................................................... 129 3 Views ................................................................................................................................... 130 Create View .......................................................................................................................................................... 131 Wizard Selecting......................................................................................................................................................... 132 fields Specifing......................................................................................................................................................... 133 view options View Editor .......................................................................................................................................................... 135 Editing view properties ......................................................................................................................................................... 136 Viewing data ......................................................................................................................................................... 138 4 Procedures ................................................................................................................................... 139 Create Procedure Wizard .......................................................................................................................................................... 140 © 2009 SQL Maestro Group II III MySQL Maestro Help Specifying procedure options ......................................................................................................................................................... 141 Managing parameters ......................................................................................................................................................... 143 Specifying procedure definition ......................................................................................................................................................... 143 Procedure Editor .......................................................................................................................................................... 144 Editing properties ......................................................................................................................................................... 145 Viewing procedure results ......................................................................................................................................................... 146 5 Functions ................................................................................................................................... 148 Create Function Wizard .......................................................................................................................................................... 149 Specifying Function properties ......................................................................................................................................................... 150 Managing parameters ......................................................................................................................................................... 152 Specifying Function Definition ......................................................................................................................................................... 152 Function Editor .......................................................................................................................................................... 153 Editing properties ......................................................................................................................................................... 154 Viewing Function results ......................................................................................................................................................... 156 6 Events ................................................................................................................................... 158 Create Event.......................................................................................................................................................... 159 Wizard Setting event properties ......................................................................................................................................................... 160 Schedule......................................................................................................................................................... 161 properties Specifying event definition ......................................................................................................................................................... 162 Event Editor .......................................................................................................................................................... 163 7 Remote servers ................................................................................................................................... 166 Create Remote Server Wizard .......................................................................................................................................................... 167 Remote Server Editor .......................................................................................................................................................... 167 V Queries 1 Query Management ................................................................................................................................... 2 SQL Editor ................................................................................................................................... 169 171 172 Working with editor area .......................................................................................................................................................... 173 Using popup.......................................................................................................................................................... 174 menu SQL Formatter .......................................................................................................................................................... 175 Executing query .......................................................................................................................................................... 176 3 Visual Query Builder ................................................................................................................................... 178 Working with diagram area .......................................................................................................................................................... 178 Joining two .......................................................................................................................................................... 179 objects Setting criteria .......................................................................................................................................................... 181 Setting output fields .......................................................................................................................................................... 182 Setting grouping criteria .......................................................................................................................................................... 183 Setting parameters of sorting .......................................................................................................................................................... 184 Working with editor area .......................................................................................................................................................... 185 Executing query .......................................................................................................................................................... 186 4 Query Parameters ................................................................................................................................... 188 Input Parameters dialog .......................................................................................................................................................... 188 VI Server Administration 1 Server Editor ................................................................................................................................... 2 Databases ................................................................................................................................... 3 Server Variables ................................................................................................................................... 4 Users ................................................................................................................................... 189 191 192 194 195 Variable Editor .......................................................................................................................................................... 194 © 2009 SQL Maestro Group Contents IV Create User .......................................................................................................................................................... 195 Wizard Specifying user options ......................................................................................................................................................... 196 Specifying user permissions ......................................................................................................................................................... 198 User Editor .......................................................................................................................................................... 199 Editing user properties ......................................................................................................................................................... 200 Managing user objects ......................................................................................................................................................... 201 5 UDFs................................................................................................................................... 203 Create UDF Wizard .......................................................................................................................................................... 204 Specifying UDF options ......................................................................................................................................................... 204 UDF Editor .......................................................................................................................................................... 205 Editing UDF properties ......................................................................................................................................................... 206 6 Character sets ................................................................................................................................... 208 VII Working with data in MySQL Maestro 1 Data ................................................................................................................................... View 209 210 Working with data grid .......................................................................................................................................................... 211 Grouping data .......................................................................................................................................................... 213 Filtering records .......................................................................................................................................................... 213 Editing grid data .......................................................................................................................................................... 215 2 Filter................................................................................................................................... Builder Dialog 217 Invoking the .......................................................................................................................................................... 217 Filter Builder dialog Adding new .......................................................................................................................................................... 218 condition Setting filter .......................................................................................................................................................... 219 criteria Setting filter.......................................................................................................................................................... 220 operator Setting filter .......................................................................................................................................................... 220 criteria values Adding new .......................................................................................................................................................... 221 group Setting group operator .......................................................................................................................................................... 222 Applying filter conditions .......................................................................................................................................................... 223 3 BLOB Editor ................................................................................................................................... 224 Navigating within the BLOB Editor .......................................................................................................................................................... 224 Editing as hexadecimal dump .......................................................................................................................................................... 225 Editing as plain text .......................................................................................................................................................... 226 Editing as HTML .......................................................................................................................................................... 226 4 Export Data Wizard ................................................................................................................................... 228 Setting destination file name and format .......................................................................................................................................................... 228 Selecting fields for export .......................................................................................................................................................... 229 Adjusting data formats .......................................................................................................................................................... 230 Setting header and footer .......................................................................................................................................................... 231 Setting format-specific options .......................................................................................................................................................... 231 Excel options ......................................................................................................................................................... 231 Access options ......................................................................................................................................................... 232 Word / RTF options ......................................................................................................................................................... 233 HTML options ......................................................................................................................................................... 234 PDF options ......................................................................................................................................................... 235 TXT options ......................................................................................................................................................... 236 CSV options ......................................................................................................................................................... 236 XML options ......................................................................................................................................................... 237 Setting common export options .......................................................................................................................................................... 238 5 Get SQL Dump ................................................................................................................................... 239 Selecting fields .......................................................................................................................................................... 240 Specifying dump options .......................................................................................................................................................... 240 © 2009 SQL Maestro Group IV V MySQL Maestro Help 6 Import Data Wizard ................................................................................................................................... 242 Setting source file name and format .......................................................................................................................................................... 243 Selecting data source .......................................................................................................................................................... 244 Setting fields correspondence .......................................................................................................................................................... 245 Excel ......................................................................................................................................................... 245 Access, DBF, XML ......................................................................................................................................................... 246 TXT ......................................................................................................................................................... 247 CSV ......................................................................................................................................................... 248 Adjusting data formats .......................................................................................................................................................... 249 Setting advanced field formats .......................................................................................................................................................... 250 Setting import mode .......................................................................................................................................................... 251 Customizing .......................................................................................................................................................... 252 common options VIII Database Tools 1 SQL Script Editor ................................................................................................................................... 2 Extract Database ................................................................................................................................... 254 255 258 Selecting the database and the target file name .......................................................................................................................................................... 259 Selecting objects to extract their structure .......................................................................................................................................................... 259 Selecting objects to extract their data .......................................................................................................................................................... 260 Customizing .......................................................................................................................................................... 261 script options 3 Generate Database Report ................................................................................................................................... 263 Selecting reporting elements and setting other report options .......................................................................................................................................................... 263 Reporting objects and editing styles options .......................................................................................................................................................... 264 Editing database report style .......................................................................................................................................................... 265 4 BLOB Viewer ................................................................................................................................... Viewing Viewing Viewing Viewing as as as as 266 hexadecimal dump .......................................................................................................................................................... 266 plain text .......................................................................................................................................................... 267 image .......................................................................................................................................................... 268 HTML .......................................................................................................................................................... 269 5 Diagram Viewer ................................................................................................................................... 271 Customizing .......................................................................................................................................................... 271 diagram properties Exporting diagram image .......................................................................................................................................................... 273 6 Data ................................................................................................................................... Analysis 275 Input SELECT query .......................................................................................................................................................... 276 Managing report data .......................................................................................................................................................... 277 7 Database Designer ................................................................................................................................... 279 Designer Navigation bar .......................................................................................................................................................... 281 Database Designer Toolbox .......................................................................................................................................................... 282 8 Process Browser ................................................................................................................................... 9 SQL ................................................................................................................................... Generator 10 Dialogs ................................................................................................................................... 285 286 287 Find Text dialog .......................................................................................................................................................... 287 Replace Text.......................................................................................................................................................... 289 dialog IX MySQL Maestro Options 1 Application ................................................................................................................................... 291 292 Preferences.......................................................................................................................................................... 292 Confirmations .......................................................................................................................................................... 294 Tools .......................................................................................................................................................... 295 © 2009 SQL Maestro Group Contents VI Explorer ......................................................................................................................................................... 296 Object Manager ......................................................................................................................................................... 297 SQL Editor ......................................................................................................................................................... 297 SQL Script Editor ......................................................................................................................................................... 298 Query Builder ......................................................................................................................................................... 299 Colors ......................................................................................................................................... 301 BLOB Viewer ......................................................................................................................................................... 301 Data Export ......................................................................................................................................................... 302 Database......................................................................................................................................................... 303 Designer Object Editors .......................................................................................................................................................... 304 Table ......................................................................................................................................................... 306 Data Grid .......................................................................................................................................................... 306 Options ......................................................................................................................................................... 308 Colors ......................................................................................................................................................... 309 Formats ......................................................................................................................................................... 310 Filter ......................................................................................................................................................... 311 2 Editors & Viewers ................................................................................................................................... 313 General .......................................................................................................................................................... 313 Display .......................................................................................................................................................... 315 SQL highlight .......................................................................................................................................................... 316 XML highlight .......................................................................................................................................................... 316 Code Insight.......................................................................................................................................................... 317 Code Folding .......................................................................................................................................................... 318 3 Appearance ................................................................................................................................... 320 Bars and menus .......................................................................................................................................................... 321 Trees and lists .......................................................................................................................................................... 321 Edit controls.......................................................................................................................................................... 322 Check boxes .......................................................................................................................................................... 323 Buttons .......................................................................................................................................................... 324 Page controls .......................................................................................................................................................... 325 Group boxes .......................................................................................................................................................... 326 Splitters .......................................................................................................................................................... 327 4 Export Settings ................................................................................................................................... 329 Specifying destination file .......................................................................................................................................................... 329 Selecting setting categories .......................................................................................................................................................... 330 Selecting database profiles .......................................................................................................................................................... 331 Saving settings .......................................................................................................................................................... 331 X Appendix 1 Specifying WHERE condition ................................................................................................................................... Adding Setting Setting Setting Setting Adding 333 334 new .......................................................................................................................................................... 334 condition filter .......................................................................................................................................................... 334 criteria filter.......................................................................................................................................................... 335 operator filter .......................................................................................................................................................... 336 criteria values group operator .......................................................................................................................................................... 336 new .......................................................................................................................................................... 337 group 2 MySQL identifiers ................................................................................................................................... 3 Data ................................................................................................................................... Formats 339 340 © 2009 SQL Maestro Group VI VII MySQL Maestro Help Index 341 © 2009 SQL Maestro Group Welcome to MySQL Maestro! 1 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 70 for details. Powerful database object management MySQL Maestro provides you with an ability to manage database objects (tables 99 , views 130 , procedures 139 and functions 148 ) in various ways. For example, you can perform operations with a group of objects as well as with a single object in Object Manager 55 , sort, group and filter the database objects within Object Browser 58 , 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 96 section. 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 99 section to learn more. 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 169 section. 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 209 to learn the details. 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 2 MySQL Maestro Help more. To learn more, see the Database Tools 254 section. 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 195 privileges. 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 291 dialog description. © 2009 SQL Maestro Group Welcome to MySQL Maestro! 3 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. © 2009 SQL Maestro Group 4 MySQL Maestro Help 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 Welcome to MySQL Maestro! 5 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. · 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 6 MySQL Maestro Help 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 Welcome to MySQL Maestro! 7 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. © 2009 SQL Maestro Group 8 MySQL Maestro Help 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 10 , Microsoft SQL Server 8 , PostgreSQL 12 , Oracle 9 , SQL Anywhere 10 , DB2 11 , SQLite 13 , Firebird 12 , and MaxDB 14 . 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 © 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 10 MySQL Maestro Help 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 12 MySQL Maestro Help 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 PostgreSQL server management, control and development. tool for 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 14 MySQL Maestro Help 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. The software products are constantly optimized for the latest server versions support. You can use the following contact information if necessary: Our web-site www.sqlmaestro.com © 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 16 MySQL Maestro Help 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 172 : support for explicit transaction management has been implemented. 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 113 : now it is possible to select some predefined default values such as 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 178 has been dramatically improved. Now it can produce INSERT, UPDATE and DELETE statements as well as the SELECT statements containing subqueries and/or UNIONs. · Tabbed MDI interface 35 : a popup menu has been added to each tab. · An Italian localization is now included into the installation package. · Data grid 210 features the following things: 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 242 . This feature can speed up the import process up to 10 times 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 239 and Extract Database Wizard 258 now can generate multirow INSERT statements. Also both the wizards have been redesigned to increase © 2009 SQL Maestro Group Welcome to MySQL Maestro! 17 the usability. Interface improvements: · Data Grid 211 features the following things: o Starting with this version it is possible to use the lookup editor 215 for a 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 106 (multiple detail pages can be displayed for a single 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 279 settings: the Show hints option has been added. Also it is 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 41 : the Data management group has been added to table and 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 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. o Test the script in your web-browser (optionally). o Enter the script URL in the Create Profiles Wizard 79 , Create Database Wizard 72 , or Edit Database Profile 86 dialog. Of course you should select the "I have to use HTTP tunneling" option in any of these windows. · Starting with this version you can set up default character set and collation in Create Database Wizard 72 . © 2009 SQL Maestro Group 18 MySQL Maestro Help · 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 286 tool has been implemented. Use this feature to produce 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 172 or SQL Script Editor 255 . Data Grid 211 · has been significantly updated: 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 106 / View Editor 135 . Use this command to copy current filter conditions to the SQL Editor 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 279 : the Note and Text tools have been added. You can use them to decorate the diagrams. Create Database Profiles wizard has been added. 79 · : the Hide already registered databases option · Object editors, SQL Editor, Database Designer, BLOB Viewer and other databasedependent windows: only connected databases are now displayed in the dropdown 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 107 for existing tables. It is also possible to 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 285 : session killing is now works correctly for all MySQL versions. Interface improvements: · The SQL Formatter 175 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 20 MySQL Maestro Help (MySQL stores view body as a single line) · Data grid values. 211 : the editor for ENUM fields displays a lookup list with enumeration · Extract Metadata Wizard memory 258 is improved. Now it works faster and requires less · Now SQL Maestro for MySQL displays execution time for lengthy operations. · Get SQL Dump Wizard 239 : the result table is now scripted correctly. · The Row count and Data length columns are added to the table list (Database Editor 77 , Object Browser 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 119 : now only InnoDB tables are displayed in the foreign table list. 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 285 is implemented. This feature is very useful for DBAs who want 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 279 : a possibility of locking/unlocking diagram objects is added. 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 Now it is possible: 172 and SQL Script Editor 255 . 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 211 : some advanced filtering abilities were implemented (see Main menu | Tools | Options | Data grid | Filter); · Explorer 41 tree: the Browse command is added to lists' popup menus (runs the Object Browser 58 tool). 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 279 - a case tool 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 The reverse engineering feature will help you to understand the schema © 2009 SQL Maestro Group 22 MySQL Maestro Help 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 172 : now MySQL Maestro can edit even very large SQL files. Also the 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 255 : if a user opens a file larger than 100K, MySQL Maestro will 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 cubes; 275 , a tool to represent your data as OLAP · Database profiles are now grouped by host+port+login combination rather than host +port in the previous versions; · The Table Editor 106 interface is improved: now all the subitems i.e. fields, indexes, and triggers are displayed at the main editor tab. We found this layout more comfortable; © 2009 SQL Maestro Group Welcome to MySQL Maestro! 23 · BLOB viewer 266 /editor 224 : the text pane provides now several types of text highlighting (Plain text, HTML, JScript, CSS, PHP, XML, SQL, and SQLite DDL). Also it is possible to find and replace a text fragment of a BLOB column data; · It is now available to refresh schema object list whenever an object depends on other objects e.g. refresh table list on view creation; · The Insert key is now a shortcut for creating a new database object from the Explorer tree; · Create Profiles Wizard to lower/upper case; 79 : we've added an option for converting new object names · Data grid: the speed of data loading was significantly increased. 10/20/2006 MySQL Maestro 6.10 released A new version of MySQL Maestro, a powerful Windows GUI solution for MySQL server administration and database development, has been released. Please consider the list of all new features implemented in MySQL Maestro 6.10: · The new version connects to the database much faster because of using the information_schema database (MySQL 5.0 and higher). · It is now possible to view/change SQL scripts generated by MySQL Maestro before executing. · Support of events implemented. 158 (MySQL 5.1.6+) and table partitions 129 (MySQL 5.1.3+) is · Now it is possible to read and set object grants and user permission have no access to mysql database. · Support of all the user permissions (up to MySQL 5.1.12) is provided. 200 even you · A new tool for multi-dimensional analysis, Data Analysis (OLAP Viewer), is implemented in the new version MySQL Maestro. With the tool it is able to slice and dice information efficiently and provide customers with an extremely intuitive end-user experience. Data can be rendered to answer business questions - and best of all - it allows you to focus on business rules rather than creating dozens and dozens of reports. · Server scope objects (such as users, UDFs, etc) are now displayed in the Explorer tree. There is also a separate branch for all the triggers. · SQL Editor improvements: now you can execute each query in a separate thread in order to continue your work with the software while the query is executing. The Procedure and Function editors are also improved for the purpose of executing the routine asynchronously. · Create Object Wizards are improved: now it is possible to specify all the object © 2009 SQL Maestro Group 24 MySQL Maestro Help properties and subitems during its creation. The Create View Wizard now includes the Filter Builder dialog to facilitate creating WHERE condition. Also the wizards became resizable now for more usability. · MySQL security management became easier. Now permissions within the Object Editor. you can set all object · Table Editor: Foreign key references 127 is implemented. This feature allows you to manage foreign keys that are created in other tables and reference columns of the current table. · Object Browser 58 tool for operating on database objects designed as an extension of Database Explorer with advanced features such as sorting, grouping and filtering the database objects. It also provides such operation as multiple selecting of objects (for copying, dropping, etc.) and the ability of using drag-and-drop operations between Object Browser and Database Explorer is implemented. · For your convenience it is implemented the second mode of viewing data as info cards. · New Explorer option "Display system object in different color" allows you to mark system objects with customizable color (purple by default). · Table Editor provides viewing of text fields' contents in data grid. · The Code Folding 255 feature is implemented in all the SQL editors and viewers. The Code Folding item group makes it possible both to view the whole text and to divide it into logical parts (regions). Each part can be collapsed and extended. · SQL Editor: the pair bracket highlight is available for your convenience. · Now it is possible to set character set and collation during the database, table or field creation. They also can be changed within the corresponding editors. · Table maintenance commands (Analyze Table, Check Table, Repair Table, Optimize Table) are now available from the Table Editor or from popup menu of Database Explorer. · Server Editor and Database Editor are added. · MySQL Maestro provides now the ability to describe the object directly from the Database Explorer. · New software look and feel: program icon, installer, splash screen, wizard image and various other interface improvements. In addition to this, a lot of other improvements and bugfixes were made. 09/01/2005 - New version format When setting product versions, we have accepted the following principles for version format: © 2009 SQL Maestro Group Welcome to MySQL Maestro! 25 · · the first figure of the product version stands for the year of release; the second figure of the version is meant to indicate the month of the current version release. For example, MySQL Maestro 5.4 (former version 1.9) indicates that the version was released in April 2005. Please refer the present news item for checking out whether your current product version is the latest one released. 08/02/2005 - MySQL Maestro 1.95 released The key feature of this version is support of triggers, which were actually implemented in MySQL 5.0.10. You can add new triggers to the database and edit existing ones using the Trigger Editor as well as removing needless triggers. Also triggers are now supported by the Extract Database and SQL Script Editor modules. Other improvements and bugfixes: 1. Fixed a bug with reordering table fields for MySQL 4.1 and higher. 2. SQL Script Editor: the CREATE VIEW statements with the ALGORITHM keyword are now displayed correctly in the object tree. 3. Extract Database: now default character set is included into database definition for MySQL 4.1.x and 5.x. 4. Fixed a bug with displaying the View Editor toolbar. 5. SQL Editor: it is now possible to see the results of CHECKSUM TABLE statements. 6. Other small improvements and bugfixes. 04/28/2005 - MySQL Maestro 1.9 released 1. Stored procedures and functions are now compiled correctly under MySQL 5.0.3 and higher. 2. Support of character sets and collations is added to the Create Database and Create Table wizards (for MySQL 4.1.x and 5.x). 3. Support of new MySQL privileges is implemented. Now it is possible to grant/revoke CREATE VIEW and SHOW VIEW privileges (MySQL 5.0.1 or higher) as well as CREATE ROUTINE, ALTER ROUTINE and CREATE USER privileges for MySQL 5.0.3+. 4. The "Manage Database Objects" submenu is added in the popup menu of the Explorer Tree. Use it to quickly open the Object Manager tool with database tables, views, procedures, etc. © 2009 SQL Maestro Group 26 MySQL Maestro Help 5. All database objects now can be dragged from the Explorer Tree to the SQL Script Editor (the SQL definition of the object will be pasted). Also you can drag-n-drop tables and views from the Explorer Tree to the SQL Editor; in this case a SELECT statement will be generated. 6. The Ctrl+F7 and Ctrl+F9 procedures, and functions. shortcuts now can be used to compile views, 7. Russian localization included into the installation package (thanks to Elmir Mirdiev). Earlier our software was also translated to French and Italian languages. 8. The Close View item is added to the Main Menu | Windows | Close submenu. 9. Double-click at the column header area of an object list (fields, indexes, etc) does not invoke the corresponding editor anymore. Similarly double-click at the Data Grid's header does not invoke the Data Input Form. 10. Default values are now displayed correctly in the field list. 11. Fixed the bug with editing DATETIME fields in the Data Grid and Data Input Form. 12. Some other improvements and bug fixes. 12/16/2004 - MySQL Maestro 1.8 released 1. The Code Insight system now supports aliases in SELECT queries. For example, you can type something similar SELECT * from mytable t where t. and MySQL Maestro will display you the list of all the table fields in the popup window. 2. Since this version it is possible to use the "Database Tools" item in the popup menu of the Explorer Tree and Database Profile Manager to get access to some frequently used modules such as SQL Editor, Visual Query Builder, Extract Database, etc more quickly. 3. The Add Index window is redesigned to make index creation more comfortable. 4. Now MySQL Maestro doesn't disconnect from an active database if you change its profile properties (except changing server or database name). 5. Data Grid: double click on the grid now invokes the Data Input form. Also we've added shortcuts for such operations as Export Data, Import Data, Get SQL Dump, etc. 6. It is now possible to open the corresponding object editor directly from the BLOB Viewer (see the "Edit BLOB Source" link). 7. The MySQL Help System is now available for the Security Manager. © 2009 SQL Maestro Group Welcome to MySQL Maestro! 27 8. Some interface changes for improving multilingual support. 9. Some other minor improvements and bug fixes. 10/15/2004 - MySQL Maestro 1.7 released Version 1.7 released. The multilingual support is implemented: now our software can be translated to any language. The Italian (thanks to Giuseppe Maxia and StarData s.r.l.) and French (thanks to Renaud Lepage) translations are included into the installation package. To change the application language, select it from the Main menu | Tools | Languages menu. It is also easy to translate MySQL Maestro to another language: just find the English.txt file in the MySQL Maestro\Languages directory, save it as YourLanguage.txt and translate all the strings from the file using any text editor e.g. Notepad or MS Word. If you send as a new translation, we'll provide you with a free business license of MySQL Maestro. Other improvements and bug fixes: 1. The "Auto link tables by foreign keys" option is added to the Visual Query Builder settings. If this option is on, MySQL Maestro will automatically add links between tables when you add a new table to the Query Builder area. Of course this option works only if your MySQL server supports the foreign keys. 2. The Copy to Clipboard item is added to the Data Grid's popup menu. Use it to copy selected records to the Windows clipboard. Records in the clipboard are separated by the line break character. The Tab character is used to separate values within a record. To copy all the grid records at the same time, you can use the Select All item, which is added as well. Both these operations are also available through the main menu. 3. The Show Filter Panel and Show Subobjects buttons are added to the MySQL Maestro main tool bar. 4. The Ctrl+O and "Ctrl+D" shortcut keys are now associated with Object Manager and Database Profile Manager accordingly. 5. The Data Export page is added to the MySQL Maestro options dialog. Here you can specify the formats for data exporting. If you set ON the Auto save format option, MySQL Maestro saves the data formats each time you change them in the Export Data Wizard. The Set Defaults button resets all the export formats. 6. Since this version it is not necessary to close/open windows with data grids (e.g. Table Editor or SQL Editor) to apply the changes you made in the Options dialog. 7. Security Manager: now grants are set correctly for all MySQL servers (there were some problems with 3.23.xx versions). 8. Some other minor improvements and corrections. 08/25/2004 - MySQL Maestro 1.6 released © 2009 SQL Maestro Group 28 MySQL Maestro Help Version 1.6 released. In this version we have implemented the support for views, which are available in MySQL starting from version 5.0.1. The views are usually used for more friendly representation of data selected from one or several tables. They also can be used to limit an access for data viewing or editing by users. Also we have adapted MySQL Maestro for managing stored procedures and functions, which are belong to individual database instead of a host starting from version 5.0.1 of MySQL server. Several improvements and bug fixes: · Retrieving of stored procedures and functions from a server does not require a user to have any permissions to the 'mysql' database; · Fixed bug in the Export Data Wizard with loading destination file format and file name from a template; · The popup window for parameters input appeared incorrectly in some cases; · Fixed bug in the SQL Script Editor with parsing negative numbers within the INSERT INTO statement in some cases; · Field list on the step for customizing Excel file format could contain duplicate values; · The "Server's host key did not match the signature supplied" error appeared during connection to some SSH servers. Now it is fixed. 07/12/2004 - MySQL Maestro 1.5 released Version 1.5 released. In this version we have implemented a possibility to connect to a remote MySQL server using a secure protocol. The secure connection is established through the Secure SHell (SSH) tunnel, which guarantees a high security for the data transmission between a local PC and remote MySQL server. All the parameters for the SSH connection are stored in database profiles as extra properties, and can be specified as follows: · In the Create Database Wizard 72 , when you create a new database. In this case the SSH connection is established before the database is created, and all the SSH parameters are stored in the database profile, if an appropriate option is checked in the wizard. In the Create Database Profile Wizard 79 , when you register existing database(s). The SSH parameters are also stored in the database profiles. In the Edit Database Profile database profile. 86 · · dialog, when you edit an already registered Also MySQL Maestro can ask you for the SSH parameters when you attempt to retrieve user privileges or server variable list through the SSH tunnel in the Security Manager or Server Properties window. · In addition to the described feature we have made some small improvements and several minor bug fixes. Here is a list of most important changes: © 2009 SQL Maestro Group Welcome to MySQL Maestro! 29 · we've made the Export Data and Import Data wizards sizeable for easier navigation within their controls; the columns containing a user name, user host, and database object are frozen in the Security Manager for convenience purposes now; table type can be reported incorrectly in the Table Properties dialog with MySQL 4.1.3; there could be a problem to create a new database if the server port number was different from the default one; fixed bug with the 'commands out of sync' error occurred with executing subqueries in the SQL Editor in some cases. · · · · 05/28/2004 - MySQL Maestro 1.4 released Version 1.4 released. Now it is possible to manage several table subobjects at once e.g. · create/edit/drop all the indexes and foreign keys for a whole database. This feature is available in the Create Database Object dialog, which can be invoked from the Object menu; drop several fields, indexes, or foreign keys at a time for a table: just select required objects at the proper page of the Table Editor and simply press the Del key; copy several fields, indexes, or foreign keys from one table to another: you can do it using standard Copy/Paste functions or by drag-n-drop between two instances of the Table Editor. · · Several minor bugs were fixed: · there were some troubles with copying tables containing foreign keys from one database to another; the Copy Database wizard did not copy tables with foreign keys properly in some cases. The "Disable foreign key checks" option was added to the final step of the wizard to avoid this problem; the Windows -> Close All menu item did not closed all child windows in some cases; · · · the database explorer did not restore its width after sequential hiding and showing by its splitter. 04/09/2004 - MySQL Maestro 1.3 released In this version we have implemented the Object Manager 55 - a feature-rich tool for easy manipulation of database objects. Now it is possible to work with tables, queries, © 2009 SQL Maestro Group 30 MySQL Maestro Help procedures and other database objects as easy as it can be. Here are some examples, which demonstrate how you can use the new tool: · you can open several database objects at a time; · you need to clear data from all database tables? Just open the Object Manager, press Ctrl+A, then choose Empty Tables from the popup menu; · in earlier versions of MySQL Maestro you can copy a table definition to the clipboard by Ctrl+C and then paste it in the same or different database. Now it is possible to process several tables at once; · it is also possible to drop several database objects at a time. Hope you will treat this tool carefully. · full drag-n-drop support is available: you can drag objects between the Object Manager and the Database Explorer as well as between two instances of the Object Manager; and much more. The Object Manager starts automatically when you connect to a database. It is possible to disable this feature in the Options dialog as well as call the Object Manager manually from the Object menu. We also have fixed several bugs: · the Diagram Viewer did not clear the list of fields after switching to another database using combo box in the Database group area. This bug could cause some instability of the application; · the Move Up/Move Down menu items did not work in the field list on the second step of the Create Table wizard; · some steps of the Create New Procedure and Create New Function wizards did not open the proper help topic after clicking on the Help button. 03/08/2004 - MySQL Maestro 1.2 released The main feature of this version is the Diagram Viewer 271 . It is a tool for representing data from a table or a query as a diagram in various ways. Also the Diagram Viewer has the Export diagram image feature, as well as the Export diagram data one, with a lot of formats supported. The interface of the new tool is liked to BLOB Viewer, so we hope it will be easy to use. Some technical details: · you can save the diagram as Bitmap, PDF, JPEG, GIF, PostScript, Metafile, VML, PNG, or PCX file. Of course it is possible to open the result file in the associated application (e.g. Paint, Acrobat Reader, Photoshop, etc) directly from MySQL Maestro; © 2009 SQL Maestro Group Welcome to MySQL Maestro! 31 · · · · supported diagram types are: bar, line, area, point, pie, or fast line; it is possible to show/hide diagram axis; it is possible to show/hide the diagram legend; it is possible to specify axis labels source and diagram header. The Diagram Viewer is located in the Tools menu, the appropriate button on the toolbar is also available. Several minor bugfixes: · the confirmation dialog appeared for each database object dropping even if an appropriate option was off in the Options dialog. Now this bug is fixed; · fixed bug with impossibility to disconnect from a database if the MySQL server was shut down during the connection session; · group boxes did not appear in accordance with current scheme in some cases. 02/04/2004 - MySQL Maestro 1.1 released In this version we have implemented the Database Profile Manager, which is a tool, designed as an extension of the Database Explorer with some advanced features. In particular, it allows you to: · connect/disconnect several databases at a time; · remove a group of database profiles. It is useful if you don't work with these databases any more; · get quick access to the selected database profile properties. Of course it is also possible to create a new database, attach an existing database to MySQL Maestro, or drop a database. The Database Profile Manager can be launched by the proper menu item from the main menu or by the corresponding button on the toolbar. Also we have fixed some minor bugs: · the Create Database Profiles wizard did not work with servers, which do not allow to execute the SHOW DATABASES command to retrieve the list of available databases. The corresponding options was added to the wizard to fix this bug; · fixed bug with impossibility application session; to create more than one database during one · there was a bug with reordering database profiles in the database explorer using drag-and-drop operations; © 2009 SQL Maestro Group 32 MySQL Maestro Help