NonStop NS-Series Database Migration Guide

Migrating an Enscribe Database
HP Integrity NonStop NS-Series Database Migration Guide—540469-001
3-2
Converting Enscribe Data and Applications to
SQL/MX on the New System
During load operations, the Escort SQL Journaling Service keeps track of all
changes to Enscribe records and applications on the NonStop S-series system and
automatically replicates these changes to the SQL/MP tables on the Integrity
NonStop NS-series system. The Journaling Service feature allows Enscribe
applications to continue running until both databases are almost fully synchronized.
4. Use AutoSYNC to move all objects that cannot be audited, including those
associated with the Enscribe applications, to the Integrity NonStop NS-series
system.
5. After the Enscribe database on the NonStop S-series system and the SQL/MP
database on the Integrity NonStop NS-series system are synchronized, stop all
affected Enscribe applications on the NonStop S-series system and use Escort
SQL to apply all remaining updates to the SQL/MP tables and bring up the
applications on the Integrity NonStop NS-series system.
6. From the Integrity NonStop NS-series system, perform all necessary cleanup tasks
on the SQL/MP tables (for example, balancing the partitions).
For more information, see the:
•
HP NonStop AutoSYNC User's Guide
•
HP NonStop AutoTMF Software User’s Guide
•
ESCORT SQL™ User’s Guide (Version 1.7.0), which can be obtained from Carr
Scott Software Inc. at http://www.carrscott.com/evaluation_prog.shtml
Converting Enscribe Data and Applications to
SQL/MX on the New System
At this time, there are no approved vendor or third party products available for
converting Enscribe data directly to SQL/MX data. However, you can create SQL/MX
applications on the Integrity NonStop NS-series system and use them to query
SQL/MP tables. You do this by embedding CREATE SQLMP ALIAS statements in the
SQL programs that map from ANSI names to the physical names of SQL/MP tables.
For more information, see the SQL/MX Programming Manual for C and COBOL.
Converting DDL Dictionaries for Enscribe
Applications on the New System
Overview of DDL Dictionaries for Enscribe Applications
The Data Definition Language (DDL) enables you to define data objects in Enscribe
files and to translate these object definitions to source code for programming
languages and other products on NonStop systems. The DDL compiler compiles object
definitions and generates any requested output from the compiled definitions.
Depending on which commands you enter, the DDL compiler builds a dictionary from