AnySQL Maestro Changelog

What's new in AnySQL Maestro 16.12.0.16

Feb 24, 2022

New features:
AnySQL Maestro has been optimized to work with some popular DBMS. Also we have successfully tested the software with the latest versions of database servers and OLE DB Providers / ODBC drivers.
Nullable Column Checker has been implemented. This feature allows you to refactor your database schema by enforcing omitted NOT NULL constraints. It is useful, for example, if you have got a legacy schema with a lot of columns allowing NULL values and plenty of data. To invoke the wizard, use the appropriate link in the Generate SQL section of the table popup menu at the Explorer tree.
Data Import features:
From now on it becomes possible to execute custom SQL scripts in all database connections established by the software.
Custom SQL scripts settingsPicture 9. Custom SQL scripts settings
Support for Adobe Reader DC has been added to BLOB Editor. Also the editor window now saves its size and position between times it is opened (for each table).
BLOB EditorPicture 10. BLOB Editor
Starting from this version it is possible to select a tab color for windows that belong to a certain database. This could help you to distinguish windows with the same caption but a different parent database (such as SQL Editor) with ease. The color can be specified at the Options tab in the Database Profile Properties dialog.
Colored tabsPicture 11. Colored tabs
For the same purpose tab hints now include the profile name.
Tab hintsPicture 12. Tab hints
Starting from this version a warning message appears on creating a table without a primary key constraint.
Warning message on creating a table without a PKPicture 13. Warning message on creating a table without a PK
In Data Grids and Data Input Forms computed columns are marked by a green calculator.
Generated columns in the Data GridsPicture 14. Generated columns in data grids
Support for a number of new encryption algorithms has been added to Data Grid. Now it is possible to encrypt the value of a text column, for example, by SHA512 or Haval224 algorithm with a couple of mouse clicks.
Data encryptionPicture 15. Data encryption
Data Input Form: controls containing values of primary and foreign key columns are now marked with the 'gold key' and 'silver key' images accordingly. Controls containing values of required (NOT NULL) columns are marked with a red asterisk.
Data Input Form: marking important controlsPicture 16. Data Input Form: marking important controls
Data Grid: To reset all grid settings to defaults, open the Data tab when holding the Ctrl key.
Starting with this version it's possible to import data from several files at a time. To import data from multiple files with the same structure, set the mask of the file names to the corresponding field. To see the list of matching files, use with the button on the right.
Import data from multiple filesPicture 2. Import data from multiple files
The Column Builder for text files with fixed column width has been redesigned. Now to set the correspondence between table columns and areas of a text file, you can either input offset and width for each column directly into the controls, or define these values by clicking the left mouse button in the right area of the tool.
Column BuilderPicture 3. Column Builder for text files with fixed column width
Now it's possible to add current timestamp to the log file name using the %ts:TIMESTAMP_FORMAT% string template. Examples of valid datetime formats are: 'YYYY-MM-DD', 'YYYY-MM-DD-HH24-MI', 'YYYY-MM-DD-HH24-MI-SS', and so on.
Now each time you start the wizard to import data to a table it stores all the options as them were set on the previous session of working with this table.
Starting from this version it is possible to import empty values as empty strings (while previous versions always imported such values as NULLs).
Data Import: working with empty valuesPicture 4. Data Import: working with empty values
Default Data Import settings can now be set up in the Program Options dialog.
Data Import defaultsPicture 5. Data Import defaults
Data Export:
Support for Json file format has been implemented.
Data Export to JSONPicture 6. Data Export to JSON
From now on it becomes possible to specify caption, width, and alignment for output columns (when applicable).
Data Export: customizing output columnsPicture 7. Data Export: customizing output columns
Also it becomes possible to add current timestamp to the output file name.
Data Export: adding current timestamp to output file namePicture 8. Data Export: adding current timestamp to output file name

New in AnySQL Maestro 16.12.0.15 (Oct 8, 2021)

New in AnySQL Maestro 13.2.0.1 (Mar 4, 2013)

