This is a development and administration tool for the MS SQL Server database.
EMS SQL Manager for SQL Server Freeware is a tool for Microsoft SQL Server database development and administration. The freeware version is a lighter version of the main product, just to give you a taste of the tool`s capabilities. Restriction includes a limit of 5 databases that could be used with the freeware tool. It is compatible with all the SQL Server versions right from the version 7 to the most recent one. Thus it is able to work with all the data types in t5he latest SQL Server version. The data types like datetimeoffset, hierarchyid, geometry, geography, etc. It also works with table types and table-valued parameters, logon triggers, backups with compression and other features. Administrative features ensure you are able to carry out efficient administration of the database. Meanwhile the interface makes it easy, with the wizards, to operate the program.
Easy management of all the SQL data types, rapid database management as well as navigation combined with quick query building features make the tool a nice help in development and administrative activities. Advanced data manipulation tools are available. Implementing effective security management is simple too. The database supports Unicode. There is no restriction about the use of multi-byte Asian languages. The richness of a feature, which is a strong plus point for the tool has become a little bit of cluttering of the interface. The interface looks crammed with controls and menu options. This can easily take some learning time.