Database

EMS SQL Manager for SQL Server v5.1.0

Create new database objects with advanced options just in a few clicks. Open or edit any object directly from the database explorer, create favorites groups, search for object names and customize DB tree look for easier administrating.

Code completion and formatting...

Description

Create new database objects with advanced options just in a few clicks. Open or edit any object directly from the database explorer, create favorites groups, search for object names and customize DB tree look for easier administrating.

Code completion and formatting in SQL editor

Speed up query writing with code completion and information hints for procedure parameters available in SQL editor. Formatting capabilities and code folding make code navigation easier and more convenient. Interface and code settings can be adjusted to your needs.

Visual building of complex queries

Build complex queries with joins, conditions, and sub-queries in a visual mode without extended knowledge of SQL. Use effortless grouping, filtering, and sorting in the grid without the need to type field and function names.

Data export to popular formats

Export table, view, or query data to any of 20 popular formats: MS Excel, MS Word, MS Access, HTML, PDF, TXT, CSV, DBF, XML, ODF, and more. The easy-to-use wizard helps to set advanced options for output file format and layout.

Data import data in insert, update, or delete mode

Populate tables with data from external files of 10 most popular formats: MS Excel, MS Word, XML, MS Access, PDF, TXT, CSV, etc. Follow the steps of the friendly wizard to process required data, set column correspondence, select insert or update mode, and customize data format. Save time for routine operations with template use.

Advanced data view modes

View data from foreign tables in the same grid, use built-it BLOB editor to load and edit BLOB data, switch between cards, forms, grid view mode, and more. Sorting, filtering, and grouping are available with one click in the grid.

Easy executing of database maintenance tasks

Create backup files, restore databases, maintain indices structure with step-by-step wizards. Use built-in tools to monitor server processes, analyze and optimize databases.

Additional Information