Migrating an Enterprise Database Server Database

To migrate your Enterprise Database Server database that was previously generated with the SQLVIEW command using DMSQL, run the new MCPSQL Schema Administrator with the SQLVIEW command.

Run the following command if you made no additional changes to the SQL schema: 

RUN *SYSTEM/SQL/ADMIN("SQLVIEW DATABASE <database name>
    :ACCESSCONTROL=UPDATEOK");

Run the following command if you made changes to the SQL schema (such as renaming a column or table) and want to preserve those changes: 

RUN *SYSTEM/SQL/ADMIN ("SQLVIEW DATABASE <database name>
    :ACCESSCONTROL=UPDATEOK");
    FILE CARD=DDLRESULTS/<database name>/SEMANTIC
Note: For more details on running the ADMIN utility, see the Relational Database Server for ClearPath MCP Query Processor Programming Guide.

This will create a new DESCRIPTION/<database name>/MCPSQL-CATALOG file and will leave the old DESCRIPTION/<database name>DMSQL-CATALOG file as it was.

Prev  Up  Next
Migrating from an SQL Query Processor for ClearPath MCP Database to a Relational Database Server for ClearPath MCP Query Processor Database  Home  Migrating an SQL Database