Main -> Documentation -> WebZ System Administration -> Access Component -> The updateSQL.pl Utility

The updateSQL.pl Utility

 

Contents

Introduction
Document Conventions
File Location
Syntax
Converting a 4.1.1 WebZ Access Database (accessdb) and Loading It into SiteSearch 4.1.2
Converting a 4.1.1 Record Builder Access Database (rbdb) and Loading it into SiteSearch 4.1.2
Changes Made to accessdb Database During Conversion
Changes Made to rbdb Database During Conversion


Introduction

The updateSQL.pl utility is a Perl script that allows you to convert an Access component database (accessdb for WebZ and rbdb for Record Builder) used in SiteSearch 4.1.1 to the new table structure used in SiteSearch 4.1.2. updateSQL.pl calls a number of other Perl scripts to perform the conversion.

You normally run this utility during a SiteSearch 4.1.2 upgrade, although you can run it at any time as long as you still have a 4.1.1 version of accessdb or rbdb available and a way to create a dump file of these databases.


Document Conventions

  • <WebZ_root> refers to the location of your installed 4.1.2 SiteSearch environment.
  • <WebZ411_root> refers to the location of the 4.1.1 SiteSearch environment that contains the Access component database(s) you want to convert to the 4.1.2 table structure. The SiteSearch 4.1.2 upgrade procedure refers to this directory as <WebZWork_root>.

File Location

You can find updateSQL.pl and its companion scripts (chgAuthos.pl, chgInstData.pl, chgInstTable.pl, chgText.pl, and chg411DumpFiles.pl) in the <WebZ_root>/scripts directory.


Syntax

perl updateSQL.pl dumpfile_name [webz | rb] <nt>

Important Note:  

This script includes a variable that points to your Perl interpreter:

$perlPath = "/usr/bin/perl";

Edit the value of this variable if your Perl interpreter resides at a different location. This script will not run if this variable does not contain the path to your Perl interpreter.


Parameter

Description

dumpfile_name

Name of the database dump file that contains the database in version 4.1.1 format. By convention, the file names are accessdb.dump for the accessdb database and rbdb.dump for the rbdb database, although you can use any file name you wish.

This file must exist in one of these directories:

Operating System

SiteSearch Component
WebZ Record Builder

UNIX

<WebZ_root>/mysql

<WebZ_root>/mysql

WindowsNT

<WebZ_root>/accesssql

<WebZ_root>/accesssql/rbv0

The utility overwrites this file with the converted database structure and makes a copy of the original database dump file in dumpfile_name.orig.

webz | rb

SiteSearch component to which the database dump file applies:

  • webz for WebZ
  • rb for Record Builder

nt

Optional parameter that indicates you are converting a Windows NT database.

Return to Contents


Converting a 4.1.1 WebZ Access Database (accessdb) and Loading It into SiteSearch 4.1.2

1. Follow the steps in Copying and Converting WebZ Access Database in the SiteSearch 4.1.2 upgrade procedure.

2. See Changes Made to accessdb Database During Conversion for a list of the changes made to the structure and data in accessdb.

2. Using the sample accessdb database shipped with SiteSearch 4.1.2, configure and then test the Access component for WebZ in your SiteSearch 4.1.2 component (click here for UNIX; click here for Windows NT).

3. Which operating system are you using?

  • UNIX:
    • Rename <WebZ_root>/mysql/accessdb.dump with another name of your choice.
    • Rename <WebZ411_roo/msql/dumpfile_name as accessdb.dump. This is the data file that contains your patron data.
  • Windows NT:
    • Rename <WebZ_root>/accesssql/accessdb.sql with another name of your choice.
    • Rename <WebZ411_root>/accesssql/dumpfile_name as accessdb.sql. This is the data file that contains your patron data.

4. Create a new instance of the accessdb database and load the converted 4.1.2 data file into this database:

Return to Contents


Converting a 4.1.1 Record Builder Access Database (rbdb) and Reloading it into SiteSearch 4.1.2

1. Follow the steps in Copying and Converting Record Builder Access Database in the SiteSearch 4.1.2 upgrade procedure.

2. See Changes Made to rbdb Database During Conversion for a list of the changes made to the structure and data in accessdb.

2. Using the sample rbdb database shipped with SiteSearch 4.1.2, configure and then test the Access component for WebZ in your SiteSearch 4.1.2 component (click here for UNIX; click here for Windows NT).

3. Which operating system are you using?

  • UNIX:
    • Rename <WebZ_root>/mysql/rbdb.dump with another name of your choice.
    • Rename the <WebZ411_root>/msql/file as rbdb.dump. This is the data file that contains your patron data.
  • Windows NT:
    • Rename <WebZ_root>/accesssql/rbv0/rbdb.sql with another name of your choice.
    • Rename the <WebZ_root>/accesssql/rbv0/dumpfile_name file as rbdb.sql. This is the data file that contains your patron data.

4. Create a new instance of the rbdb database and load the converted 4.1.2 data file into this database:

Return to Contents


Changes Made to accessdb Database During Conversion

updateSQL.pl and its companion scripts make the following changes to the structure of the accessdb database:

  • Changes the data type of all columns with a data type of TEXT to a data type of CHAR.
  • In the authos table, changes the name of the instsym column to instkey.
  • Adds three new columns to the inst table.
    • instkey. Populates this column with the same data contained in the instsym column.
    • illdbkey. Populates this column with the value ACQill in each row.
    • doublecheckdbs. Populates this column with the value NULL.
  • Adds a new table, instdbill, with four new columns: illdbkey, dbname, illserver, and doublecheckcontinue. Populates this table with one row with an illdbkey of ACQill.
  • Adds three new columns to the userresource table:
    • dbid. Populates this column with the value 0.
    • db_autho. Populates this column with the value NULL.
    • db_password. Populates with column with the value NULL.

Return to Contents


Changes Made to rbdb Database During Conversion

updateSQL.pl and its companion scripts make the following changes to the structure of the rbdb database:

  • Changes the data type of all columns with a data type of CHAR to a data type of TEXT.
  • Adds a new column, defaultdb, to the authos table. Populates this column with the value dc.

Return to Contents


See Also

Access Component Overview
Configuring the WebZ Access Component for WebZ (UNIX)
Configuring the WebZ Access Component for WebZ (Windows NT)
Operating the WebZ System
Access Server Configuration Files
Access Client Configuration Files


[Main][Documentation][Support][Technical Reference][Community][Glossary][Search]

Last Modified: