Author Topic: DDL transformation-copy tables from one model to another without changing index  (Read 3241 times)

JozefMCK

  • EA Novice
  • *
  • Posts: 1
  • Karma: +0/-0
    • View Profile
Hello, Im very new with the transformations in EA so this might sound silly so sorry :)

I have a data model (with a set of tables which have primary keys and foreign keys defined) which I want to transform to a different data model with different naming of the tables/columns, but keeping the structure as it is.
I tried to use the DDL transformation for this. I managed the renaming (I gave the original tables and their columns alias names, which I use in the target model as tablenames and columnames. I slightly changed the Class and Attribute templetes for this)
The problem is the primary/foreign keys handling by the transformation. The way those transformations are written is that by default they generate primary keys in the target, and then use these keys as foreign keys. I dont want this functionality since I have all the indexes already set up in the source model. Is there a way how to do this kind of transformation which copies the tables with their indexes from the source as they were?
« Last Edit: February 02, 2024, 07:33:19 pm by JozefMCK »