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
|