MS SQL Maestro is a powerful Windows GUI solution for Microsoft SQL server administration and database development

MS SQL Maestro  is the premier GUI admin tool for Microsoft SQL Server and MSDE management, control and development. Key features include: Support for all Microsoft SQL Server versions from 7.0 to 2008 Easy database object management Database Designer Comfortable access to SQL server security features Data management: editing, grouping, sorting and filtering abilities Handy SQL Editor with code folding and multi-threading Visual Query Builder with support for subqueries and UNIONS Data export/import to/from the most popular formats Powerful BLOB Viewer/Editor The application also provides you with a powerful set of tools to edit and execute SQL scripts, build visual diagrams for numeric data, compose OLAP cubes, and much more. Easy installation and intuitive interface in combination with support of all the SQL Server latest features up to version 2008 make it an irreplaceable tool for MS SQL Server on the web or at your local desktop.

 

Top 10 reasons to use MS SQL Maestro

Latest Microsoft SQL Server version support MS SQL Maestro supports all the latest versions of Microsoft SQL Server

Use MS SQL Maestro to work with any Microsoft SQL Server version from 7.0 to 2008! MS SQL Maestro supports the latest MS SQL features such as schemas, synonyms, xml schema collections, assemblies, symmetric and asymmetric keys, credentials, certificates, schedules and much more.

Powerful security management Microsoft SQL Server security system is easy and clear in MS SQL Maestro

A highly secured Microsoft SQL Server database created in several mouse clicks becomes a reality! MS SQL Maestro provides you with several helpful wizards and editors which allow you to manage Microsoft SQL Server logins, users, roles and their privileges as easy as it can be, even if you are not a skilled Microsoft SQL Server administrator.

Easy database objects management MS SQL Maestro is incredibly easy in database objects management

Windows clipboard, drag-and-drop operations, local pop-up menus - all of them can be used with database objects now! For example, to copy an object, simply drag and drop the object from one database to another, or use the Ctrl+C and Ctrl+V shortcuts instead of performing a long succession of manual operations.

Clear in use Even a newbie can use MS SQL Maestro

MS SQL Maestro is as easy in use as Windows explorer! MS SQL Maestro provides you with an understandable "explorer-like" navigation style, well-described wizard system, quick launch panel, and a lot of other tools and features, which do not require a deep knowledge of Microsoft SQL Server.

Advanced SQL Editor MS SQL Maestro allows you to create and execute queries in the most convenient way

Handy SQL Editor provides you with an ability to execute several queries simultaneously. Each query is executed in a separate thread, so all MS SQL Maestro opportunities remain available and there is no need to wait for your complex query to be completed. Such features as syntax highlighting and code completion make your work with the Editor extremely comfortable.

Powerful data export and import MS SQL Maestro provides you with advanced data export and import abilities

MS SQL Maestro supports more than twelve formats for data export and six formats for data import. These are MS Excel, MS Access, MS Word, RTF, HTML, PDF, XML, CSV, DBF and more. Moreover, MS SQL Maestro does not require any additional software installed for all the supported formats.

Full support for BLOB fields MS SQL Maestro has an ability to view BLOB data in various ways

Using MS SQL Maestro you can view or edit BLOB data in the following ways: hexadecimal dump, plain text, graphical image or HTML page. A graphical representation of BLOB data supports five image formats: BMP, Windows metafile, JPEG, GIF and PNG.

Viewing data as diagrams MS SQL Maestro allows you to build diagrams based on Microsoft SQL Server data

This exclusive feature represents numeric data from a table or a query result as a diagram with an ability of customizing its appearance in various ways. You can also easily export the diagram to the following formats: BMP, Windows metafile, PDF, JPEG, PNG and more.

The fastest way for building queries MS SQL Maestro allows you to create the SELECT statements visually

The Visual Query Builder is a powerful tool of MS SQL Maestro intended for designing queries as visual diagrams. This tool does not require any knowledge of the SELECT statement syntax, it will form a query automatically, you just need to mark what information do you want to retrieve.

Full customization according to your preferences and needs MS SQL Maestro admits a flexible customization

In MS SQL Maestro you can customize the behavior of all its tools, select a user interface scheme and set a lot of other various preferences.