EMS SQL Manager is a powerful software for developing and managing Microsoft SQL Server databases. It works with all versions of MS SQL Server and boasts the latest SQL Server features for optimal performance.
The software also includes support for table types and table-valued parameters, logon triggers, backups with compression, and other features. With plenty of powerful SQL tools, EMS SQL Manager for SQL Server is an ideal choice for efficient SQL Server administration. The Visual Database Designer is one such tool that allows users to create SQL Server databases in just a few clicks.
In addition, this software comes equipped with advanced SQL editor with Visual Query Builder that allows users to build complicated SQL Server queries. Furthermore, EMS SQL Manager for SQL Server offers many more useful features, making it an excellent choice for SQL Server administrators.
This software stands out with its state-of-the-art graphical user interface, complete with a well-described wizard system. As a result, even a novice user will not be confused with its easy-to-use interface. Key features include support for Unicode data, rapid database management and navigation, easy management of all SQL Server objects, advanced data manipulation tools, and effective security management.
With EMS SQL Manager for SQL Server, users also have access to impressive data export and import capabilities. Additionally, the software allows users to handle database structure using the Visual Database Designer tool, making it an even more accessible solution.
Other features worth mentioning include easy-to-use wizards performing SQL Server administrative tasks, powerful tools to make working with SQL Server as easy as possible, and a report designer with a clear in-use report construction wizard. EMS SQL Manager for SQL Server comes with a new state-of-the-art graphical user interface that makes it the ideal choice for individuals looking for simple and efficient SQL Server database management.
Version 3.9: The possibility to record object definitions to files for further use with VCS appeared, some other new features and improvements...
Version 3.6:
If a query returns multiple recordsets, the number of records is now displayed for every recordset.
Now it is possible to change the columns width on the Permissions tab of the objects editors.
Other minor improvements and bug-fixes.
Version 3.5: Added the possibility to extract system objects, a lot of different improvements and enhancements...
Version 3.0:
- Added new tools: Server Log Viewer, Activity Monitor, Shrink Database wizard, Check Database wizard, server roles management and others
- Added support for a number of additional SQL Server capabilities
- Support of Unicode
- Background mode most Wizards
- Lots of other improvements and bug-fixes
Version 2.7:
- Extended Database properties.
- DB Explorer: it is now possible to view brief table information in SQL Assistant.
- It is now possible to modify the schema/owner in object editors.
- Incremental search has been added to a number of object lists.
- Lots of other great improvements and bugfixes
Version 2.6:
- Ability to execute selected statements and statements under cursor added.
- The identity field property can now be edited.
- Reorder Fields. Field order can now be changed no matter if the table has other dependent objects.
- Other great improvements and bugfixes.
Version 2.4:
- CPU usage significantly decreased;
- BLOB Editor now supports BINARY and VARBINARY field types;
- Many other improvements and bugfixes...
Version 2.3: Significant improvements in most of the program modules are implemented...
Version 2.2: SQL Formatter is implemented, Query execution plan is now displayed as a graphical diagram, other improvements and bugfixes...
Version 2.1: Partition functions and partition schemes are now supported, added ability to work with linked servers, German localization is implemented...