AnySQL Maestro has been optimized to work with some popular DBMS. Also we have successfully tested the software with the latest versions of database servers and OLE DB Providers / ODBC drivers and updated the Connection String Reference accordingly.
Now it is possible to rename output columns in the result SQL script. To set a new target column name, enter a value to the Target column in the grid at the first step of the wizard.
You can also change the order of output columns using the appropriate commands of the popup menu or Ctrl+Up and Ctrl+Down shortcuts.
Starting with this version it is possible to specify the SQL syntax the result script to be written on. This feature allows you to restore the dump contents to a table in a different database server such as PostgreSQL, SQL Server, Oracle, Firebird, or SQLite.
The Start Page has been redesigned in order to provide quick access to recently connected database profiles and display the latest company news.
SQL Editor features:
Now on executing several statements from a single editor tab (did you know about such a possibility?), the corresponding result tab is marked with an appropriate image.
Starting from this version you can copy the selected text from any editor to Clipboard as a ready-to-use string written in one of the following programming languages: C#, C++, Delphi (Object Pascal), and Java. This feature is accessible in the Export section of the editor area popup menu.
From now on you can use shortcuts based on the F5 key to execute your queries in various ways (this is to ease life of Visual Studio users). The complete list of new shortcuts is as follows:
F5 Execute the whole query
Alt+F5 Execute only selected text
Shift+F5 Execute the query as SQL script (no dataset is returned). The reason of implementing this mode is that it is slightly optimized to execute statements that do not return data such as INSERT or CREATE TABLE.
Ctrl+F5 Execute the statement at the cursor position.
Of course the same actions are still available through F9 and F8 shortcuts. For example, you can use Alt+F8 to execute the selected text or Ctrl+F9 to execute the statement at the cursor position.
Database Explorer: now it is possible to assign a custom color to a certain database profile. For example, you can mark development and production databases in different colors in order to prevent casual metadata or data changes in the production. The desired color can be selected at the Options tab in the Edit Database Profile dialog.
Script Runner allows now to execute archived scripts directly from .zip files. The tool unpacks zip archives to temporary files by itself for further executing.
Data Grid features:
Multi-column lookup editors become available. Such editors modify values of several columns in the record simultaneously in order to guarantee referential integrity.
Data Input Form has been significantly improved. Now it simplifies the input of data with lookup menus for columns linked with foreign keys and a calculator for DECIMAL columns.
Now the headers of primary and foreign key columns are marked with the 'gold key' and 'silver key' images accordingly as well as the headers of required columns are marked with a red asterisk. The existence of any column marked with a gold key in the dataset means that you can modify/delete the records of this dataset without risk of updating/deleting several records at a time.
Data Import features:
From now on it is possible to import data from CSV files that contain multi-line strings.
A possibility of setting the correspondence between source and target columns by column name has been implemented (previous versions allow you to set such a correspondence only by column index).
Data Export: now it is possible to specify decimal and thousand separators for the generated files (when applicable).
The progress windows are redesigned in the modern style and become more informative.
Table Editor Options: starting with this version it's possible to allow the application to open details at the Data tab automatically.

New in AnySQL Maestro 12.5.0.5 (Nov 14, 2012)

