Consultor Eletrônico



Kbase P8812: How to use Incremental Schema Migration utility using DataServers
Autor   Progress Software Corporation - Progress
Acesso   Público
Publicação   24/09/2008
Status: Verified

GOAL:

Is Incremental DF supported with Microsoft SQL Server DataServer?

GOAL:

Is Incremental DF supported with Oracle DataServer?

GOAL:

Does Microsoft SQL Server DataServer have the capability to generate a Delta or Incremental DF and SQL?

GOAL:

Does Oracle DataServer have the capability to generate a Delta or Incremental DF and SQL?

GOAL:

How to generate an incremental .df file for Oracle DataServer?

GOAL:

How to generate an incremental .df file for Microsoft SQL Server DataServer?

GOAL:

How to update definitions using Oracle DataServer

GOAL:

How to update definitions using Microsoft SQL Server DataServer

GOAL:

How to apply changes made to a Progress database into DataServer

GOAL:

How do I migrate schema changes from Progress to Oracle?

GOAL:

Is there a Progress-to-ORACLE Incremental Schema Migration Utility?

GOAL:

What is delta SQL progress to oracle utility?

GOAL:

How Incremental Schema Migration utility works?

GOAL:

How to use Incremental Schema Migration utility

GOAL:

How to make changes to a Oracle database using a incremental delta.df

GOAL:

How to reflect the changes made to a Progress database into a ORACLE database

GOAL:

What the option "Generate Delta.sql Progress to ORACLE" does ?

GOAL:

How to avoid error 1896 with DataServers

GOAL:

** CRC for <filn> does not match CRC in <procedure>. Try recompiling. (1896)

FACT(s) (Environment):

Oracle DataServer
MS SQL DataServer
OpenEdge DataServer Category: Oracle

FIX:

Yes. Since Progress 9.x for DataServer for Oracle and starting on OpenEdge 10.0A for DataServer for Microsoft SQL Server provide a tool called "Incremental Schema Migration utility" that help you to migrate schema changes from an OpenEdge database to an ORACLE or to a MS SQL Server database. These tool can be accessed from the DataServer menu in the Data Administration tool.

When working within a multiple data source infrastructure, i.e. having Progress