Manually Installing/Updating the Client Database
By default, the Travelport Booking Feed installation programmatically creates or updates the client database installation for Microsoft® SQL Server®. See Software Prerequisites for a list of recommended databases.
However, if you chose not to run the database scripts automatically during the installation, i.e., if you elected to skip automatic database setup during installation, you must manually install or update the database. In this case, the changes to the client database schemas must be manually configured to allow new data content to be stored.
By default, all database scripts required to build the database are located in C:\Program Files\Travelport\TBF\sql_scripts, where C: is the hard drive in which the Travelport Booking Feed application is installed.
To manually install or update the client database:
Note: It is not necessary to export existing data. Changes to the schema will result in null values in new columns for existing data rows in tables that are updated.
- From the Travelport Booking Feed database server or a machine with remote connectivity to the Travelport Booking Feed database, invoke your database interface tool of choice, such as Microsoft® SQL Server® Enterprise Manager.
- Open a connection to the Travelport Booking Feed database and open a SQL Query Analyzer, if necessary.
- Open (or cut‐and‐paste) the SQL alter script using the following format, where script is the script file.
- For Microsoft SQL Server databases, use: <InstallationDir>\Travelport\TBF\sql_scripts\SQL Server\script.sql.
- For Sybase databases, use: <InstallationDir>\Travelport\TBF\sql_scripts\Sybase\script.sql.
You can upgrade versions individually, shown below, or with a single script:
NOTE: TBF Adapter version 5 and above are improved to allow upgrade of database using only one TBF_DB_Update_Script.sql script.
The alter scripts vary depending on the type of Travelport Booking Feed installation:
|
For upgrades from version: |
Run: |
|---|---|
|
5.0 and Above - |
TBF_DB_Update_Script.sql |
| 9.5 |
To upgrade from 9.5, the below script needs to be run: --TBF_script_v10.1.sql |
| 9.4 |
-TBF_script_v9.5.sql -TBF_script_v10.1.sql |
| 9.1-9.3 |
- TBF_script_v9.4.sql -TBF_script_v9.5.sql -TBF_script_v10.1.sql |
| 9.0 |
- TBF_script_v9.1-v9.3.sql - TBF_script_v9.4.sql -TBF_script_v9.5.sql -TBF_script_v10.1.sql |
|
8.0 |
- TBF_script_v9.0 - TBF_script_v9.1-v9.3.sql - TBF_script_v9.4.sql -TBF_script_v9.5.sql -TBF_script_v10.1.sql |
| 7.1 |
- TBF_script_v8.0.sql - TBF_script_v9.0.sql - TBF_script_v9.1-v9.3.sql - TBF_script_v9.4.sql -TBF_script_v9.5.sql -TBF_script_v10.1.sql |
|
6.0 |
- TBF script_v7.1.sql - TBF_script_v8.0.sql - TBF_script_v9.0.sql - TBF_script_v9.1-v9.3.sql - TBF_script_v9.4.sql -TBF_script_v9.5.sql -TBF_script_v10.1.sql |
| 5.0 |
- TBF_script_v6.0.sql - TBF_script_v7.1.sql - TBF_script_v8.0.sql - TBF_script_v9.0.sql - TBF_script_v9.1-v9.3.sql - TBF_script_v9.4.sql -TBF_script_v9.5.sql -TBF_script_v10.1.sql |