may be I’m wrong, but it seems, that sync & convert creates slightly different
alter scripts, if I generate them from same model 8.0.txp and separatedly reverse engeneered DB model than internally reverse engeneered model from the same, inbetween not changed, Database.
I took both generated Scripts and loaded them into SQL Navigator to see the differences.
There are some. You can see the differences just as the first Line starting line 1619.
The statements 1754 and 1748 of the “…intern_generated…” another table.
STAEDTE and STADTTEILe should only exist in Schema HM after the script.
Also 1649 in “…intern_generated…” and 1745 in “…intern_generated…” differ.
WAEHRUNGEN should only exist in Schema HM after the script.
Please take a look. May be there is an error in SQL Navigator or in data modeler or I have getting nuts inbetween of all the errors I reported …
See attached files.
AlterScript_PCA_aus_generiertem_HAMAA_extra_Reengeneered.sql (622 KB)
AlterScript_PCA_aus_generiertem_HAMAA_intern_Reengeneered_alle selektiert.sql (622 KB)
HalloMarie8.0.txp (2.46 MB)
HalloMarieRE_HAMAA.txp (5.45 MB)