Customers
MS SQL Maestro online Help
Prev  |
Return to chapter overview | Next  |
What's new
11/01/2008 - MS SQL Maestro 8.11 released
SQL Server 2008 management extensions:
| • | Support for new SQL Server 2008 data types (Date, Time, Datetime2, DatetimeOffset) has been implemented. |
| • | Since this version MS SQL Maestro provides support for user-defined table types. You can use such a type to declare table-valued parameters for stored procedures or functions, or to declare table variables that you want to use in a batch or in the body of a stored procedure or function. |
| • | Support for both row and page compression for both tables and indexes has been added. This feature is available only in Enterprise and Developer editions of SQL Server 2008.. |
Other server management extensions:
| • | Objects are now grouped by schemas for SQL Server versions 7.0 and 2000. |
| • | Index editor: support for Allow row locks and Allow page locks options has been added (SQL Server 2005+). |
Interface improvements:
| • | Data grid features the following things: |
| o | Starting with this version it is possible to use the lookup editor 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 (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 ntext columns. |
| o | It is now possible to restrict maximum column width. |
| • | The Dependency tracker tool has been implemented (Main Menu | Tools | Dependency tracker). Use this tool to browse all-level dependencies of a schema object (table, view, function, etc). |
| • | A French localization is now included into the installation package. |
| • | This version of our software is fully compatible with large fonts (120 DPI). |
| • | Database Explorer: 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. |
| • | Database Designer 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. |
| • | Process Browser: the statements at the Last SQL tab are now formatted if possible. |
| • | 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. |
| • | Data import wizard: the interface for adding and editing of replacements has been slightly improved. |
| • | SQL Script Editor settings: the "Use script runner for large scripts" option has been added. |
| • | Create Database Wizard, Create Profiles Wizard, and object creation wizards become resizable. |
| • | Data Export, Data Import, and Get SQL Dump wizards now store their size and position. |
01/08/2008 - MS SQL Maestro 8.1 released
Server management extensions:
| • | Extended property management has been implemented. Now you can add/edit/drop such properties for tables, views, procedures, columns, indexes, etc. |
| • | Since this version our software allows you to view and analyze SQL server logs (of course if you have enough privileges for this operation). |
Interface improvements:
| • | The SQL Generator 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 or SQL Script Editor. |
| • | Data Grid 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 / View Editor. 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). |
| • | Create Database Profiles wizard: the Hide already registered databases option has been added. |
| • | Object editors, SQL Editor, Database Designer, BLOB Viewer and other database-dependent windows: only connected databases are now displayed in the drop-down list. |
| • | The F11 key is now used to show the Explorer tree. |
10/15/2007 - MS SQL Maestro 7.10 released
Server management extensions:
| • | Now it is possible to cancel a long-running query execution (SQL Server 2005) and/or data fetching (all SQL Server versions). |
| • | This version has been successfully tested with SQL Server 2008 July CTP. |
| • | The Backup Database tool has been implemented (Main Menu | Tools | Backup Database). You can back up a whole database, files and file groups, transaction logs, etc. It is possible to execute the result command immediately or create a scheduled job. |
| • | Attach and Detach Database wizards are now available in the Database menu. |
| • | SQL Script Editor: the results of the PRINT statements are now captured in the message window. |
| • | Job Editor: the History tab is added. Now you can see the results of the job execution including individual steps. |
Interface improvements:
| • | The SQL Formatter for DML statements (SELECT, INSERT, UPDATE and DELETE) is fulfilled. It can be invoked with the aid of the Format SQL link on the SQL Editor's navigation bar (Ctrl+Alt+D shortcut). |
| • | Data Grid: Unicode data are now displayed rightly. |
| • | It is now possible to execute SQL scripts after connect and before disconnect to/from a database. |
| • | Database Designer: now you can drag a schema in the Explorer tree or Object Browser and drop it in the Designer window: all schema tables will be added to the current diagram. |
| • | Now our software displays execution time for lengthy operations. |
| • | BLOB Viewer: it is now possible to save all BLOBs from a table to a given directory. |
| • | Data Import Wizard: the speed of loading of Excel files has been significantly increased. |
Important fixes:
| • | SQL Server 2005: foreign keys are now recognized correctly even if parent and child tables are located in the different schemas. |
| • | SQL Server 2000 SP3: from time to time some table indexes had not been displayed. It is fixed now. |
5/15/2007 - MS SQL Maestro 7.5 released
Server management extensions:
| • | Support for Service Broker objects is added (SQL Server 2005). Since this version you can manage them as follows: |
| • | Queues: creating, editing, dropping, viewing contents, and receiving messages. |
| • | Message types: creating, editing, and dropping. |
| • | Contracts: creating, editing, dropping, viewing message types used. |
| • | Services: creating, editing, dropping, viewing contracts used. |
| • | Conversations: creating and ending. |
| • | Process Browser 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 process (such as login, 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. |
| • | Sometimes the "CommandText does not return a result set" error message occurred when user tried to create a new database. The bug is fixed now. |
Interface improvements:
| • | Database Designer: 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 and SQL Script Editor. Now it is possible: |
| • | 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; |
| • | convert selected text to different cases (lower, UPPER, and NameCase); |
| • | export the contents of the editor to RTF and HTML formats (to file or to clipboard); |
| • | 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; |
| • | Explorer tree: the Browse command is added to lists' popup menus (runs the Object Browser tool). |
3/7/2007 - MS SQL Maestro 7.3 released
Server management extensions:
| • | Support of the partitioning features is implemented (SQL Server 2005). In particular, the new version allows you to: |
| • | create, edit and drop partition functions including range merging; |
| • | create, edit and drop partition schemes; |
| • | specify partition scheme as a dataspace for tables and indexes. |
| • | Since this version it is possible to specify command timeout (in seconds) in the Options dialog; |
Interface improvements:
| • | The main feature of the new version is Graphical Database Designer - 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 Microsoft SQL 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 structure and make its modification in an easy and clear way. |
| o | Now you can quickly and easily print your database structure with a lot of options including header and footer, paper size and orientation, etc; |
| o | A rich set of options and settings give you a way to see your database in your own look and feel style. |
A diagram of your database can help you define operational aspects of your application logic that you might otherwise overlook. Also, a well-defined data diagram that accurately represents your tasks can be helpful in orienting employees to goals and operations.
| • | SQL Editor: now MS SQL 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/11/2006 - MS SQL Maestro 6.12 released
Server management extensions:
| • | Full-Text Catalogs and Full-Text Indexes management (Microsoft SQL Server 2005 Enterprise Edition); |
| • | 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; |
| • | MS SQL Maestro now stores parameters history for procedure execution so you can choose a set of already used values instead of entering them manually; |
| • | SQL Script Editor: if a user opens a file larger than 100K, MS SQL 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, a tool to represent your data as OLAP cubes; |
| • | Database profiles are now grouped by host+port+login combination rather than host+port in the previous versions; |
| • | The Table Editor interface is improved: now all the subitems i.e. fields, indexes, and triggers are displayed at the main editor tab. We found this layout more comfortable; |
| • | BLOB viewer/editor: 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: we've added an option for converting new object names to lower/upper case; |
| • | Data grid: the speed of data loading was significantly increased. |
07/16/2006 - MS SQL Maestro 6.7 released
The new version of MS SQL Maestro, a powerful Windows GUI solution for Microsoft SQL server administration and database development, has been released.
Please consider the list of all the new features implemented in MS SQL Maestro 6.7:
Server management extensions:
| • | Symmetric and Asymmetric keys management (Microsoft SQL Server 2005); |
| • | support of certificates and credentials provided (Microsoft SQL Server 2005); |
| • | provided support for logins based on certificates and asymmetric keys (Microsoft SQL Server 2005). |
Interface improvements:
| • | we have implemented the Object Browser tool, which operates like Object Manager, but includes some additional features such as properties grouping, filtering, and sorting. For example it is easy to find all the tables, which have more than 10 fields or all the domains based on INTEGER type in a few mouse clicks. You can also open several objects' editors simultaneously as well as drop all the selected objects by a single operation; |
| • | all the system objects such as master or msdb objects now can be displayed in a different color (purple by default). The color can be set in the Options window (the Explorer tab); |
| • | the connected databases are now displayed in bold everywhere (object editors, Object Manager, Object Browser, etc); |
| • | the Describe Object command is now included into the popup menu of each object as well as into navigation bars. Use it to specify the object's comment without opening its editor; |
| • | improved Create Login Wizard; |
| • | the F8 and Shift+F8 key shortcuts now can be used to open/execute queries in the SQL Editor. F9 and Shift+F9 work too. |
In addition to this, several bugs were fixed and some other minor improvements and corrections were made.
06/12/2006 - MS SQL Maestro 6.6 released
The new version of MS SQL Maestro, a powerful Windows GUI solution for Microsoft SQL server administration and database development, has been released.
Please consider the list of the new features implemented in MS SQL Maestro 6.6:
Server management extensions:
| • | implemented Foreign key references, the feature allows you to manage foreign keys that are created in other tables and reference columns of the current table. |
Interface improvements:
| • | 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 Editor is also improved for the purpose of executing the routine asynchronously; |
| • | MS SQL Maestro wizards windows are resizable now for more usability; |
| • | the server version can now be viewed from the tool tip of the database node; |
| • | added an ability to edit object properties directly from the explorer tree without opening the object editor; it helps you to make your work with your Microsoft SQL database objects faster; |
| • | added an ability to rename an object directly from the explorer tree without opening its editor; |
| • | added more key shortcuts: a new query can be created in SQL Editor through the Ctrl+N shortcut and deleted through the Ctrl+R shortcut. |
In addition to this, several bugs were fixed and some other minor improvements and corrections were made.
05/12/2006 - First public release of MS SQL Maestro
MS SQL Maestro is a powerful solution for the Microsoft SQL Server administration and development. It allows you to create, edit, copy, extract and drop all the database objects such as tables, views, procedures, UDFs, UDTs, aggregates, certificates, 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 Microsoft SQL Server users, roles, logins and their privileges, and use a lot of other tools designed for the easiest and most efficient work with Microsoft SQL Server.
Our product versions are formalized according to the date when they are released: 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. Hence, the present version is 6.5. For more information apply to the corresponding news item.
While developing the new software product we tried to include the usable features available in the existing products and to provide it with unique functionality. Please consider the short list of MS SQL Maestro 6.5 features below:
| • | support for Microsoft® SQL Server™ 7.0 and Microsoft® SQL Server™ 2005 versions: XML data type and XML indexes support, availability of schemas, support for CRL Procedures, synonyms, assemblies, etc.; |
| • | easy database management: the conception of database profiles gives you the opportunity to connect to databases in one touch and work with the selected databases only. Of course, it is also possible to create or drop a database; |
| • | powerful database object management: the application includes a number of handy wizards and editors, database explorer allowing you to perform all necessary operations upon databases and their objects (creating new database objects, editing existing ones as well as duplicating and renaming objects); |
| • | user-friendly interface: easy-to-use GUI provided by MS SQL Maestro will make your Microsoft SQL database management and administration easy and efficient; data can be viewed either as tables or as summary cards; Object Manager and Object Explorerallow you to fulfill complex data manipulation tasks irrespective of your personal level of competence in this or that server feature; |
| • | building and executing queries: MS SQL Maestro provides 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; |
| • | powerful security management: implemented a number of powerful editors, which allow you to manage Microsoft SQL users and their privileges as easy as it can be, even if you are not a skilled Microsoft SQL Server administrator; |
| • | powerful BLOB viewer/editor: opportunity to view and edit the content of the BLOB fields in various representations such as hexadecimal dump, plain text, graphical image or HTML page; graphical representation of BLOB data supports the following image formats: BMP, Windows metafile, JPEG, GIF and PNG; |
| • | data export module: exporting data from Microsoft SQL Server tables and queries to files of the 14 most popular formats including MS Excel, MS Access, MS Word, HTML, XML, PDF; |
| • | data import module: importing data to Microsoft SQL Server tables from files of the following formats: MS Excel, MS Access, XML, DBF, TXT and CSV. |
The list of useful features implemented in our software product can be continued. MS SQL Maestro gives you easy-to-use tools for creating a new table in a few mouse clicks, getting SQL dump of your metadata and data (even without knowing the syntax), getting a high-quality printable report for your database, executing any SQL script, using drag-n-drop operations or pressing Ctrl+C/Ctrl+V key shortcuts to copy a table from one database to another and a lot of other features.
We hope that our product will certainly help you to have pleasure when working with your Microsoft SQL server!
| Prev |
Return to chapter overview | Next |
