Zurück
-
Titel
If TYPES differ by "ALTER TYPE" statements, apply only the "ALTER TYPE" to sync, rather than entire "CREATE OR REPLACE -
Beschreibung
Generation of change scripts for object types is invalid.
Steps to reproduce the problem:
Use the attached “CompSetup.SQL” to create the two schemas (COMP1 and COMP2) to be compared
Compare COMP2 (source) vs COMP1 (target)
Notice that sync script includes CREATE OR REPLACE. This statement will fail because there is a table dependent on the type.
Enhancement: Instead of “CREATE OR REPLACE”, just apply the ALTER statements in the COMP2 source to COMP1.
Anmeldung erforderlich
Sie müssen sich anmelden und über einen gültigen Servicevertrag verfügen, um auf Premium-Wissensartikel zugreifen zu zu dürfen.