Autoincrement columns are now recognized for MS SQL Server and MS Access. Unfortunately, other DBMS do not provide the appropriate information correctly.
The SQL editor component has been dramatically improved (applied to SQL Editor, SQL Script Editor, and editors of objects containing SQL bodies such as views, stored procedures, and triggers):
Unicode support has been implemented. Starting with this version you can view and edit queries and scripts containing string literals in almost any possible language including, for example, Russian, Chinese and Japanese.
Also it becomes possible to load/save files in different encodings. If you try to save an SQL script containing non-locale characters to a file in an incompatible encoding, a warning about a potential loss of data will be issued.
Text change markers are now at your disposal. Yellow markers show changed but unsaved lines of code, and green markers show changes in this session that have been saved.
The code folding appearance has been updated. In particular, the new version introduces support for fold signs as well as improved look and feel of the folding margin and hints.
Drag-n-drop from Windows Explorer has been added to SQL Editor and SQL Script Editor. Now to open a file in one of the editors, just drag it at Windows Explorer and drop at the editor area.
The performance of SQL Script Editor has been significantly increased especially on large script editing. In addition to this the name of the file loaded to the editor area is now displayed at the right bottom corner of the window.
Script Runner has been slightly changed in appearance and performance. Now the name of the database the script to be run on is displayed at the top of the window, the name of the script file may be quoted, and the script files in the UTF-8 encoding may optionally start with a byte order mark.
Data Grid features:
Now it is possible to display images directly in the grid. To enable/disable this view mode or change the image fitting, use the Manage inline images item of the column popup menu.
Data Input Form has been significantly improved. Now it simplifies the input of data with lookup menus for columns linked by a foreign key with another table and a calculator for numeric columns. The form can be invoked now with Ctrl+Alt+D shortcut.
Now the headers of key and key autoincrement columns are marked with the 'key' and 'key&plus' images accordingly. The existence of a key column in the dataset means that you can modify/delete the records of this dataset without risk of updating/deleting several records at a time and 'key&plus' means that the column values are calculated automatically and you can leave this field blank.
Visual Query Builder: the Create view from SQL link has been added to the Navigation panel. This feature allows you to create a view based on a SELECT query prepared within the builder as quickly as possible.
BLOB Viewer: starting with this version it's possible to view or edit BLOB data as PDF document.
A Spanish translation is now included into the installation package. Other available languages are English, German, French and Italian.
Data Import: now each time you start the wizard to import data to a table it stores all the options as them were set on the previous session of working with this table.

New in AnySQL Maestro 10.7.0.7 (Jan 6, 2011)

Database profile management extensions:
Starting with this version it is possible to reorder database groups in the Explorer Tree as well as reorder databases from the same group. You can also sort database groups and databases in an alphabetical order.
Now all the database profiles related to the same group may be deleted at once.
The Rename Database Profile command has been added to the popup menu. Use this command to rename a profile without opening its editor.
Interface improvements:
This release has been successfully tested with 64-bit operating systems including Windows 7 x64.
Table Editor:
A possibility of importing data from Clipboard has been implemented. It is supposed that columns within the data block are separated by the tabulation symbol, records are separated by newlines and the first line of the data block contains column headers.
The same data format is supported by a lot of other applications, so it is easy to use this feature to quickly copy data from MS Excel, another table or view, or even from a data set from a different DBMS especially if it is opened with an appropriate our product.
The Script Runner window can now be invoked directly from the Tools menu. Also the productivity of this tool has been significantly improved.
Data Analysis tool features the following things:
Starting with this version it is possible to use a wide spectrum of aggregate functions such as maximum, minimum, average value, etc. for subtotals (the only available function for the previous versions was sum of values).
A possibility of sorting data by summary columns has been added. This means, for example, the product you'll see first is not the one which starts with an A or Z, but rather the one that has the most or least sales.
You can also specify the number of top rows that are displayed to view, for example, only a specific number of best-selling or worst-selling products for each year, month, customer, etc. This will help you to concentrate on only the most important information and avoid being overload with a lot of superfluous data.
The Update Existing Records option has been added to the Data Import wizard. If this option is turned ON, the records will be either updated or inserted (Firebird 2.1+, MySQL, SQLite).
Data Grid features the following things:
The Clone current record command has been added to the popup menu. Use it to add a new record which is substantially similar to an existing one.
Multi-column sorting has been implemented. To sort data on multiple columns, use the Advanced sort command from the grid's header popup menu.
Starting with this version the number of grouped records is displayed for the group's header.
SQL Editor:
The Go to Line command has been added to the popup menu (Ctrl+G shortcut). Also field data types are now displayed in the Code completion window.
BLOB editor:
Starting with this version it is possible to select a BLOB column to edit directly within the editor window.
The Case Insensitive option has been added to data grid filter settings (ON by default).
BLOB Viewer/Editor:
Starting with this version it's possible to customize PHP syntax highlighting for the text representation of BLOBs.
Database Designer:
A possibility to select objects with Ctrl has been implemented.