Choose your database:
AnySQL
MySQL
MS SQL Server
PostgreSQL
SQLite
Firebird
Oracle
SQL Anywhere
DB2
MaxDB

Subscribe to our news:
Partners
Testimonials
Edward Littel: "MS SQL Data Wizard has been great for managing our Microsoft SQL data. I recommend the software highly".
Kelly Dires: "First let me say we are very impressed with Firebird Data Wizard, it was not only the fastest but also the easiest to use out of the six tools of this class tested".

More

Add your opinion

SQL Maestro Group / News / All company news / MS SQL Maestro 14.4 released

MS SQL Maestro 14.4 released

Apr 10, 2014

Prev Next

 
SQL Maestro Group is happy to announce the release of MS SQL Maestro 14.4, a powerful Windows GUI solution for Microsoft SQL Server administration and database development.

Please consider the list of new features implemented in this version since the last official release:

Server management extensions:

  • This version of the software has been successfully tested with Microsoft SQL Server 2014.
  • Starting from this version, you can connect to a database using any of SQL Server Native Clients installed on your computer (whereas all the previous versions operated only via Microsoft OLE DB Provider for SQL Server). To choose a client you want to use, select the appropriate item in the Provider combobox in the Create Database Profiles or Edit Database Profile windows.

    Create Database Wizard: selecting a providerPicture 1. Create Database Wizard: selecting a provider

    The table below shows the correspondence between the value selected in the Provider combobox and SQL Server client to be used.
    ValueSQL Server clientIntroduced with
    SQLOLEDBMicrosoft OLE DB Provider for SQL Server (default value)Comes with Windows
    SQLNCLISQL Server Native ClientSQL Server 2005
    SQLNCLI10SQL Server 2008 [R2] Native ClientSQL Server 2008 [R2]
    SQLNCLI11SQL Server 2012 Native Client (recommended)SQL Server 2012

    We would recommend you to install and use SQL Server 2012 Native Client as it provides the best support for data types implemented in the recent versions of SQL Server. Also it (and only it) allows you to work with SQL Server Express LocalDB databases.

    Connecting to a LocalDB sample databasePicture 2. Connecting to a LocalDB sample database

  • Get SQL Dump wizard has been significantly updated:
    • 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.

      SQL Dump: target column orderPicture 3. SQL Dump: target column order

    • 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 MySQL, PostgreSQL, Oracle, Firebird, or SQLite.

      SQL Dump: setting SQL syntaxPicture 4. SQL Dump: setting SQL syntax

  • Starting with this version the warning appears on creating a table without a primary key.

    Warning messagePicture 5. Warning message

  • From now on, you can disable the refresh of extending properties if you don't use them to speed us the initial database connection. Object descriptions (which are actually also extended properties) will come correctly irrespective of value of this option.

    Database refresh optionsPicture 6. Database refresh options

  • Hints for connected databases now include the name of the database collation.

    Database's hintPicture 7. Database's hint

  • Jobs are now displayed in alphabetical order and job steps are displayed in order of execution.

Interface improvements:

  • 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.

    Nullable Column CheckerPicture 8. Nullable Column Checker

  • 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.

      SQL Editor result tabs imagesPicture 9. SQL Editor result tabs images

    • 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.

      SQL Editor: copy selected text as a string written in programming languagePicture 10. SQL Editor: copy selected text as a string written in programming language

  • 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.

    Colored profilesPicture 11. Colored profiles in the explorer tree

  • Hints for foreign key columns now include the name of the parent table.

    Foreign key column hintPicture 12. Foreign key column hint

  • Data Import features:
    • 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 13. 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 14. 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.
  • Data Export: Support for Json file format has been implemented.

    Data Export to JSONPicture 15. Data Export to JSON

  • 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.

      Multi-column lookup editorPicture 16. Multi-column lookup editor

    • The headers of required columns are marked with a red asterisk.

      Key columns in the data gridPicture 17. Key columns in the data grid

    • To reset all grid settings to defaults, open the Data tab when holding the Ctrl key.

In addition to this, several bugs have been fixed and some other minor improvements and corrections have been made.


Related links:

MS SQL Maestro home page
Download MS SQL Maestro
Purchase your license of MS SQL Maestro today!
Prev Next