EMS SQL Manager for SQL Server 3.3

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
   • Server 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
   • Managing jobs, schedules, alerts, operators, endpoints, linked servers, credentials, proxies
   • Duplicating all database objects
   • Viewing dependencies between database objects
4. Advanced data manipulation tools
   • Powerful BLOB viewer/editor with several types of viewing BLOB data
   • Plenty of useful tools such as data grouping, summarizing, fast searching and filtering
   • Master-detail view to work with two linked tables at the same time
   • Table and card views to see data the way you like
   • Support of queries returning multiple result sets
   • Ability to copy and paste selected records
   • Advanced printing system
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
   • Visual query builder allowing you to build complicated queries without any knowledge of SQL syntax
   • 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
   • SQL Formatter (Available from SQL Editor context menu)
   • Favorite Queries (Save and use your frequently used queries easily)
7. Impressive data export and import capabilities
   • Exporting data to most popular formats: MS Excel, MS Word, MS Access, HTML, PDF, TXT, CSV, DBF, XML, ODF etc.
   • Importing data from MS Excel, MS Access, DBF, XML, ODF, TXT and CSV
   • Bulk Insert wizard
   • Exporting data to SQL script as INSERT statement with selecting destination DBMS
8. Visual Database Designer to handle database structure in a few clicks
   • Creating diagram of existing database using Reverse engineering tool
   • Dividing diagram into different subject areas located on separate pages
   • Navigating through diagram using preview navigation to
   • Creating/editing/dropping tables and table fields, visually setting links between them
   • Ability to add comments to diagram
   • Saving as image or printing database diagram
   • Two diagram notations (IDEF1x and IE)
   • A lot of visual customization options
9. Easy-to-use wizards performing SQL Server administrative tasks
   • Backing up database
   • Restoring database
   • Attaching database
   • Detaching database
   • Shrinking database
   • Managing indices
   • Updating statistics
   • Checking database
10. Powerful tools to make your work with SQL Server as easy as it can be
    • Extracting metadata into text files or SQL script editor
    • Powerful print metadata module for creating customizable metadata reports
    • HTML report generator to create a detailed HTML report about your database quickly
    • Managing backup devices
    • Managing database snapshots
    • Viewing SQL Server logs
    • Monitoring SQL Server activity
11. Report designer with clear in use report construction wizard
    • Create Report Wizard allows you to create simple reports in a few clicks
    • Managing reports the same way as if they were database objects: accessing reports directly through DB Explorer tree
12. 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
13. And other useful features
    • Keyboard templates
    • To-do list
    • External tool manager

Enhancements:

1. The following SQL Server 2008 features are now supported:
   • Compressed Tables and Indexes.
   • Field and file group filestream.
   • Filtered indexes.
   • Sparse Columns.
2. Query Builder.
   • When a table is added into a query, its foreign key connections to other tables participating in this query are reflected by JOIN statements.
   • In some cases renaming a table and moving to the SQL tab resulted in the “Cannot bind JOIN expression” error. Fixed now.
3. DB Explorer.
   • The possibility to reorder hosts using drag-and-drop is implemented.
   • The User role and Application role objects now have different icons.
   • Pressing the Edit Object button or selecting the corresponding context menu item with multiple server object selection resulted in opening a single editor. Fixed now.
   • The warning that the database compatibility level is not maximized can be disabled now.
   • SQL Assistant. The Edit objects command didn’t work with server objects. Fixed now.
4. Database Registration Info. The “Schema-organized database tree” option is added; disabling this option makes SQL Manager create the object tree without schema division.
5. Database Properties. The information about the database owner is now available.
6. The ability to edit the result of a query containing JOIN statements is implemented.
7.  The seed and increment parameters of the IDENTITY field can now be negative.
8. Restore Database wizard. It is now possible to disconnect all users from the existing database when restoring it.
9. HTML Report. The possibility to change font size for the DDL section is added.
10.  Changing metadata window can now be closed by pressing the ESC button.
11. The Access Violation error appeared sometimes when deleting User-defined data type. Fixed now
12. Queue Editor. If the Rollback operation was made in the Changing metadata window while editing a queue, all changes made in the Queue Editor disappeared. Fixed now.
13. Database object comments containing national symbols were displayed improperly if their collation differed from the client machine default language. Fixed now.
14.  Extract Database. Bugs concerning wrong statements order and incomplete object definition, and a number of others are fixed now.
15. Code Completion window. Some system functions used to be duplicated in the list. Fixed now.
16.  Code Parameters. The list of parameters didn’t appear if the object name was put into square brackets. Fixed now.
17. Visual Database Designer. Some printers couldn’t print field and table icons. Fixed now.
18.  Table Editor. The Property tab couldn’t be refreshed. Fixed now.
19. An attempt to connect to SQL Server 2005 database with compatibility level 8 led to an error; contacts and routes were not refreshed in that case. Fixed now.
20.  If different languages that use different decimal separators were set at the first and the last tabs of Regional and Language options dialog (Start/Control panel), an error occurred when viewing tables with numeric data. Fixed now.
21. Data Grid. An error occurred when editing data of the date format with month as text (e.g. dd-MMM-yyyy). Fixed now.
22. Wrong shortcuts were displayed for a number of commands from the Quick Code context menu. Fixed now.
23. Other small improvement and bugfixes.

 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