Download TermLinx Database Manager

TLX-DBM ♦ TermLinx Database Manager
Terminal Management System
6.6
Reference
Database Manager Manual
Upgrading from a Previous Version
For customers with a DBA, the DBA would handle this task. For customers who
make use of TermLinx’s Database Manager to manage the data, you will need to
handle these steps, but you may wish to consult with Oracle or an Oracle
consultant during this process.
Important: The schema name in this version is TermLinx.
Start by backing up the existing database, and exporting it. Then import into
Oracle 10g XE. Oracle provides documentation and tools for this. Export the
tables in this order:
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
SITE
NADR
STRF
PRDC
CARR
DRVR
DCXR
VHCL
PVST
LOCN
QOTL
QOTD
QLCX
QDCX
CHXR
CCXR
SPXR
TRNS
TXCP
You will find Oracle tools and documentation for version 10g XE in: Start /
Programs / Oracle Database 10g Express Edition.
If you are an Entero user, you might consider not moving old data into your new
database, and just set up the new one with new data, and downloading new
accounting data from Entero. Make sure you archive what you need out of the
old database before retiring it completely.
If you are moving to a new/different computer, along with moving your database,
also bring over your configuration files, including OPK/OPS files and registry
entries.
Page 100 of 128
ProSoft Technology, Inc.
August 11, 2009