EMS SQL Manager for SQL Server

Powerful graphical tool for SQL Server administration and development EMS SQL Manager for SQL Server is a powerful graphical tool for SQL Server administration and development. 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.

Here are some key features of "EMS SQL Manager for SQL Server":
Full support of SQL Server 2005

Full support of SQL Server 2005 permission system

Assemblies, DDL Triggers, Aggregates and Synonyms support

XML indexes, included index columns, index creation and lock options

Maximum size for varchar, nvarchar, varbinary fields

Typed XML columns

New state-of-the-art graphical user interface

MDI and floating-window styles implementation

Handy database explorer for managing all SQL Server objects

Customizable toolbars for all program windows

Fully customizable program interface

Powerful visual options module

Saving all program settings

Localizable program interface

Rapid database management and navigation

Multiple host/database connections

Database and server properties management

Registering databases for working with the required databases only

Project mode to work with the needed 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

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 assemblies, DDL triggers, aggregates, synonyms, defaults, rules and user-defined types

Duplicating all database objects

Viewing dependencies between database objects

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

Ability to copy and paste selected records

Advanced printing system

Exporting data to SQL script as INSERT statement

Effective security management

Powerful login manager for administering server logins

Managing database users and user-defined roles

Grant manager displaying all database object grants in the form of a grid

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 and syntax highlight

Large script executing (SQL script editor)

Ability to view query plan as diagram

SQL Formatter (Available from SQL Editor context menu)

Report designer with clear in use report construction wizard

New 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

Impressive data export and import capabilities

Exporting data to most popular formats: MS Excel, MS Word, HTML, PDF, TXT, CSV, DBF, XML, etc.

Exporting data to MS Access

Importing data from MS Excel, DBF, TXT and CSV

Importing data from MS Access

Bulk Insert wizard

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 tool

Creating/editing/dropping tables and table fields, visually setting links between them

Saving as image or printing database diagram

Two diagram notations (IDEF1x and IE)

A lot of visual customization options

Easy-to-use wizards performing SQL Server administrative tasks

Attaching database

Detaching database

Backing up database

Restoring database

Managing backup devices

Managing jobs, alerts and operators

Other useful 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

SQL Monitor

And other useful features

Keyboard templates

To-do list

External tool manager


Requirements:

300-megahertz (MHz) or higher Pentium II-compatible processor; 600-MHz or faster processor recommended

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

Possibility to connect to any local or remote SQL Server


Limitations:

30-day trial