Produkt Navigation
SQL Manager for IB/FB
- Wählen Sie Ihr DB-Tool aus
- SQL Studio
- SQL Studio for MySQL
- SQL Studio for PostgreSQL
- SQL Studio for SQL Server
- SQL Studio for IB/FB
- SQL Studio for Oracle
- MySQL Tools
- SQL Studio for MySQL
- SQL Manager for MySQL
- Data Export for MySQL
- Data Import for MySQL
- Data Pump for MySQL
- Data Generator for MySQL
- Data Comparer for MySQL
- DB Comparer for MySQL
- DB Extract for MySQL
- SQL Query for MySQL
- SQL Server Tools
- SQL Studio for SQL Server
- SQL Angel for SQL Server
- SQL Administrator for SQL Server
- SQL Manager for SQL Server
- Data Export for SQL Server
- Data Import for SQL Server
- Data Pump for SQL Server
- Data Generator for SQL Server
- Data Comparer for SQL Server
- DB Comparer for SQL Server
- DB Extract for SQL Server
- SQL Query for SQL Server
- PostgreSQL Tools
- SQL Studio for PostgreSQL
- SQL Manager for PostgreSQL
- Data Export for PostgreSQL
- Data Import for PostgreSQL
- Data Pump for PostgreSQL
- Data Generator for PostgreSQL
- Data Comparer for PostgreSQL
- DB Comparer for PostgreSQL
- DB Extract for PostgreSQL
- SQL Query for PostgreSQL
- InterBase / Firebird SQL-Tools
- SQL Studio for IB/FB
- SQL Manager for IB/FB
- Data Export for IB/FB
- Data Import for IB/FB
- Data Pump for IB/FB
- Data Generator for IB/FB
- Data Comparer for IB/FB
- DB Comparer for IB/FB
- DB Extract for IB/FB
- SQL Query for IB/FB
- Oracle Tools
- SQL Studio for Oracle
- SQL Manager for Oracle
- Data Export for Oracle
- Data Import for Oracle
- Data Pump for Oracle
- Data Generator for Oracle
- Data Comparer for Oracle
- DB Comparer for Oracle
- DB Extract for Oracle
- SQL Query for Oracle
- DB2 SQL-Tools
- SQL Manager for DB2
- Data Export for DB2
- Data Import for DB2
- Data Pump for DB2
- SQL Query for DB2
- Data Generator for DB2
- DB Extract for DB2
- Tools&Components
- Advanced Data Export VCL
- Advanced Data Export .NET
- Advanced Data Import VCL
- Advanced PDF Generator
- Advanced Query Builder
- Advanced Excel Report
- Advanced Localizer
- Source Rescuer
Unsere Partnerschaften
EMS SQL Manager for InterBase/Firebird
Online Bedienungsanleitung
|
Welcome to SQL Manager for IB/FB! |
|
What's new |
|
|
System requirements |
|
|
Feature Matrix |
|
|
Installation |
|
|
Registration |
|
|
How to register SQL Manager |
|
|
License Agreement |
|
|
Version history |
|
|
EMS SQL Manager FAQ |
|
|
Other EMS Products |
|
|
Getting Started |
|
|
Selecting style and language |
|
|
First time started |
|
|
Using Desktop Panel |
|
|
Database navigation |
|
|
Working with database objects |
|
|
Using context menus |
|
|
Host context menu |
|
|
Database context menu |
|
|
Object context menu |
|
|
Working with windows |
|
|
Database Explorer |
|
|
Managing database registration info |
|
|
Connecting to databases and hosts |
|
|
Operations with database objects |
|
|
Selecting multiple objects |
|
|
Using tabs for database navigation |
|
|
Recently opened objects |
|
|
Managing projects |
|
|
Searching within the tree |
|
|
SQL Assistant |
|
|
Configuring Database Explorer |
|
|
Managing Favorite queries |
|
|
Database Management |
|
|
Register Host wizard |
|
|
Setting connection parameters |
|
|
SSH tunneling parameters |
|
|
Setting specific options |
|
|
Create Database wizard |
|
|
Selecting host |
|
|
Specifying database parameters |
|
|
Defining database files |
|
|
Viewing result SQL statement |
|
|
Register Database wizard |
|
|
Selecting host |
|
|
Database on a registered host |
|
|
Setting connection parameters |
|
|
Database on a new host |
|
|
Setting connection parameters |
|
|
Setting specific options |
|
|
Database Registration Info |
|
|
Connection |
|
|
Common options |
|
|
Display options |
|
|
System objects |
|
|
Grid |
|
|
Data options |
|
|
Transactions |
|
|
Events |
|
|
Default directories |
|
|
Logs |
|
|
Find Option |
|
|
Database Properties |
|
|
General |
|
|
Active users |
|
|
Description |
|
|
Find Option |
|
|
Host Registration Info |
|
|
Connection |
|
|
Common host options |
|
|
SSH tunneling |
|
|
Find Option |
|
|
Database Objects Management |
|
|
New Object |
|
|
Duplicate Object Wizard |
|
|
Selecting the source database |
|
|
Selecting object to duplicate |
|
|
Selecting destination database |
|
|
Specifying object details |
|
|
Viewing the new object's definition |
|
|
Domains |
|
|
Domain Editor |
|
|
Using Navigation bar and Toolbar |
|
|
Creating/editing domain |
|
|
Defining domain check |
|
|
Tables |
|
|
New Table |
|
|
Using Navigation bar and Toolbar |
|
|
Setting table properties |
|
|
Specifying fields |
|
|
Table Editor |
|
|
Using Navigation bar and Toolbar |
|
|
Managing fields |
|
|
Changing fields order |
|
|
Managing constraints |
|
|
Primary keys |
|
|
Foreign keys |
|
|
Checks |
|
|
Unique constraints |
|
|
Managing indices |
|
|
Managing triggers |
|
|
Working with table data |
|
|
Fields |
|
|
Field Editor |
|
|
Setting field name and type |
|
|
Options for domain-based field |
|
|
Options for field of standard data type |
|
|
Defining array |
|
|
Specifying 'COMPUTED BY' expression |
|
|
Setting field defaults |
|
|
Defining autoincrement |
|
|
Defining generator |
|
|
Defining trigger |
|
|
Defining procedure |
|
|
Setting field check |
|
|
Table Constraints |
|
|
Constraints Editor |
|
|
Creating/editing primary key |
|
|
Creating/editing foreign key |
|
|
Creating/editing check |
|
|
Creating/editing unique key |
|
|
Indexes |
|
|
Index Editor |
|
|
Specifying index properties |
|
|
Selecting index fields |
|
|
Triggers |
|
|
Trigger Editor |
|
|
Creating table-based objects |
|
|
View from Table |
|
|
Options |
|
|
View info |
|
|
View triggers |
|
|
Procedures from Table |
|
|
Options |
|
|
SELECT procedure |
|
|
INSERT procedure |
|
|
UPDATE procedure |
|
|
DELETE procedure |
|
|
Views |
|
|
View Editor |
|
|
Using Navigation bar and Toolbar |
|
|
Creating/editing view |
|
|
Managing fields |
|
|
Managing triggers |
|
|
View plan |
|
|
Working with data |
|
|
Procedures |
|
|
Procedure Editor |
|
|
Using Navigation bar and Toolbar |
|
|
Creating/editing procedure |
|
|
Managing parameters and variables |
|
|
Input parameters |
|
|
Output parameters |
|
|
Variables/Cursors |
|
|
Specifying input parameters |
|
|
Executing procedure |
|
|
Working with data |
|
|
Procedure/Trigger Debugger |
|
|
Using Navigation bar and Toolbar |
|
|
Debugging procedure/trigger |
|
|
Browsing debug information |
|
|
UDFs |
|
|
UDF Editor |
|
|
Using Navigation bar and Toolbar |
|
|
Creating/editing UDF |
|
|
Triggers |
|
|
Trigger Editor |
|
|
Using Navigation bar and Toolbar |
|
|
Creating/editing trigger |
|
|
Managing trigger messages |
|
|
Exceptions |
|
|
Exception Editor |
|
|
Using Navigation bar and Toolbar |
|
|
Creating/editing exception |
|
|
Generators |
|
|
Generator Editor |
|
|
Using Navigation bar and Toolbar |
|
|
Creating/editing generator |
|
|
BLOB Filters |
|
|
BLOB Filter Editor |
|
|
Using Navigation bar and Toolbar |
|
|
Creating/editing BLOB Filter |
|
|
Journals |
|
|
Journal Editor |
|
|
Using Navigation bar and Toolbar |
|
|
Creating/viewing journal |
|
|
Journal management |
|
|
Database Triggers |
|
|
Database Trigger Editor |
|
|
Using Navigation bar and Toolbar |
|
|
Creating/editing DB Trigger |
|
|
Query Management Tools |
|
|
SQL Editor |
|
|
Using Navigation bar and Toolbar |
|
|
Working with SQL Editor area |
|
|
Using the context menu |
|
|
Viewing query plan |
|
|
Using object links |
|
|
Executing queries |
|
|
Viewing query logs |
|
|
Favorites editor |
|
|
Merging queries |
|
|
Visual Query Builder |
|
|
Using Navigation bar and Toolbar |
|
|
Working with diagram area |
|
|
Joining two objects |
|
|
Setting criteria |
|
|
Setting output fields |
|
|
Setting grouping criteria |
|
|
Setting sorting parameters |
|
|
Working with the editor area |
|
|
Query execution |
|
|
Viewing query plan |
|
|
Query parameters |
|
|
Input parameters dialog |
|
|
Data Management |
|
|
Data View |
|
|
Using Navigation bar and Toolbars |
|
|
Grid View |
|
|
Customizing columns |
|
|
Grouping data |
|
|
Filtering records |
|
|
Using the context menu |
|
|
Working in multi-level mode |
|
|
Create Grid Level wizard |
|
|
Specifying master level |
|
|
Defining source for detail level |
|
|
Binding master and detail levels |
|
|
Query parameterization |
|
|
Setting additional parameters |
|
|
Working in card view mode |
|
|
Column Summary |
|
|
Copying records |
|
|
Form View |
|
|
Print Data |
|
|
Page Setup |
|
|
Page |
|
|
Margins |
|
|
Header/Footer |
|
|
Scaling |
|
|
Report Formatter |
|
|
View |
|
|
Behaviors |
|
|
Formatting |
|
|
Styles |
|
|
Preview |
|
|
Cards |
|
|
Charts |
|
|
Setting report options |
|
|
Print dialog |
|
|
BLOB View |
|
|
Navigation within BLOB Editor |
|
|
Editing as Hexadecimal |
|
|
Editing as Text |
|
|
Editing as Rich Text |
|
|
Editing as Image |
|
|
Editing as HTML |
|
|
Applying changes |
|
|
Custom Filter |
|
|
Filter Builder dialog |
|
|
Invoking the Filter Builder dialog |
|
|
Adding a new condition |
|
|
Setting filter criteria |
|
|
Setting filter operator |
|
|
Setting filter criteria values |
|
|
Adding a new group |
|
|
Setting group operator |
|
|
Applying filter conditions |
|
|
Import/Export Tools |
|
|
Export Data Wizard |
|
|
Setting destination file name and format |
|
|
Selecting fields for export |
|
|
Adjusting data formats |
|
|
Setting header and footer |
|
|
Setting format-specific options |
|
|
Excel options |
|
|
Data format |
|
|
Fields |
|
|
Options |
|
|
Styles |
|
|
Extensions |
|
|
Hyperlinks |
|
|
Notes |
|
|
Charts |
|
|
Cells |
|
|
Merged Cells |
|
|
Advanced |
|
|
Access options |
|
|
Word / RTF options |
|
|
Base Styles |
|
|
Strip Styles |
|
|
HTML options |
|
|
Preview |
|
|
Basic |
|
|
Multi-file |
|
|
Advanced |
|
|
PDF options |
|
|
TXT options |
|
|
CSV options |
|
|
XML options |
|
|
MS Excel 2007 / ODS options |
|
|
MS Word 2007 / ODT options |
|
|
Setting common export options |
|
|
Exporting data |
|
|
Import Data Wizard |
|
|
Selecting source file name and format |
|
|
Selecting data source |
|
|
Setting fields correspondence |
|
|
Excel |
|
|
Access/DBF/XML Datapacket |
|
|
TXT |
|
|
CSV |
|
|
HTML |
|
|
XML Generic |
|
|
MS Excel/Word 2007, ODF |
|
|
Adjusting data formats |
|
|
Setting advanced field formats |
|
|
Setting import mode |
|
|
Customizing common options |
|
|
Importing data |
|
|
Export as SQL Script |
|
|
Selecting destination DBMS |
|
|
Setting destination file name |
|
|
Setting BLOB options |
|
|
Selecting fields to export |
|
|
Editing table definition |
|
|
Setting export options |
|
|
Exporting as SQL Script |
|
|
Database Tools |
|
|
Common DB Tools |
|
|
Dependency Tree |
|
|
Using Navigation bar and Toolbar |
|
|
Viewing dependency tree |
|
|
Visual Database Designer |
|
|
Using Navigation bar and Toolbars |
|
|
Using Diagram Navigator and DB Objects pane |
|
|
Using context menus |
|
|
Working with diagram objects |
|
|
Adding/removing objects to/from diagram |
|
|
Incremental search |
|
|
Creating objects |
|
|
Creating relations |
|
|
Working with diagram pages |
|
|
Reverse engineering |
|
|
Printing diagram |
|
|
Print Preview |
|
|
Print Setup dialog |
|
|
Saving/loading diagram |
|
|
Setting diagram options |
|
|
SQL Script Editor |
|
|
Using Navigation bar and Toolbar |
|
|
Working with SQL Script editor area |
|
|
Using Script Explorer |
|
|
Script execution |
|
|
Extract Database Wizard |
|
|
Selecting source database |
|
|
Specifying destination file name |
|
|
Setting extraction mode |
|
|
Setting BLOB options |
|
|
Selecting objects for structure extraction |
|
|
Selecting objects for data extraction |
|
|
Customizing script options |
|
|
Start of extraction process |
|
|
Print Metadata |
|
|
Using Navigation bar and Toolbar |
|
|
Selecting objects |
|
|
Printing options |
|
|
HTML Report Wizard |
|
|
Selecting database and directory |
|
|
Selecting object types |
|
|
Specifying CSS |
|
|
Setting additional report options |
|
|
Creating HTML report |
|
|
Reports management |
|
|
Create Report Wizard |
|
|
Specifying database name and report options |
|
|
Selecting report bands |
|
|
Selecting report style |
|
|
Specifying page settings |
|
|
Specifying paper settings |
|
|
Specifying margins |
|
|
Specifying other page settings |
|
|
Report Designer |
|
|
Adding dialog form |
|
|
Adding database and query components |
|
|
Adding report data |
|
|
Saving the report |
|
|
Report Editor |
|
|
Using Navigation bar and Toolbar |
|
|
Viewing Report |
|
|
Report Viewer |
|
|
Using Toolbar and context menu |
|
|
Working with Report Viewer |
|
|
Page settings |
|
|
Exporting report content |
|
|
Sending by E-mail |
|
|
SQL Monitor |
|
|
Using Navigation bar and Toolbar |
|
|
Working with SQL Monitor |
|
|
Search in Metadata |
|
|
Using Navigation bar and Toolbar |
|
|
Setting search conditions |
|
|
Viewing search results |
|
|
Specific DB Tools |
|
|
Grant Manager |
|
|
Using Navigation bar, Toolbar and context menu |
|
|
Managing database-specific privileges |
|
|
Managing column permissions |
|
|
Filtering objects in list |
|
|
Backup Database |
|
|
Selecting database and backup type |
|
|
Backup type-specific options |
|
|
Full Backup options |
|
|
Archive Backup options |
|
|
Incremental Backup options |
|
|
Setting backup options |
|
|
Running backup |
|
|
Restore Database |
|
|
Selecting restore type |
|
|
Restore type-specific options |
|
|
Restore from Full Backup |
|
|
Restore from Incremental Backup |
|
|
Restore from Journal Archive |
|
|
Restore Online Dump |
|
|
Setting restore options |
|
|
Running restore |
|
|
Database Validation |
|
|
Selecting database and execution mode |
|
|
Setting validation options |
|
|
Running database validation |
|
|
Database Statistics |
|
|
Selecting database and execution mode |
|
|
Setting statistics options |
|
|
Running statistics collection |
|
|
Start/Stop Database |
|
|
Selecting database and execution mode |
|
|
Setting shutdown options |
|
|
Running Bring Online / Shutdown Database |
|
|
Rebuild Indices |
|
|
Selecting database and execution mode |
|
|
Selecting action for indexes |
|
|
Selecting indexes |
|
|
Recomputing/rebuilding indexes |
|
|
Database Monitor |
|
|
Using Navigation bar and Toolbar |
|
|
Database overview |
|
|
Viewing transactions |
|
|
Viewing statements |
|
|
Viewing users |
|
|
Viewing call stack |
|
|
Viewing procedures |
|
|
Viewing relations |
|
|
Viewing triggers |
|
|
Memory usage |
|
|
Table Altering Monitor |
|
|
Using Navigation bar and Toolbar |
|
|
Working with Table Altering Monitor |
|
|
Server Tools |
|
|
Security management |
|
|
User Manager |
|
|
Using Navigation bar and Toolbar |
|
|
Managing users |
|
|
User Editor |
|
|
Role Manager |
|
|
Using Navigation bar and Toolbar |
|
|
Managing roles |
|
|
Defining role members |
|
|
Embedded User Editor |
|
|
Server Messages Editor |
|
|
Using Navigation bar and Toolbar |
|
|
Working with server messages |
|
|
Go to Message Number dialog |
|
|
Editing Server Messages |
|
|
Event Monitor |
|
|
Using Navigation bar and toolbar |
|
|
Working with Event Monitor |
|
|
Personalization |
|
|
SQL Manager Options |
|
|
Environment Options |
|
|
Preferences |
|
|
Full mode activation |
|
|
Confirmations |
|
|
Windows |
|
|
Tools |
|
|
DB Explorer |
|
|
SQL Assistant |
|
|
Object Editors |
|
|
Table Editor |
|
|
Visual Mode Editors |
|
|
SQL Editor |
|
|
SQL Monitor |
|
|
SQL Script |
|
|
Query Builder |
|
|
Style & Color Palette |
|
|
Visual Database Designer |
|
|
Color Palette |
|
|
Extract Database |
|
|
Print Metadata |
|
|
Database Monitor |
|
|
Dependencies |
|
|
Data Export |
|
|
Fonts |
|
|
Grid |
|
|
Data Options |
|
|
Print Data |
|
|
Color & Formats |
|
|
Advanced |
|
|
Column Options |
|
|
Localization |
|
|
Find Option |
|
|
Editor Options |
|
|
General |
|
|
Display |
|
|
Highlight |
|
|
Quick Code |
|
|
SQL Formatter |
|
|
SQL Words |
|
|
Key Mapping |
|
|
Spell Checking |
|
|
Find Option |
|
|
Visual Options |
|
|
Bars and menus |
|
|
Trees and lists |
|
|
Edit controls |
|
|
Check boxes |
|
|
Buttons |
|
|
Page controls |
|
|
Group boxes |
|
|
Splitters |
|
|
Navigation bar |
|
|
Find Option |
|
|
Save Settings |
|
|
Specifying destination file |
|
|
Selecting settings |
|
|
Selecting databases |
|
|
Saving settings |
|
|
Localization |
|
|
Localization Editor |
|
|
Select Program Language |
|
|
Keyboard Templates |
|
|
Object Templates |
|
|
Find Option dialog |
|
|
External Tools and Plugins |
|
|
External tools |
|
|
External Tools dialog |
|
|
External Tool Info editor |
|
|
Plugins |
|
|
Installed plugins |
|
|
Plugin options |
|
|
Data Generator plugin |
|
|
How To... |
|
|
Work with Hosts and Databases |
|
|
Register Host |
|
|
Unregister Host |
|
|
Create Database |
|
|
Drop Database |
|
|
Register Database |
|
|
Unregister Database |
|
|
Connect to Host |
|
|
Disconnect from Host |
|
|
Connect to Database |
|
|
Disconnect from Database |
|
|
Edit Database Registration Info |
|
|
Edit Database Properties |
|
|
Edit Host Registration Info |
|
|
Work with Database Objects |
|
|
Create Database Object |
|
|
Edit Database Object |
|
|
Drop Database Object |
|
|
Work with Tables |
|
|
Create Table |
|
|
Edit Table |
|
|
Drop Table |
|
|
Manage Table Fields |
|
|
Create Table Field |
|
|
Edit Table Field |
|
|
Drop Table Field |
|
|
Manage Table Indexes |
|
|
Create Index |
|
|
Edit Index |
|
|
Drop Index |
|
|
Manage Table Constraints |
|
|
Create Primary Key |
|
|
Edit Primary Key |
|
|
Drop Primary Key |
|
|
Create Foreign Key |
|
|
Edit Foreign Key |
|
|
Drop Foreign Key |
|
|
Create Check |
|
|
Edit Check |
|
|
Drop Check |
|
|
Create Unique Key |
|
|
Edit Unique Key |
|
|
Drop Unique Key |
|
|
Manage Table Triggers |
|
|
Create Trigger |
|
|
Edit trigger |
|
|
Drop trigger |
|
|
Work with Views |
|
|
Create View |
|
|
Edit View |
|
|
Drop View |
|
|
Work with Stored Procedures |
|
|
Create Procedure |
|
|
Edit Procedure |
|
|
Execute Procedure |
|
|
Debug Procedure |
|
|
Drop Procedure |
|
|
Work with User-Defined Functions |
|
|
Create UDF |
|
|
Edit UDF |
|
|
Drop UDF |
|
|
Work with Triggers |
|
|
Create Trigger |
|
|
Edit Trigger |
|
|
Drop Trigger |
|
|
Work with Exceptions |
|
|
Create Exception |
|
|
Edit Exception |
|
|
Drop Exception |
|
|
Work with Generators |
|
|
Create Generator |
|
|
Edit Generator |
|
|
Drop Generator |
|
|
Work with BLOB Filters |
|
|
Create BLOB Filter |
|
|
Edit BLOB Filter |
|
|
Drop BLOB Filter |
|
|
Work with Journals |
|
|
Create Journal |
|
|
View Journal |
|
|
Sweep Journal |
|
|
Drop Journal |
|
|
Work with Database Triggers |
|
|
Create Database Trigger |
|
|
Edit Database Trigger |
|
|
Drop Database Trigger |
|
|
Work with Queries |
|
|
Create Query |
|
|
Open Query |
|
|
Execute Query |
|
|
Save Query |
|
|
Manage Server Security |
|
|
Work with Users |
|
|
Add User |
|
|
Edit User |
|
|
Delete User |
|
|
Work with Roles |
|
|
Add Role |
|
|
Edit Role Members |
|
|
Delete Role |
|
|
Manage Privileges |
|
|
Work with External Tools and Plugins |
|
|
Add External Tool |
|
|
Remove External Tool |
|
|
Add Plugin |
|
|
Remove Plugin |
|
|
Manage Program Localization |
|
|
Change Program Language |
|
|
Edit Localization |
|
|
Create New Localization |
|
|
Appendix |
|
|
Program interface |
|
|
Viewing object DDL structure |
|
|
Editing object description |
|
|
Browsing object dependencies |
|
|
Setting object permissions |
|
|
Viewing object operations |
|
|
Viewing performance analysis |
|
|
Compile window |
|
|
Tip of the Day |
|
|
Find Text dialog |
|
|
Replace Text dialog |
|
|
Format specifiers |
|
|
Language Info Editor |
|
|
Using templates |
|
|
Supported file formats |
|
|
To-Do List |
|
|
Windows List |
|
|
Customize toolbars and menus |
|
|
SSH tunneling options |
|
|
Quick save / Quick load |
|
|
Connection Lost dialog |
|
|
SQL Manager Direct |
|
|
Login Host / Login Database dialogs |
|
|
Overwriting existing output file |
|
|
Script conversion |
|
|
Select Object dialog |
|
|
SQL Manager shortcuts |
© 2011 EMS Database Management Solutions
© 1999-2013 EMS Database Management Solutions, Inc. Alle Rechte vorbehalten.