Folie 1

1
(No Transcript)
2
the only tools youll ever need!

• IBExpert is the leading GUI tool for Firebird and
  InterBase databases.
• Produced by IBExpert KG, headed by Holger Klemt,
  who has more than 18 years experience in database
  design and development.
• The following provides a brief overview of the
  many features and options offered by IBExpert.
  See how fast you can develop and administrate
  your Firebird/InterBase database with the aid of
  IBExpert.

3

• Database registration

Register your database for IBExpert use and
select a wide range of settings, options and
defaults, specific to this particular database.
4
with many options including log files, backup
restore files, default paths, filters, scripts,
transactions, and so on.
Test your connection and youre then ready to
start working with IBExpert.
5

• A database connection is made by simply
  double-clicking on the registered database name
  in the IBExpert DB Explorer, the main database
  navigator.
• Your databases and their objects are all clearly
  displayed here in a tree structure.

You can sort your database objects into
projects, and view database and object details in
the SQL Assistant below it.
SQL Assistant
6

• All database objects can be created, altered and
  deleted in the IBExpert Object Editors

7
IBExpert Editor features

• multiple pages
• customized toolbars for each editor and page
• right-click context-sensitive menus throughout
• customizable short cuts

8

• For queries and hand-coding, use IBExperts SQL
  Editor

9

• print results

• compare queries

• analyze performance

10

• Visual Query Builder

Construct your queries by point click view
relationships and see, for example, how joins are
made ideal for beginners.
11
Stored procedures triggers

• stored procedure trigger editors
• customize templates
• create a procedure from a query
• or directly from the Table Field Editors
• debug
• analyze performance

12

• SP/Triggers/Views Analyzer

Analyze all procedures, triggers and views at the
click of a button and then optimize. Its that
simple with IBExpert!
13

• IBEBlock

IBExperts own script extensions

• A set of DDL, DML and other statements that are
  executed on the server and on the client side,
  including some specific constructions applicable
  only in IBExpert or IBEScript, independent of the
  database server version.
• The syntax of IBEBlock is similar to that of
  stored procedures but there are many important
  extensions.

14

• With EXECUTE IBEBLOCK you will be able to

• work with different connections within a single
  IBEBLOCK at the same time
• move (copy) data from one database to another
• join tables from different databases
• compare data from different databases and
  synchronize them
• populate a table with test data using random
  values or values from other tables or even from
  other databases
• access external databases via ODBC drivers
• transaction control across multiple databases
• integration of many IBExpert functions in batch
  files
• dispatch and receive e-mails
• ... and much more

15
Database Designer

• create a new database visually
• manipulate an existing database
• or reverse engineer your database to create a
  model

16

• generate a script from your model

• manage subject areas

• model options for all objects

17
IBExpert ODBC Viewer

• Browse data from any ODBC source available on
  your PC and export data from an ODBC source
  into an SQL script or directly into a
  Firebird/InterBase database.

18

• search, extract and print your database metadata

• compare database table data

19

• Data Analysis / OLAP

• IBExpert's integrated OLAP and data warehouse
  component quickly and easily analyzes data in
  the database.
• Use to build cubes, manage dimensions and
  measures.

Test data generator

• Generate test data specifically for your own
  database

20

• Reporting documenting

21

• Environment options

customize your working environment
22
IBExpert Developer Studio isnt just the IDE
youve seen here. It also includes

• IBExpert Server Tools automate your routine
  administration tasks
• IBExpertWebForms create database-based web
  applications without any html knowledge
• IBExpertDemoDB ideal for benchmark testing
• IBExpertLive over 200 hours of lectures and
  tutorials

23

• IBExpert Server Tools
• Automate your routine administration tasks using
  the HK-Software services control center.

• IBExpertBackupRestore

• IBExpertJobScheduler

• IBExpertInstanceManager

• IBExpertTransactionMonitor

• as well as IBEScript.exe und IBEScript.dll

24

• IBExpertWebForms

• Create database-based web applications without
  any html knowledge.

25

• IBExpertDemoDB

• ideal for benchmark testing
• specify the number of data sets to be generated,
  and it generates the same random data sets every
  time

26

• IBExpertLive

• IBExpertLive is a streaming system based on the
  Firebird server, allowing you to view our
  comprehensive collection of Firebird
  presentations and tutorials.

27

• And all our products are supported by
• Comprehensive online documentationwww.ibexpert.co
  m/doc
• Support forumswww.firebirdexperts.com
• Newsgroupsnews//ibexpert.info/interbase.ibexpert
  .en

28
(No Transcript)
29

• Still not convinced?
• Then download the IBExpert Trial Version, a
  fully-functional 45-day IBExpert version, today
  from
• www.ibexpert.com/download

30
the only tools youll ever need!

• Further information Purchase
• www.ibexpert.com www.ibexpert.com/shopinfo_at_ibexpe
  rt.com