MS SQL Maestro FAQ
You are welcome to look through the following Frequently Asked Questions list for getting to know the answers to the most commonly asked questions about MS SQL Maestro.
If you want to ask a question which is not in the list you may apply to our support team.
What is MS SQL Maestro?
MS SQL Maestro is a powerful Windows database management solution for MS SQL Server administration and development. The software provides you with graphical user interface (GUI) which allows you to make database operations easy and fast.
With MS SQL Maestro you can easily create, edit and drop database objects, build queries as visual diagrams, execute queries and SQL scripts, manage data including BLOBs, manage MS SQL Server security features, and use a lot of other tools designed for the easiest and most efficient work with MS SQL Server server.
Is it possible to try MS SQL Maestro before buying?
I want to use your software for educational purposes. Can I get a discount?
Yes, you can. Feel free to choose a non-commercial license. Exact prices can be obtained on the purchase page
We intend to buy several products. Is it possible to obtain a discount?
Volume discounts are available for 3 and more licenses. Also you can get a significant discount purchasing a bundle.
I would like to resell MS SQL Maestro on my website. What are your reseller's discounts?
Which license type can I select?
You may choose a non-commercial license if you use the software for non-commercial purposes in non-business, non-commercial environment. You should purchase a business license to use the software in a corporate, government, or business environment.
Single license means that a copy of the software is allowed to be used only on a single computer and only by a single user at a time. If you wish to use the software for more than one user, you will need a separate license for each individual user (click the "Order now" button to see volume discounts). Site license means that the software is allowed to be used without limitation on count of installations and users within one organization.
All our products and bundles are shipped with 12 months of free upgrades (minor and major ones) or with 36 months of free upgrades for a quite small additional fee.
Can I deploy one license for both desktop and laptop?
One MS SQL Maestro license can be installed on a single computer. However, we offer a special allowance which authorizes you to deploy MS SQL Maestro on both desktop computer and portable computer, laptop, or other mobile computer with a single license, as long as it is not being used simultaneously.
What are system requirements for installing your software?
- Pentium PC or higher;
- Windows NT4/2000/XP/Vista/Windows 7/Windows 8;
- 256 MB RAM (512 MB recommended);
- 15 MB of free hard disk space;
- SVGA-compatible video adapter.
How can I find out the date of my current product version release?
Is it possible to install the software in "silent" mode (without user interaction)?
Yes, it is possible. Run installation_package.exe with /SILENT or /VERYSILENT command line parameter. When /SILENT is used the wizard and the background window are not displayed but the installation progress window is. When /VERYSILENT is used this installation progress window is not displayed at all.
Which MS SQL server versions are supported by your software?
MS SQL Maestro can be used with all Microsoft SQL server versions up to 2014.
Does MS SQL Maestro support XML data type for storing documents in Microsoft SQL Server 2005 table columns?
Yes, it does. MS SQL Maestro supports nearly all features implemented in the latest versions of Microsoft SQL Server.
Does MS SQL Maestro support Microsoft SQL Server 2005 user-defined types?
Yes. Most of objects implemented in Microsoft SQL server latest versions are supported by MS SQL Maestro.
I am currently using Microsoft SQL Express Server. Does your software suit me?
Yes, it does. MS SQL Maestro supports the latest version of the Microsoft SQL Server - Microsoft SQL Server 2005 and its Express, Enterprise and Standard Editions.
Do you provide Microsoft SQL Server 2000 encryption opportunities?
Yes, we do. MS SQL Server allows you to create and edit certificates, asymmetric keys and symmetric keys.
When I start a created job nothing happens.
Jobs are used by SQL Server Agent to perform automated activities in SQL Server. Before starting a job make sure that the SQLSERVERAGENT service is currently running on the server.
I have no schema node in the explorer tree at the left. How can I find it?
Check the version of the server you connecting to. Schemas were implemented in Microsoft SQL Server 2005.
Some of our server logins are based on certificates. Can our users connect to this server using your software?
Yes, they can. MS SQL Maestro supports the encrypted connections to the Microsoft SQL Server.
Does MS SQL Maestro provide any automation of administrative tasks for Microsoft SQL Server?
MS SQL Maestro provides scheduled jobs and alerts to automate server administrative tasks. The job object exposes the attributes of a single SQL Server Agent job. Using SQL Server Agent jobs, you can automate administrative tasks and run them on a recurring basis. You can run a job manually or schedule it to run in response to schedules and alerts.
Administrative jobs scheduling means defining a condition(s) that causes the job to begin running. Using these server objects you can schedule any type of job. More than one job can use the same job schedule. A user can attach and detach schedules from jobs. The object is available in Microsoft SQL server 2005 or higher.
The Alert object represents a single SQL Server Agent alert. Alerts respond to either specific Microsoft SQL Server error messages or SQL Server errors of a specified severity. By default, only members of the sysadmin fixed server role can create alerts.
Are there any graphical tools for building and executing queries implemented?
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, etc.
What is the function of Generate Database Report? Does the report include data?
Generate Database Report Wizard allows you to print definitions of the database objects. To run the wizard, select the Tools | Generate Database Report main menu item. The wizard helps you to print all the database object or specify the Categories for printing according to the selected object type. The report does not include database data.
Is code completion implemented in the SQL Editor?
The Editor area is provided for working with the text of the query. For your convenience code completion is enabled. You can activate the completion list by pressing the Ctrl+Space key combination.
I cannot edit the SQL definition using the SQL tab? Why?
The reason is that you are trying to edit SQL definition within the SQL tab of the object editor. Bear in mind that this text is read-only. If you want to modify the object definition, use SQL Editor or SQL Script Editor. You can find the detailed information in the Manual
What is the difference between Object Manager and Object Browser?
Both Object Manager
and Object Browser
are tools for operating on database objects designed as extensions of the Database Explorer. MS SQL Maestro provides such operations as multiple selecting of objects (for copying, dropping, etc.) and the ability of using drag-and-drop operations between Object Manager, Object Browser and Database Explorer as well as between instances of the Object Manager or Object Browser. Unlike Object Manager Object Browser represents objects as a grid with according possibilities (sorting, grouping, and filtering).
Is it possible to execute more than one query using SQL Editor?
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 features remain available and there is no need to wait for your complex query to be completed.