 |
<< CRM workshop | Index | Firebird database review >> How to register for a course? Simply mail info@ibexpert.com 
Paradox2Firebird workshopConvert your Delphi®/BDE application now
This workshop is aimed at software houses who wish to convert their Delphi®/BDE/Paradox® applications to Delphi® and Firebird. Content We begin by discussing conversion rules and looking at which Firebird datatypes are best suited for Paradox datatypes. We will then transfer the Paradox tables with their structure and data by script into a Firebird database using IBEBlock. We use this opportunity to prevent passing on existing problems in the data structures by taking a look at and modifying the data model. By using updatable views, many existing program modules can be converted with relatively little effort.  The next step is to begin with the necessary conversion of the Delphi® source code. Following the straight conversion process, which is completed relatively quickly, the somewhat more difficult conversion of the database access components is approached, TTable, TQuery, TDatabase (or the respective alternatives offered by various component suppliers), as well as the respective TField components and all important events, which usually presents a bigger problem. Here there are various methods, the choice of which depends on the architecture. Projects which work mainly with TTable can be replaced relatively simply by IBObjects components. This is acceptable as a quick method to achieve a functional BDE-free Delphi® application, however it is recommended – even in this case – to convert to datasets. Before performing such a conversion, it is necessary to first inventory the existing database components. It is only possible to ensure that the functionality does not suffer through the conversion when it is known which properties and events are used, and find a fitting alternative for them. At this stage basic decisions and compromises need to be made between previous functionality and the possibilities that are now conceivable thru the use of the Firebird database. Classic loop constructions can be accelerated by 500 to 5,000% by relocating them into a stored procedure. Programming such a loop in the database as a procedure is considerably simpler than some programmers think. The few language elements of the SQL language and the extensions for stored procedures can be mastered by an experienced Delphi® developer in just a few hours. With the aid of the IBExpert Debugger even complex problems can be converted and speeded up considerably. Duration The workshop lasts 2-3 days, depending on the complexity of the existing data structures and programs. This is not a training course in the classic sense, but rather support for the conversion of a Delphi®/BDE/Paradox® application. Usually a running version of the software is achieved within the 3 days, so that at the end of the workshop, the participants can approach the detail work arising from testing the existing modules. During this phase the client can, if wished, take advantage of our support hotline or remote maintenance, to quickly solve any unexpected problems which may arise. Location The workshop can be booked worldwide and is performed in English or German. Please note that for non-EU nations we can only offer the 3-day workshop. Conclusion Over the years we have converted Paradox®/BDE/Delphi® applications to Firebird/Delphi® for more than 100 clients. Following the workshop so far not a single customer has continued to use the BDE and Paradox. Fees In addition to the workshop fees, each participant should have a licensed version of IBExpert Developer Studio. You can purchase a full single registered IBExpert license for EUR 189.00 at our online shop. Registration Please contact us at info@ibexpert.com or fax our Information Request form. << CRM workshop | Index | Firebird database review >> |