If you have any questions please mail us at sales@ibexpert.biz.
Prices are quoted in Euros and net of any statutory VAT/sales tax and any costs for postage and packaging (where applicable).
IBExpertDemoDB
Use the IBExpertDemoDB for benchmark testing. The UDFs and SQLs necessary to generate the demo database can be found in the IBExpert Developer Studio's /IBExpertDemoDB directory. The documentation lists the simple steps needed to generate a demo database to the size of your choice.
The IBExpert Benchmarks article illustrates in detail how to utilize this valuable function as a sample web shop.
In the subdirectory, \IBExpertDemoDB, you will find a script, db1_30.sql, which you an use to create a Firebird 3.0 database. Among other things this includes a Soundex function as a stored procedure, as a stored function and as a package. By these means you can create your own functions in Firebird 3.0 or using your own UDF, and use them in SQL as if they were an internal function.
Furthermore there is a basic implementation for a materialized view alternative in this script, which can also be used with older Firebird versions.
By combining a view with a static table it is possible to avoid calculating complex result sets each and every time, and only recalculate them following expiry of specified time intervals.
Firebird performance issues
How do you measure the performance of your own server or your clients'? Have you ever tried to compare the database speed of your Firebird server with new server hardware? Is a XEON Machine better than an Opteron? What improvements can you expect from fast SAS hard disks, RAID controllers or Enterprise SSDs?
The IBExpert Benchmark is a simple but effective tool, which gives you a reference benchmark, based on our recommended IFS Servers. Using IBExpert Benchmark you can generate and compare a reproducible speed index for your Firebird Server hardware. On average, our IFS servers with Firebird are 5 to 10 times faster than the server or virtual machines that our customers have previously used.
Perform the comparison yourself using our free IBExpert benchmark software on your Firebird server: https://ibexpert.net/benchmark/setup_benchmark.exe
IBExpert Firebird 3 Bootcamp
(German-language version below)
The Firebird 3 Bootcamp is for admins and developers who have been actively working with Firebird for at least 2 years. The focus is on upgrading to Firebird 3 and optimization of your own database environment (also for Firebird 2.x). You can expect interesting talks covering all aspects of Firebird, IBExpert, Lazarus and Delphi development. The focus is on the practical application of the technologies and methods presented, which can also be implemented with other programming languages.
Benefit from the knowledge of the IBExpert database experts.
Overview of topics
Client development
- Debugging a Delphi/Lazarus database application with the integrated debugger
- Create appropriate events for additional protocols without the Debugger
- Server-side monitoring of database applications
- Establishing a 24/7 monitoring protocol on the server
- Network monitoring of database communication at TCP/IP packet level
- Performance comparison of different components: TxxTable, TxxDataset, TxxQuery etc.
- Identify and assess automatically component-generated SQLs
- Identify SQLs on the server based on source code additions in the Delphi/Lazarus source code
- Automatically supplement own profiling methods in the Delphi/Lazarus source code
- Autocommit or manual commit?
- Use Prepare or not?
- SQLs with or without parameters? Advantages and disadvantages!
- Integrate block commands
Server development
- Basic knowledge regarding the Firebird server functionalities and architecture
- Detect inadequate transaction handling and assess impact
- Locate long-running transactions in network operation, identify the cause
- Techniques to end long-running transactions on the server side
- Analyze trigger sequences and log the process
- Measure and evaluate speed benefits of stored procedures
- Create and debug stored procedures and triggers using IBExpert
- Global database analysis: lack of primary keys, detection of duplicates, false and missing indices
- Use calculated fields for maximum performance and manage display using permissions
- Use data types and table definitions properly
- Correct use of execute statement on external
Administrative tasks
- Visualize a database model using IBExpert
- Export a database model for version control in SVN or similar
- Use IBExpert to set up versioning of stored procedures and triggers
- Automate metadata comparison between the development database and the production database
- Automate an automatic data synchronization between multiple databases using scripts
- Data backup using Backup tools during normal operation
- Optimize running time of the data backup
- Shadow as an alternative high-speed backup method
- Basic knowledge of replication as a real-time backup
- Measure hardware speed and compare using IBExpert Benchmark
- Tips and Tricks to optimize hardware and software for a Firebird Server
IBExpert Firebird 3 Bootcamp
Das Firebird 3 Bootcamp wendet sich an Admins und Programmierer, die mindestens 2 Jahre aktiv mit Firebird arbeiten. Dabei konzentrieren wir uns auf den Umstieg auf Firebird 3 und die Optimierung der eigenen Datenbank-Umgebung (auch für Firebird 2.x). Es erwarten Sie interessante Themen rund um die Entwicklung mit Firebird, IBExpert, Lazarus und Delphi. Der Fokus liegt dabei konsequent auf dem praktischen Einsatz der vorgestellten Technologien und Methoden, die auch mit anderen Programmiersprachen umgesetzt werden können.
Profitieren Sie vom Wissen der IBExpert Datenbank Experten.
Themen im Überblick
Client Entwicklung
- Debuggen einer Delphi/Lazarus Datenbankanwendung mit dem integrierten Debugger
- Erstellen geeigneter Events für zusätzliche Protokolle auch ohne Debugger
- Netzwerkmonitoring der Datenbankkommunikation auf TCP/IP Paketebene
- IBExpert Database Monitoring
- Trace API einsetzen und auswerten
- Performancevergleich verschiedener Komponenten: TxxTable, TxxDataset, TxxQuery etc.
- Automatisch von Komponenten erzeugte SQLs erkennen und bewerten
- SQLs auf dem Server anhand von Quelltextergänzungen im Delphi/Lazarus Quellcode identifizieren
- Eigene Profiling Methoden automatisiert im Delphi/Lazarus Quellcode ergänzen
- Autocommit oder manuelles Commit?
- Mit Prepare oder ohne Prepare?
- SQLs mit oder ohne Parameter? Vor- und Nachteile!
- Befehle in Blocks zusammenfassen
- Einfache Webanwendungen erstellen
Server Entwicklung und administrative Aufgaben für Entwickler
- Basiswissen zur Arbeitsweise und Architektur des Firebird Servers
- Mangelhaftes Transaktionshandling erkennen und Auswirkungen bewerten
- Zuordnung langlaufender Transaktionen im Netzwerkbetrieb, Identifikation des Verursachers
- Techniken, um langlaufende Transaktionen serverseitig zu beenden
- Trigger Sequenzen analysieren und Ablauf protokollieren
- Geschwindigkeitsvorteile von Stored Procedures messen und bewerten
- Stored Procedures und Trigger mit IBExpert erstellen und debuggen
- Globale Datenbankanalyse: fehlende Primärschlüssel, doppelte, falsche und fehlende Indizes erkennen
- Berechnete Felder performant einsetzen und Anzeige über Berechtigungen steuern
- Datentypen und Tabellendefinitionen richtig einsetzen
- Execute Statement on External richtig einsetzen
- Basiswissen Replikation als Echtzeitbackup
- Datenbankmodell mit IBExpert visualisieren
- Datenbankmodell für eine Versionskontrolle in SVN o.ä. exportieren
- IBExpert für Versionierung von Stored Procedures und Trigger einrichten
- Automatisierter Metadatenabgleich zwischen Entwicklungsdatenbank und Produktionsdatenbank
- Automatisierter Datenabgleich zwischen mehreren Datenbanken per Script automatisieren
Administrative Aufgaben
- Datensicherung über Backup Werkzeuge im laufenden Betrieb einsetzen
- Laufzeit der Datensicherung optimieren
- Shadow als alternative High Speed Sicherungsmethode
- Hardwaregeschwindigkeit messen und vergleichen mit IBExpert Benchmark
- Serverseitiges Monitoring von Datenbankanwendungen
- Einrichtung eines 24/7 Monitoring Protokolls im Server
- Reports, automatisierter Import und Export csv, pdf etc
- Tipps und Tricks für optimale Hardware und Software für einen Firebird Server
- Was bringt die neue Mehrprozessorfähigkeit in Firebird 3.0 wirklich?
- Einsatzmöglichkeiten für Packages und Internal Functions
- Was muss man bei einer Umstellung auf Firebird 3.0 beachten?
- Benchmark Vergleich Firebird 2.5/Firebird 3.0
- IBExpert Tipps und Tricks für die tägliche Arbeit
- Warum SQL Befehle selber schreiben, wenn diese im IBExpert Assistent schnell und zuverlässig erzeugt werden können
- Softwaremodelle Developer Studio, Company Year Edition und Day Edition
- Firebird.conf optimieren
IBExpert Firebird Bootcamps: Was unsere Kunden sagen
IBExpert Replicator Enterprise IBER
The new IBExpert Replicator Enterprise is now ready!
The new IBER solution will be installed in a remote session by an IBExpert engineer on a Windows or Linux machine (virtual or physical) in your network while your employees are working on the database.
What do you need for this? We recommend installing the IBER on a virtual machine, so that in the event of a unrecoverable failure of your existing production server, making it impossible to use the database on that machine, you or our engineer can activate the replicated database as a new production database by running a single batch file.
The existing replication master server can be any Linux or Windows machine in your local network. We recommend a server, which will execute the IBExpert Benchmark with a least 100% in each category. If faster servers are needed, please consider our IFS Server Hardware.
The replication target server can be any physical or virtual machine also running Windows or Linux.
It should be preinstalled with the same Firebird installation that is already used on your existing master server. If our help is needed and you are not sure how to copy such a configuration, our engineers can evaluate your master server installation and transfer the Firebird server to a second machine following a very brief out time.
The IBER virtual machine can run on a separate machine or also on your replication target server as a virtual machine. If you do not have any preferred VM system, we will deploy the free VirtualBox software.
The IBER basic price includes up to one hour of remote session work for the setup. This requires that we get the above setup already preinstalled and the customer can give us the connection strings/SYSDBA or Owner and password of the Firebird databases used. Also, we expect to have the above-mentioned IBER VM and target server with a similar Firebird server already preinstalled. The basic price covers up to 2 databases to be replicated.
If the customer is unable to carry out these preparations, we can perform additional configuration work based on our IBExpert Hotline package rates. This basically means: If you do not have your own IT manager, who is able to implement and document all above steps for us, and also your software manufacturer does not want to help you on this task, you can be confident that our IBExpert engineers will make it work.
The IBER Product also includes 12-month emergency service in case of unrecoverable errors on our master server up to 4 times per year. If this happens more often, you should consider changing your server hardware. A IBExpert hotline package will still allow you to use our service, also when issues are to be solved that are not connected to the IBER replication. If such an emergency case is reported to us, but we see that a simple server restart solves the problem or the problem has nothing to do with Firebird, we will charge the time on the customer’s hotline account.
At the end of the initial 12-month period, we will charge you for a further 12 months with the IBER Subscription package, if our help and software updates are still required. Without the continued subscription, the software will not cease working, but in case of an emergency, our remote support then requires a prepaid hotline package.
What do you get?
After the basic installation carried out by our engineers remotely, which is typically done using our GoTo Meeting conference system, you will see a number of separate batch files on the IBER virtual machine which will perform the following tasks:
a) Create and init a new replication target for a specific master database
b) Drop any replication technology from a specific master database
c) Execute the replication based on Firebird events
d) Convert a target database to be a 100% replacement for the master database
If your software manufacturer does not want any alterations made in the database or does not directly support our technology, you can always execute script b) whenever the software manufacture applies, for example, his updates on the database, since this script will completely remove any IBER object from the database.
After the updates have been applied, you only need to run the script a) again to recreate any necessary IBER objects and init the new replication target again.
After init has been run, script c) will start and execute all operations (insert/update/deletes) performed in the master database, almost in real time, onto the replicated target database. If script c) cannot connect to master or target database, for example because of a temporary server reboot, it will ignore the errors for a few seconds and, after the reconnection is made, will process all records that were logged while the connection was not possible.
If a backup and restore of the existing database is performed, a new init process using script a) is mandatory. A backup alone does not need such a new init.
The IBER replication can be interrupted at any time, due to a local power cut or whatever other reason. Once the systems are back online, there is no manual work required to reactivate the replication again and no new sync is necessary. Everything that is done on the master database will be immediately replicated to the target database right after the IBER VM and the target server can be reached again.
Important: If your software manufacturer claims that any manipulation of the database structure will result in a loss of warranty, you should request the manufacturer get in touch with us, since we can guarantee that our system has no negative impact on any Firebird 2.5-Firebird 5.0 databases except for a very low level of additional server performance which the IBER system will operate via one additionally connected database user.
Zero maintenance and full real-time replication.
Pricing
IBExpert Replicator Enterprise IBER Starter Package including init and 12 months support 1020 €.
IBExpert products, services & prices
Below you can find a summary of all IBExpert products and services.
Click on the corresponding 
icon, you will automatically be forwarded to PayPro Global, responsible for the global sales of our software products.
IBExpert Developer Studio Edition
IBExpert Developer Studio is the most comprehensive GUI tool for Firebird and InterBase® on the market today. It includes the following components: IBExpert IDE, IBEScript.exe, and IBExpertDemoDB. Read the full software product details here.
| IBExpert Developer Studio Packages | No. of activations |
Subscription for the first 12 months Online price in Euros (EUR) net of sales tax/VAT |
Subscription for the next 12 months Online price in Euros (EUR) net of sales tax/VAT |
Subscription after expiry more than 12 months Online price in Euros (EUR) net of sales tax/VAT |
|
|---|---|---|---|---|---|
| IBExpert Developer Studio Single | 1 | 289.00 | |
137.00 | 215.00 |
| IBExpert Developer Studio multiple 2-4 | 2-4 | 259.00 each | |
119.00 each | 189.00 each |
| IBExpert Developer Studio multiple 5-9 | 5-9 | 219.00 each | |
102.00 each | 159.00 each |
| IBExpert Developer Studio multiple 10-24 | 10-24 | 169.00 each | |
78.00 each | 122.00 each |
| IBExpert Developer Studio multiple 25-49 | 25-49 | 149.00 each | |
67.00 each | 103.00 each |
| IBExpert Developer Studio multiple 50+ | 50+ | 129.00 each | |
62.00 each | 95.00 each |
Prices are quoted in Euros and net of any statutory VAT/sales tax and any costs for postage and packaging (where applicable).
IBExpert Developer Studio Day Edition
The IBExpert Day Edition is the ideal supplement to all IBExpert full versions, ready for use on all computers at any time. Read the full software product details here.
| IBExpert Day Edition Packages | Online price in Euros (EUR) net of sales tax/VAT |
|
|---|---|---|
| Day Edition 25 activations, valid 12 months IBExpert IDE 25 individual activations. |
45.00 | |
| Day Edition 100 activations, valid 12 months IBExpert IDE 100 individual activations. |
160.00 | |
| Day Edition 250 activations, valid 12 months IBExpert IDE 250 individual activations. |
245.00 | |
| Day Edition 500 activations, valid 12 months IBExpert IDE 500 individual activations. |
310.00 | |
| Day Edition 1000 activations, valid 12 months IBExpert IDE 1,000 individual activations. |
520.00 | |
| Day Edition 2500 activations, valid 12 months IBExpert IDE 2,500 individual activations. |
1,150.00 | |
| Day Edition 5000 activations, valid 12 months IBExpert IDE 5,000 individual activations. |
2100.00 | |
Prices are quoted in Euros and net of any statutory VAT/sales tax and any costs for postage and packaging (where applicable).
IBExpert Developer Studio Company Year Edition
Use the IBExpert IDE, IBEScript.dll, IBEScript.exe, and the BackupRestore Scheduler modules on multiple computers, also in virtual environments and/or in the cloud, without hardware-related unlock codes. Read the full software product details here.
In a virtual environment, which does not always run on the same hardware, the use of an IBExpert Company Year, Enterprise Server Year, Distribution OEM is necessary to avoid problems such as machine locks.
| Description | Months | Online price in Euros (EUR) net of sales tax/VAT |
|
|---|---|---|---|
| IBExpert Company Year Edition S The IBExpert Company Year Edition S version is reserved exclusively for single programmers/developers. For further information and purchase please contact sales@ibexpert.biz. IBExpert activations: 10 |
12 | 569.00 | upon request |
| IBExpert Company Year Edition M 1. Total number of all employees: <= 25 2. Number of all employees using IBExpert, such as Developers, Supporters, Administrators: <= 5 3. IBExpert activations: 50 |
12 | 1,095.00 | |
| IBExpert Company Year Edition L 1. Total number of all employees: <= 250 2. Number of all employees using IBExpert, such as Developers, Supporters, Administrators: <= 10 3. IBExpert activations: 100 |
12 | 2,269.00 | |
| IBExpert Company Year Edition XL 1. Total number of all employees: <= 500 2. Number of all employees using IBExpert, such as Developers, Supporters, Administrators: unlimited 3. IBExpert activations: 1000 |
12 | 5,409.00 | |
Prices are quoted in Euros and net of any statutory VAT/sales tax and any costs for postage and packaging (where applicable).
IBExpert Enterprise Server Year Edition
In a virtual environment, which does not always run on the same hardware, the use of an IBExpert Company Year, Enterprise Server Year, Distribution OEM is necessary to avoid problems such as machine locks.
Work with IBExpert software in a virtual environment
The ESYE contains the following components: IBExpert IDE, IBEScript.dll, IBEScript.exe and the BackupRestore Scheduler. ... Read the full software product details here.
| Description | Months | Online price in Euros (EUR) net of sales tax/VAT |
|
|---|---|---|---|
| 1 * IBExpert activation for 1 Server, location-independent | 12 | 669.00 | |
Prices are quoted in Euros and net of any statutory VAT/sales tax and any costs for postage and packaging (where applicable).
IBExpert Server Tools
The IBExpert Server Tools include IBEScript exe and dll, hkSCC.exe, the IBExpert Backup/Restore Scheduler and the IBExpert Encryption Plugin for Firebird 3 on Win32/Win64. The IBExpert Server Tools can also be deployed on virtual machines or in a cloud infrastructure. Read the full software product details here.
| Description | No. of users | Online price (EUR) net of sales tax/VAT |
|
|---|---|---|---|
| IBExpert Server Tools single edition for one activation | 1 | 175.00 | |
| IBExpert Server Tools multiple activations | upon request | ||
Prices are quoted in Euros and net of any statutory VAT/sales tax and any costs for postage and packaging (where applicable).
IBExpert Distribution OEM Edition
Our optimal solution for all businesses for flexible and independent working with IBExpert on all physical or virtual computers without activation codes and without an active internet connection. Read the full software product details here.
| Description | Price in Euros (EUR) net of sales tax/VAT |
|---|---|
| OEM Distribution Edition: IBExpert.exe | 13,050.00 |
| OEM Distribution Edition: IBEScript.exe | 13,050.00 |
| OEM Distribution Edition: IBEScript.dll | 13,050.00 |
Prices are quoted in Euros and net of any statutory VAT/sales tax and any costs for postage and packaging (where applicable).
By ordering you agree to the OEM Distribution Edition terms and conditions.
Please mail sales@ibexpert.biz if you wish to order this software product.
IBExpert Encryption OEM Edition
The IBExpert Encryption Plugin for Firebird enables you to securely encrypt your Firebird 3 and Firebird 4 databases (also embedded). ... continue reading.
| Description | Price in Euros (EUR) net of sales tax/VAT |
|---|---|
| IBExpert Encryption OEM for Firebird 3 and Firebird 4 incl. 12 months subscription | 4,329.00 |
| IBExpert Encryption OEM for Firebird 3 and Firebird 4 (no subscription) | 3,039.00 |
| IBExpert Encryption OEM for Firebird 3 and Firebird 4 optional surcharge for the source code | 6,129.00 |
Prices are quoted in Euros and net of any statutory VAT/sales tax and any costs for postage and packaging (where applicable).
Please mail sales@ibexpert.biz if you wish to order this software product.
IBExpert Replicator Enterprise IBER
Add real-time replication to any Firebird database without any downtime. ... continue reading.
| Description | Price in Euros (EUR) net of sales tax/VAT |
|---|---|
| IBExpert Replicator Enterprise IBER Starter Package including init and 12 months support | 1,020.00 |
| IBExpert Replicator Enterprise IBERSub Subscription Package 12 months support | 610.00 |
Prices are quoted in Euros and net of any statutory VAT/sales tax and any costs for postage and packaging (where applicable).
IBExpertFunctionLibrary
The IBExpertFunctionLibrary is a comprehensive set of functions, suitable for all Firebird versions. ... continue reading.
| Description | Price in Euros (EUR) net of sales tax/VAT |
|
|---|---|---|
| IBExpertFunctionLibrary Enterprise Maintenance Subscription | 1,020.00 | |
Prices are quoted in Euros and net of any statutory VAT/sales tax and any costs for postage and packaging (where applicable).
IBExpert Benchmark Tool - Free special version
Compare your computer performance and test the speed of your Firebird Windows server with the free IBExpert Benchmark Tool. ... continue reading.
| Description | Price in Euros (EUR) net of sales tax/VAT |
|---|---|
| IBExpert Benchmark Tool: Download here | free of charge |
IBExpert Developer Studio Personal Edition
The IBExpert Personal Edition for private users includes the IBExpert IDE. Read the full software product details here.
| Description | No. of users | Price in Euros (EUR) net of sales tax/VAT |
|---|---|---|
| IBExpert Personal Edition | 1 workstation | free of charge |
IBExpert Developer Studio Full Educational Edition
The IBExpert Developer Studio Full Educational Edition is a full IBExpert Developer Studio version. Read the full software product details here.
| Description | No. of users | Online price in Euros (EUR) net of sales tax/VAT |
|---|---|---|
| IBExpert Developer Studio Full Educational Edition incl. 12 month software subscription | 1 workstation | upon request |
Prices are quoted in Euros and net of any statutory VAT/sales tax and any costs for postage and packaging (where applicable).
Furthermore, IBExpert is also available as a free IBExpert Developer Studio Educational Edition.
IBExpert services & support
We offer a wide range of training and support services for Firebird, InterBase®, Lazarus, Delphi®, FastReport® and of course, IBExpert. All support and training services are available worldwide; languages spoken: German and English. View the full details and conditions of these services here.
If you wish to order any of our support services, please mail sales@ibexpert.biz and you will be sent our prepayment invoice.
IBExpert und Firebird hotline includes training and support services for Firebird, InterBase®, Lazarus, Delphi, FastReport and of course, IBExpert. Details
Fees in Euros (EUR):
IBExpert Prepaid Hotline Account 60 minutes 135.00
IBExpert Prepaid Hotline Account 120 minutes 260.00
IBExpert Prepaid Hotline Account 240 minutes 500.00
IBExpert Prepaid Hotline Account 480 minutes 970.00
IBExpert Prepaid Hotline Account 960 minutes 1,880.00
If you are confronted with a damaged or corrupt database we can often offer a rapid solution without even having to come out and analyze the corrupt database on site. Before we can provide you with our database repair estimate, we must first analyse your database. Details
Fees in Euros (EUR):
Database analysis: evaluation fee 150.00
Database analysis express: evaluation fee 300.00
If you are experiencing poor performance with your Firebird application, we can help. We set up a live monitoring on your database server. After approximately 7 days you will receive a detailed written report. Details
Fees in Euros (EUR):
IBExpert Firebird SQL Performance Monitoring 1,200.00
Prices are quoted in Euros and net of any statutory VAT/sales tax and any costs for postage and packaging (where applicable).
IBExpert and Firebird Training and Workshops
Our training sessions using online video transmission combine personal training with physical independence: promptly and flexibly and tailored to your requirements
Perhaps your team is also located at different sites?
All employees can take part in our training courses, even from their home office.
The number of participants does not affect the cost.
The coaching days can be scheduled at relatively short notice and you and your team will not be absent from productive work for too long during the course.
The course can take place in a much shorter period of time. We train in blocks of 2-4 hours at a time.
We tailor all topics individually to your company and the requirements of your team, taking into account the level of knowledge of the participants and also look at tackling current projects.
The training courses can thus be structured in blocks and/or key topics can be scheduled for different employees, and can of course also be adjusted during an ongoing training session.
Our workshops are complemented by video recordings, which we capture during the workshops and make them available to you in digital form.
Workshops are much more effective when you structure them interactively. We offer our courses as interactive workshops and not in a classic lecture format.
You can send your training enquiry to register@ibexpert.biz
We coordinate the agenda, the dates and the technical implementation together with yourselves.
Topics
Upgrading from Firebird 2.5 to 3.0/4.0
Setting up a permanent SQL monitoring on your own database
Applying the Trace API and results for optimization
Setting up and understanding basic master-slave replication
Working with multiple databases and transparent external blob storage
IBExpert is the ideal partner for training and workshops in your company
Years of experience allow you to gain access to tried and tested strategies and techniques for software development. The training sessions take place over a period of 1-5 days, depending upon the participants’ previous knowledge and the depth and range of the topics covered.
We provide expert workshops at your company, tailored to fit your needs. Send us your detailed list of requirements, and we will send you a written offer, recommending the number of days necessary to ensure your team can learn the necessary skills to fulfil your requirements.
Our standard courses:
IBExpert und Firebird Power Workshop
IBExpert Firebird 3 Bootcamp
Bootcamp database web applications using Firebird
Firebird Developer Days
Lazarus training for Delphi programmers
Remote Firebird 4/5 Update Workshop
(German-language version below)
In successful workshops with our customers, we have perfected the solution to all conversion problems to such an extent that we can also implement your requirements quickly and flexibly via online training.
With our experience, we can support you as a user or developer to implement all the necessary steps for a successful upgrade of your Firebird 2.x-based application so that it can also run with Firebird 4 or 5.
We know how to convert your database and create a powerful Firebird 4/5 server configuration with maximum compatibility with your existing application.
Prepare your database for Firebird 4/5 compatibility
Each server-based object, for example stored procedures, triggers, UDFs etc., is automatically verified and you will receive useful tips on how to prepare your existing Firebird 2.x metadata for later conversion in the production system.
You will also receive an introduction to a new Firebird setup and learn how to install a secondary, newer parallel Firebird server version on your or your customers' database server while the existing installation is still in production.
Even rolling out an automated update to hundreds or thousands of customer installations is possible without any manual installation using our IBExpert OEM technology.
We know what can happen and our setup offers all your customers an automated upgrade. If everything has worked well, they can start working with the new Firebird database server instance.
However, if something unexpected happens, you will receive a detailed log, but the existing setup will still be available.
This allows you to decide whether a manual setup is required or whether the automated update process needs to be improved.
Test your application for Firebird 4/5 compatibility
The basic workshop lasts approx. 2 days and includes an analysis of the existing system as well as a backup/restore of all required data on the new Firebird server.
To avoid wasting time waiting for the backup/restore, we usually offer our workshops in a 4x4 hour format.
You will be surprised how quickly we can get your application up and running with the new Firebird 4/5 database as the backend.
Our setup utilises several available compatibility configuration parameters, so that you can continue to enjoy all the benefits of the new Firebird versions and achieve significantly better performance, especially under high load, in multi-user installations.
Further support
Once the conversion is complete, we can also offer customised support to create an IBExpert OEM-based upgrade module, which you can deliver to all your customers with your next update.
If your customers complain about the speed of your software, we can also train your team to use the IBExpert Benchmark, analyse the results and communicate the often very poor results to your customer, who is responsible for the hardware chosen for the Firebird server.
And finally, almost any software can benefit from a thorough examination regarding poor database design and bad SQL statements.
We can show you how to locate such issues and help you improve the performance of your software.
For an offer, please contact us with the subject "Remote Firebird 4/5 Update Workshop" with a brief description of your current products and your team: register@ibexpert.biz.
Remote Firebird 4/5 Update-Workshop
In erfolgreichen Workshops mit unseren Kunden haben wir die Lösung aller Konvertierungsprobleme soweit perfektioniert, dass wir auch Ihre Anforderungen schnell und flexibel via Online-Schulung umsetzen können.
Mit unserer Erfahrung können wir Sie als Anwender oder Entwickler dabei unterstützen, alle erforderlichen Schritte für ein erfolgreiches Upgrade Ihrer Firebird 2.x-basierten Anwendung umzusetzen, sodass diese auch mit Firebird 4/5 ausgeführt werden kann.
Wir wissen, wie Sie Ihre Datenbank konvertieren müssen, um eine leistungsstarke Firebird 4/5-Serverkonfiguration mit maximaler Kompatibilität mit Ihrer bestehenden Anwendung erstellen.
Bereiten Sie Ihre Datenbank auf die Kompatibilität mit Firebird 4/5 vor
Jedes serverbasierte Objekt, zum Beispiel Stored Procedures, Trigger, UDFs usw., wird automatisch überprüft und Sie erhalten nützliche Hinweise, wie Sie Ihre vorhandenen Firebird 2.x-Metadaten kompatibel für die spätere Konvertierung im Produktionssystem vorbereiten.
Außerdem erhalten Sie eine Einführung in ein neues Firebird-Setup und erfahren, wie Sie eine sekundäre neuere Firebird-Serverversion auf Ihrem oder dem Datenbankserver Ihrer Kunden parallel installieren, während es sich noch in der Produktion mit der bestehenden Installation befindet.
Selbst die Einführung eines automatisierten Updates auf Hunderten oder Tausenden von Kundeninstallationen ist mithilfe unserer IBExpert OEM-Technologie ohne eine manuelle Installation möglich.
Wir wissen, was passieren kann und unser Setup bietet allen Ihren Kunden ein automatisiertes Upgrade. Wenn alles gut funktioniert hat, können sie mit der neuen Firebird-Datenbankserverinstanz arbeiten.
Sollte jedoch etwas Unerwartetes passieren, erhalten Sie ein detailliertes Protokoll, aber das bestehende Setup ist weiterhin verfügbar.
Somit können Sie entscheiden, ob ein manuelles Setup erforderlich ist oder der automatisierte Update-Prozess verbessert werden muss.
Testen Sie Ihre Anwendung auf Firebird 4/5-Kompatibilität
Der Basis-Workshop dauert ca. 2 Tage und beinhaltet eine Analyse des bestehenden Systems sowie ein Backup/Restore aller erforderlichen Daten auf dem neuen Firebird-Server.
Um Zeitverschwendung beim Warten auf das Backup/Restore zu vermeiden, bieten wir unsere Workshops in der Regel im 4x4-Stunden-Format an.
Sie werden überrascht sein, wie schnell wir Ihre Anwendung mit der neuen Firebird 4/5-Datenbank als Backend zum Laufen bringen.
Unser Setup nutzt mehrere verfügbare Kompatibilitätskonfigurationsparameter, sodass Sie weiterhin alle Vorteile der neuen Firebird-Versionen nutzen und insbesondere bei Mehrbenutzerinstallationen eine deutlich bessere Leistung, insbesondere unter hoher Last, erzielen werden.
Weiterer Support
Sobald die Konvertierung abgeschlossen ist, können wir auch individuelle Unterstützung bei der Erstellung eines IBExpert OEM-basierten Upgrade-Moduls anbieten, das Sie mit Ihrem nächsten Update an alle Ihre Kunden ausliefern können.
Sollten sich Ihre Kunden über die Geschwindigkeit Ihrer Software beschweren, können wir Ihr Team auch im Umgang mit dem IBExpert Benchmark schulen, die Ergebnisse analysieren und die oft sehr schlechten Ergebnisse mit Ihrem Kunden, der für die für den Firebird-Server gewählte Hardware verantwortlich ist, kommunizieren.
Und schließlich kann fast jede Software von einer gründlichen Überprüfung hinsichtlich eines schlechten Datenbankdesigns und fehlerhafter SQL-Anweisungen profitieren.
Wir zeigen Ihnen, wie Sie solche Probleme lokalisieren und helfen Ihnen, die Performance Ihrer Software zu verbessern.
Für ein Angebot kontaktieren Sie uns bitte mit dem Betreff „Remote Firebird 4/5 Update Workshop“ und beschreiben Sie uns kurz Ihre aktuellen Produkte und Ihr Team: sales@ibexpert.biz.