Migration Guide to Firebird 3 - Brossura

Cantu, Carlos Henrique

Brossura

ISBN 10: 1536823872 ISBN 13: 9781536823875

Casa editrice: CreateSpace Independent Publishing Platform, 2016

Riassunto

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.

Moving to Firebird 3 can be a tricky process, and this Guide will help you in the process of migrating your existing databases and servers to Firebird 3, avoiding headaches and bad surprises! It also will give you tips regarding the use of Firebird 3 with legacy applications.

Table of Contents

1. Index
2. Dedication
3. Thanks
4. About the author
5. Preface by Ann Harrison
6. Introduction
7. Icons used
8. Basic but essential concepts!
   1. SuperServer vs. Classic vs. SuperClassic
      1. Classic (CS)
      2. SuperServer (SS)
      3. SuperClassic (SC)
      4. Embedded
   2. What architecture to choose?
   3. 32 vs. 64 bits
9. Installing Firebird 3
   1. Installing Firebird 3 on Linux
   2. Installing Firebird on Windows®
      1. Server architecture
      2. Service or Application?
      3. Start automatically
      4. Client library (fbclient.dll)
      5. gds32.dll
      6. Authorization for legacy Firebird clients
      7. Checking whether Firebird is running
      8. Installing Firebird using the “Zip Kit”
      9. INSTSVC
      10. INSTREG
      11. INSTCLIENT
10. Migrating Existing Databases to Firebird 3
    1. Why Migration?
    2. ODS (On Disk Structure)
    3. Test the database integrity with gbak
    4. Problems with character encoding
    5. Validating the metadata
    6. Recommended steps for migrating a database to Firebird 3
    7. Migrating 24x7 servers
    8. Tips to speed up the backup/restore process
11. Users in Firebird 3
    1. Local users
    2. Passwords
    3. Initializing the security database
    4. Managing users using SQL
       1. Creating users
       2. Modifying users
       3. Deleting users
    5. Sec$users and sec$user_attributes virtual tables
    6. Preparing a script to insert users into the new server
12. Protecting your data
    1. Creating a secure environment
    2. Encrypting the database file
    3. Conclusion
13. Wire Protocol Enhancements
    1. Traffic encryption
    2. Traffic compression
    3. Enhancements for usage in high latency networks
14. Connection strings
    1. Legacy syntax
    2. URL based syntax
    3. IPv6 support
15. Firebird 3 and legacy applications
    1. .NET applications
    2. Jaybird applications
    3. Logical data type (Boolean)
    4. Connecting to Firebird 3 with an old client library (fbclient)
    5. Query performance
    6. Reserved words
    7. Manipulating the System tables (RDB$...)
    8. Testing application’s queries
    9. Using mon$attachments to get the number of active connections
    10. Default cache size for Classic/SuperClassic
    11. Mixing implicit and explicit joins
    12. Count() now returns a BIGINT
16. Appendix
    1. Macros
    2. Configuration entries
17. Glossary

Su questo libro

Informazioni sull?autore

Carlos Henrique Cantu is well-known in the Brazilian Firebird users' community, having launched (in 2001) the first Portuguese speaking portal devoted to Firebird, currently with more than 70,000 subscribed users.

Carlos has published dozens of Firebird articles in several programming magazines in Brazil, was the president of DUG-BR (Delphi Users Group Brazil), editor of the DB FreeMagazine, columnist of the ActiveDelphi magazine and organizer of the Firebird Developers Day conference - the biggest Firebird conference in the world - with an average of 450 attendees each year, and currently in its 13th year. He also published two best selling books about Firebird (Firebird Essencial, and Firebird 2 – both of them available only in Portuguese), spoke at five different International Firebird Conferences, at every Brazilian DDD (Delphi Developers Day) and FDD (Firebird Developers Day), and several other seminars about databases and programming.

Dettagli dell'edizione

• Editore: CreateSpace Independent Publishing Platform
• Data di pubblicazione: 2016
• Lingua: Inglese
• ISBN 10: 1536823872
• ISBN 13: 9781536823875
• Rilegatura: Copertina flessibile
• Numero edizione: 1
• Numero di pagine: 133
• Contatto del produttore: non disponibile
• Persona responsabile: Yeepin GmbH; 492000000000; sunshine12232@outlook.com; ; Alleestr.11; Kaiserslautern; Rheinland-Pfalz; 67655; Germania