Migration Guide to Firebird 3
Why a Migration Guide?
Firebird 3 brings numerous innovations, such as the long-awaited full SuperServer’s SMP support, network and database encryption, local user authentication in the database, improvements in the communication protocol, in addition to several new features in different areas of the DBMS. All this made the migration process from an older Firebird version a bit more complicated than it was in previous versions, where, basically, all you had to do was replace the server with the new Firebird version or, at worst, a backup and restore of the database.
With Firebird 3, you have different user management plugins allowing the same user to exist in several different plug-ins, with different passwords. The SYSDBA is now optional, as well the use of the security database (you can use any existing database as the security database). You can do this short test and see if you are prepared for Firebird 3.
This Guide will help you in the process of migrating your existing databases and servers to Firebird 3, avoiding headaches and bad surprises!
The guide is now available both in PDF format (122 pages) and printed. The table of contents can be seen in the end of this page.
About the author
Carlos H. Cantu is the maintainer of the FirebirdNews site, FireBase (biggest portal dedicated to Firebird in Portuguese language, with + 70,000 registered users) and author of two Firebird books (Firebird Essencial and Firebird 2, both available only in Brazil). He also organizes the biggest Firebird Conference in the world (Firebird Developers Day), with an average of 450 attendees each year, and currently in its 13th year.
Buy it now (with PayPal or PayPro)
The book is available either in PDF format and in printed format. For the PDF version, buy it using the button below. You will receive your copy in the email informed (make sure to check your antispam folder).
The eBook will be sent to the email informed below in 24h after the payment is confirmed (double check if you wrote your email correctly).
PS: Brazilians must buy the PT-BR version of the book at FireBase. For Portuguese speakers living outside Brazil, buy the book here and write a note in the comment field asking for the PT-BR version of the guide.
Price (PDF version): USD 16
If you don’t have a PayPal account, or do not want to create one, you can buy the eBook at Paypro.
To buy the PRINTED version, click here (USD 23.50).
Doubts? Email the author: livro -at- firebase.com.br
Table of Contents
- About the author
- Preface by Ann Harrison
- Icons used
- Basic but essential concepts!
- SuperServer vs. Classic vs. SuperClassic
- Classic (CS)
- SuperServer (SS)
- SuperClassic (SC)
- What architecture to choose?
- 32 vs. 64 bits
- SuperServer vs. Classic vs. SuperClassic
- Installing Firebird 3
- Installing Firebird 3 on Linux
- Installing Firebird on Windows®
- Server architecture
- Service or Application?
- Start automatically
- Client library (fbclient.dll)
- Authorization for legacy Firebird clients
- Checking whether Firebird is running
- Installing Firebird using the “Zip Kit”
- Migrating Existing Databases to Firebird 3
- Why Migration?
- ODS (On Disk Structure)
- Test the database integrity with gbak
- Problems with character encoding
- Validating the metadata
- Recommended steps for migrating a database to Firebird 3
- Migrating 24×7 servers
- Tips to speed up the backup/restore process
- Users in Firebird 3
- Local users
- Initializing the security database
- Managing users using SQL
- Creating users
- Modifying users
- Deleting users
- Sec$users and sec$user_attributes virtual tables
- Preparing a script to insert users into the new server
- Protecting your data
- Creating a secure environment
- Encrypting the database file
- Wire Protocol Enhancements
- Traffic encryption
- Traffic compression
- Enhancements for usage in high latency networks
- Connection strings
- Legacy syntax
- URL based syntax
- IPv6 support
- Firebird 3 and legacy applications
- .NET applications
- Jaybird applications
- Logical data type (Boolean)
- Connecting to Firebird 3 with an old client library (fbclient)
- Query performance
- Reserved words
- Manipulating the System tables (RDB$…)
- Testing application’s queries
- Using mon$attachments to get the number of active connections
- Default cache size for Classic/SuperClassic
- Mixing implicit and explicit joins
- Count() now returns a BIGINT
- Configuration entries