EMS logo

Products Navigation

SQL Manager for SQL Server

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for SQL Server

On-line Documentation

How To...


The succeeding pages of this chapter are intended to provide you with brief instructions on how to perform this or that operation correctly using SQL Manager for SQL Server.

 

 

Work with Databases

Connect to a database

Create a database

Edit database connection parameters

Make work with a database faster

Design a visual database structure

View an ER diagram

Backup a database

Restore a database from a backup

Create a database copy

Document a database

Save metadata reports to file

Log database changes

Get an SQL dump

Reduce database size

Transfer database from one server to another

 

Work with Database Objects

Group objects

Find objects

View dependecies

Get an object DDL

 

Work with Data

View tables with many records

Set data filter

Sort and group data

Export/import data

Export data as SQL Script

Edit data of master-detail tables

Add image to table

Set data display format

 

Work with Queries and Scripts

Create SQL statements rapidly

Control a query productivity

Work with several queries at once

Save most frequently used queries

Execute queries with parameters

Export query results into file

Execute scripts

Execute a large SQL script

Make SQL script work faster

Customize work with Query/Script text

View executed queries and scripts

 

Create a simple report in Report Designer

Create a scheduled job

Transfer program settings

Update SQL Manager

Report bugs and suggestions

 

 


See also:

Getting Started

Database Explorer

Database Management

Database Objects Management

Query Management Tools

Data Management

Import/Export Tools

Database Tools

Server Tools

Personalization

External Tools