- •Firebird 2 Migration & Installation
- •Table of Contents
- •Known Compatibility Issues
- •Two Changes to Note in V.2.1
- •The FIREBIRD Variable
- •Security in Firebird 2 (All Platforms)
- •Trusted Authentication on Windows
- •SQL Migration Issues
- •Changed Ambiguity Rules in SQL
- •Multiple Hits to Same Column Now Illegal
- •Query Plans
- •PSQL
- •Configuration Parameters
- •Command-line Tools
- •Change to gbak -R Semantics
- •Performance
- •Firebird API
- •Windows-Specific Issues
- •Windows Local Connection Protocol with XNet
- •Client Impersonation No Longer Works
- •Interactive Option Added to instsvc.exe
- •INSTALLATION NOTES
- •Choosing a Server Model
- •Database Compatibility Among Models
- •Full Servers
- •Embedded
- •Windows Installs
- •Choosing an Installation Method
- •READ THIS FIRST!
- •Naming databases on Windows
- •Other Pre-installation Issues
- •Installation of Microsoft system libraries
- •Zip kit install
- •Running Firebird as a service with a special user name
- •Installing Multiple Servers
- •Installing under 64-bit versions of Windows
- •Installation of fbclient.dll
- •Registry Key
- •Supporting legacy applications and drivers
- •InstClient.exe Tool
- •Cleaning up release candidate installs
- •Using the Win32 Firebird Installer
- •Uninstallation
- •Installing Superserver from a zip kit
- •Installing Classic Server from a zip kit
- •Simplified setup
- •Uninstallation
- •Other Win32 Issues
- •Updated Notes for Windows Embedded
- •Registry
- •Database Access
- •Authentication and Security
- •Compatibility
- •Installing an Embedded Server Application
- •Installation Structure Examples
- •POSIX Platforms
- •READ THIS FIRST
- •Setting Linux to Use the Old Threading Model
- •Installing on Linux
- •RPM Installer
- •Installing the Tarball
- •Testing your Linux installation
- •Step 1 - Accessing a database
- •Step 2 - Creating a database
- •Utility Scripts
- •Linux Server Tips
- •"Embedded" or direct access to database files
- •Uninstalling on Linux
- •Uninstalling an RPM package
- •Uninstalling a tarball installation
- •Solaris
- •MacOS X
- •FreeBSD
- •Debian
Firebird 2 Migration & Installation
Helen Borrie (Collator/Editor)
6 April 2008 - Document v. mi210_20 - for Firebird 2.1
Firebird 2 Migration & Installation
6 April 2008 - Document v. mi210_20 - for Firebird 2.1 Helen Borrie (Collator/Editor)
Table of Contents |
|
1. Known Compatibility Issues ............................................................................................................... |
1 |
Two Changes to Note in V.2.1 ....................................................................................................... |
1 |
The FIREBIRD Variable ................................................................................................................ |
1 |
Security in Firebird 2 (All Platforms) .............................................................................................. |
1 |
Trusted Authentication on Windows ....................................................................................... |
2 |
SQL Migration Issues .................................................................................................................... |
3 |
DDL ...................................................................................................................................... |
3 |
DML ..................................................................................................................................... |
4 |
PSQL .................................................................................................................................... |
6 |
Configuration Parameters ............................................................................................................... |
7 |
Command-line Tools ...................................................................................................................... |
8 |
Change to gbak -R Semantics ................................................................................................. |
8 |
Performance ................................................................................................................................... |
8 |
Firebird API .................................................................................................................................. |
9 |
Windows-Specific Issues .............................................................................................................. |
10 |
Windows Local Connection Protocol with XNet .................................................................... |
10 |
Client Impersonation No Longer Works ................................................................................ |
10 |
Interactive Option Added to instsvc.exe ................................................................................ |
10 |
2. INSTALLATION NOTES ................................................................................................................ |
11 |
Choosing a Server Model ............................................................................................................. |
11 |
Database Compatibility Among Models ................................................................................. |
11 |
Full Servers ......................................................................................................................... |
11 |
Embedded ............................................................................................................................ |
12 |
Windows Installs .......................................................................................................................... |
12 |
Choosing an Installation Method ........................................................................................... |
12 |
READ THIS FIRST! ............................................................................................................ |
12 |
Naming databases on Windows ............................................................................................. |
14 |
Other Pre-installation Issues .................................................................................................. |
14 |
Using the Win32 Firebird Installer ........................................................................................ |
17 |
Installing Superserver from a zip kit ..................................................................................... |
20 |
Other Win32 Issues .............................................................................................................. |
22 |
Updated Notes for Windows Embedded ................................................................................ |
22 |
POSIX Platforms .......................................................................................................................... |
24 |
READ THIS FIRST ............................................................................................................. |
25 |
Installing on Linux ............................................................................................................... |
26 |
Testing your Linux installation ............................................................................................. |
27 |
Utility Scripts ....................................................................................................................... |
29 |
Linux Server Tips ................................................................................................................ |
29 |
Uninstalling on Linux ........................................................................................................... |
30 |
Solaris ................................................................................................................................. |
30 |
MacOS X ............................................................................................................................ |
30 |
FreeBSD .............................................................................................................................. |
31 |
Debian ................................................................................................................................. |
31 |
iv