NonStop NS-Series Database Migration Guide

HP Integrity NonStop NS-Series Database Migration Guide—540469-001

3-1

Migrating an Enscribe Database

This section addresses these topics:

•

Converting Enscribe Data and Applications to SQL/MP on the New System on

page 3-1

•

Converting Enscribe Data and Applications to SQL/MX on the New System on

page 3-2

•

Converting DDL Dictionaries for Enscribe Applications on the New System on

page 3-2

•

Moving Enscribe Files to the New System on page 3-4

For information about Enscribe applications, see Section 4, Migrating SQL/MP,

SQL/MX, and Enscribe Applications.

Converting Enscribe Data and Applications to

SQL/MP on the New System

Use the Escort SQL™ product to convert some or all of your Enscribe data and

applications on the NonStop S-series system to SQL/MP on the Integrity NonStop

NS-series system. Escort SQL allows application files to be replaced with SQL/MP

tables and requires no programming changes to or recompiling of existing Enscribe

applications.

To convert Enscribe files and applications to SQL/MP:

1. Make sure that Escort SQL is installed on the NonStop S-series system and the

Integrity NonStop NS-series system. For installation instructions, see the Escort

SQL User’s Guide, which is available from Carr Scott Software Incorporated.

2. Use Escort SQL to create the new SQL/MP tables on the Integrity NonStop

NS-series system.

3. Use Escort SQL to load the Enscribe data from the NonStop S-series system to

the into the SQL/MP tables on the Integrity NonStop NS-series system.

Note. If you are using AutoSYNC as part of your migration strategy, you can use the

TRIGGER feature of AutoSYNC to automate certain repetitive tasks after moving objects and

configuration files to the Integrity NonStop NS-series system. For example, you can use a

trigger to SQL compile a program. You can use triggers to automatically edit configuration files,

such as replacing the node name of the NonStop S-series system. For information about these

services, see the HP NonStop AutoSYNC Software User’s Guide.

Note. Currently, Escort SQL does not support the conversion of Enscribe files and

applications to NonStop SQL/MX.