Customers
MS SQL Maestro online Help
| Return to chapter overview | Next  |
Welcome to MS SQL Maestro!
MS SQL Maestro is the premier Windows GUI admin tool for Microsoft SQL management, control and development. It allows you to make all the database operations easy and fast. Using MS SQL Maestro you can create, edit, copy, and drop all the database objects such as tables, views, procedures, UDFs, UDTs, files, etc. and also schemas, synonyms, assemblies and other database objects implemented in version 2005, 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 users, logins, roles, and their privileges, and use a lot of other tools designed for the easiest and most efficient work with Microsoft SQL server.
Basic MS SQL Maestro features
Easy database management
MS SQL Maestro allows you to create and drop databases quickly. Database profiles give you the opportunity to connect to databases in one touch and work with the selected databases only. See the Database Management for details.
Powerful database object management
MS SQL Maestro provides you with an ability to manage database objects (tables, views, procedures, UDFs, UDTs, rules, files, file groups, etc. and also schemas, synonyms, xml schema collections, assemblies and others database objects implemented in version 2005) in various ways. For example, you can perform operations with a group of objects as well as with a single object in Object Manager, sort, group and filter the database objects within Object Browser, copy an object from one database to another by a drag-and-drop operation inside the explorer tree, use Windows clipboard to copy a set of objects and so on. For details turn to the Database Object Management section.
Working with tables and table subobjects
MS SQL Maestro wizards and editors allow you to create, edit and drop tables as well as their fields, indexes, triggers and foreign keys in a couple of simple operations. See the Tables section to learn more.
Building and executing queries
MS SQL Maestro provides two 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. You can find the detailed description in the Queries section.
Support of the latest Microsoft SQL features
Use MS SQL Maestro to work with any Microsoft SQL server version from 7.0 to 2005! Among other features and objects implemented in the latest versions of the server, our software supports schemas, synonyms, xml schema collections, assemblies, credentials, certificates, schedules and much more.
Powerful data management tools
With MS SQL Maestro you can view and edit table data (including BLOB fields), export and import data to/from MS Excel, MS Access, DBF, XML, TXT, CSV and other formats, get SQL data dump and more. See the Data Management to learn the details.
Wide choice of additional tools
MS SQL Maestro provides you with a number of tools for working with database metadata and SQL scripts, including code folding and script explorer. There are such tools are at your disposal as BLOB Viewer, Diagram Viewer, Data Analysis and Database Designer, SQL Generator, and more. To learn more, see the Database Tools section.
Security management
MS SQL Maestro provides you with a comfortable way to manage access privileges on both stages of security. It is possible to include/exclude a login into server roles, and at the same time edit logins list in the server role editor. You can either grant/revoke permissions for a concrete database object such as table or function, or operate with user or role privileges.
Full customization according to your preferences and needs
In MS SQL Maestro you can customize the behavior of all its tools, select a user interface scheme and set a lot of other preferences. All the options and their meanings are listed within the Options dialog description.
| Return to chapter overview | Next |
