What's new in MS Compact Maestro 17.9.0.1
Sep 29, 2017
- New feature highlights:
- Starting from this version it is possible to specify a custom label and/or a font color for server nodes in the Database Explorer tree.
- To change these properties, right-click a server node, select "Edit Server Properties" from the popup menu and provide the values you need in the modal dialog.
- 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.
- For the same purpose tab hints now include the profile name.
- Data Import features:
- Starting with this version it is possible to import data from multiple files with the same structure at a time. To import data in this way, specify a mask of file names in the corresponding input field. To see the list of matching files, click the button on the right of the control.
- The Column Builder tool 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.
- Starting from this version it is possible to import empty values as empty strings (while previous versions always imported such values as NULLs).
- Now it is 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.
- Default data import settings can now be set up in the Program Options dialog.
- All the wizard options are now stored/restored between the data import sessions for a certain table.
- The Statistics tab has been added to the Edit Database Profile dialog. Here you can find such information as profile creation time, total number of connections, last connection time, and so on.
- From now on it becomes possible to execute custom SQL scripts in all database connections established by the software.
- Data Export features:
- Support for JSON file format has been implemented.
- From now on it becomes possible to specify caption, width, and alignment for output columns (when applicable).
- Also it becomes possible to add current timestamp to the output file name.
- Data Grids have been improved as follows:
- Support for a number of new encryption algorithms has been implemented. Now it is possibleto encrypt the value of a text column, for example, by SHA512 or Haval224 algorithm with a couple of mouse clicks.
- Table Editor: to reset all data grid settings to defaults, open the Data tab when holding the Ctrl key.
- Now it is possible to copy the value of the selected cell to Clipboard using grid's popup menu or Ctrl+Shift+C shortcut.
- 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.
- 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).
- Starting from this version a warning appears on creating a table without a primary key.
- Links to our social networks accounts have been added to the Quick Launch panel. As minor versions are announced only in our Facebook and Twitter, we would recommend you to follow us somewhere to stay informed.
- In addition to this, a number of bugs have been fixed and some other minor improvements and corrections have been made.