EMS SQL Manager 2008 Lite for SQL Server 3.4.0.7

SQL Manager 2005 works with any SQL Server versions from 7 to 2005 and supports all of the latest SQL Server features including new SQL Server 2005 permission system, assemblies, DDL triggers, XML columns, and so on.

EMS SQL Manager for SQL Server is a program for SQL Server administration and development. EMS SQL Manager for SQL Server offers plenty of powerful tools for experienced users such as Visual Database Designer and Visual Query Builder to satisfy all their needs. SQL Manager 2005 has a new state-of-the-art graphical user interface with well-described wizard system, so clear in use that even a newbie will not be confused with it.

Major Features:

1. Support of SQL Server 2008
   • Support of new data types: date, datetime2, datetimeoffset, time, hierarchyid, geometry, geography
   • Support of table types
   • Support of logon triggers
   • Supports of new backup parameters: compression, buffer count, max transfer size
   • Support of Unicode data
2. Rapid database management and navigation
   • Multiple host/database connections
   • Database properties management
   • Registering databases for working with the required databases only
   • Projects to work with the selected database objects only
   • Multiple user-defined tabs for any tree node to access it in one-click.
   • Working with multiple selected objects at a time
   • Grouping/ungrouping registered databases by host name
3. Easy management of all SQL Server objects
   • Creating/dropping databases and schemas
   • Managing tables and all their subobjects: fields, indices, triggers, checks and foreign keys
   • Managing views, procedures and user-defined functions
   • Managing user-defined types, synonyms, DDL triggers, assemblies, aggregates, XML schema collections, defaults and rules
   • Managing partition functions and schemes, full-text catalogs and indices, symmetric and asymmetric keys, certificates
   • Duplicating all database objects
   • Viewing dependencies between database objects
4. Advanced data manipulation tools
   
   • Plenty of useful tools such as data grouping, summarizing, fast searching and filtering
5. Effective security management
   • Powerful login manager for administering server logins
   • Managing database users and user-defined roles
   • Managing server roles membership
   • Grant manager displaying all database object grants in the form of a grid
   • Viewing and changing object permissions to database roles in object editors
6. Excellent visual and text tools for query building
   
   • Multiple SQL editors with code completion, syntax highlight and code folding
   • Large script executing (SQL script editor)
   • Ability to view actual and estimated query plan as diagram
7. Easy-to-use wizards performing SQL Server administrative tasks
   • Backing up database
   • Restoring database
   • Attaching database
   • Detaching database
8. Powerful tools to make your work with SQL Server as easy as it can be
   • Extracting metadata into text files or SQL script editor
   • Managing backup devices
9. New state-of-the-art graphical user interface
   • Office 11 and Windows XP visual schemes support
   • Well-described Wizard System
   • Improved database explorer for easy management of all SQL Server objects
   • MDI and floating-window styles implementation
   • Windows Toolbar to switch between windows easily, like in Windows Task Bar
   • Navigation bars with hot actions in most of the windows
   • Ability to save all program settings
   • Customizable toolbars for all program windows
   • Fully customizable program interface
   • Powerful visual options module
   • Localizable program interface
10. And other useful features
    • Keyboard templates
    • To-do list
    • External tool manager.

• SQL Server 2008 features are now supported
• The possibility to reorder hosts using drag-and-drop is implemented
• The ability to edit the result of a query containing JOIN statements is implemented and much more.

Requirements:

• 300-megahertz (MHz) or higher Pentium II-compatible processor; 600-MHz or faster processor recommended
• Microsoft Windows NT4 with SP4 or later, Microsoft Windows 2000, Microsoft Windows 2000 Server, Microsoft Windows XP, Microsoft Windows 2003 Server, Microsoft Windows Vista
• 64 MB RAM or more; 128 MB or more recommended
• 50MB of available HD space for program installation
• Super VGA (800x600) or higher-resolution video adapter and monitor; Super VGA (1024x768) or higher-resolution recommended
• Microsoft Mouse or compatible pointing device
• Microsoft Data Access Components (MDAC) or SQL Server Native Client
• Local or remote SQL Server 7, SQL Server 2000, MSDE, SQL Server 2005.
• Supported MS SQL Server versions: from 7.0 up to 2008.