EMS logo

Products Navigation

SQL Manager for IB/FB

Our Partnership Status

Microsoft Certified Partner
Oracle Certified Partner
Embarcadero Technology Partner

EMS SQL Manager for InterBase/Firebird

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 InterBase/Firebird.

 

 

Work with Databases

Connect to a database

Create a database

Edit database connection parameters

Backup a database

Restore a database from a backup

Make work with a database faster

Create a database copy

Document a database

Save metadata reports to file

Log database changes

Design a visual database structure

View an ER diagram

Get an SQL dump

 

Work with Database Objects

Group objects

Find objects

View dependecies

Get an object DDL

 

Work with Data

Export/import data

Export data as SQL Script

Set data filter

View tables with many records

Export filtered data

Edit data of master-detail tables

Sort and group data

Create an autoincrement field

Add image to table

Set data display format

 

Work with Queries and Scripts

Export query results into file

Work with several queries at once

Save most frequently used queries

Execute queries with parameters

Create SQL statements rapidly

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

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

Services

Security management

Personalization

External Tools

Plugins