Define key in dynamic schema when migrating database

[Anonymous]

Hi,

Using the following job and settings, I was able to dynamically migrate a whole database from MSSQL to MySQL. However, I noticed that the primary key fields (column) and primary composite key is not generated in the output database.

Is there a way to dynamically migrated primary key fields (column) and primary composite key together with the tables and its data(+schemas)? My tables have around 1~4 primary key fields (column). || I'm using dynamic columns to dynamically migrate tables.

Here's my job design

Input Setting

tMap and schema

tMap and Schema

OutputOutput Setting

Input DB (MSSQL)

mssql-input

Output Database (MySQL)

mysql-output

[JohnRMK · Accepted solution]

https://community.talend.com/yutwg22796/board/message?board.id=integrating&message.id=118389#M118389

[LL1615296754]

Link is not available. Could you please send it again? Thanks