Define key in dynamic schema when migrating database

Anonymous — Sat, 16 Nov 2024 03:03:12 GMT

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

Re: Define key in dynamic schema when migrating database

JohnRMK — Mon, 09 Mar 2020 18:37:09 GMT

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

Re: Define key in dynamic schema when migrating database

LL1615296754 — Tue, 09 Mar 2021 13:34:32 GMT

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

topic Define key in dynamic schema when migrating database in Talend Studio

Define key in dynamic schema when migrating database

Re: Define key in dynamic schema when migrating database

Re: Define key in dynamic schema when migrating database