Define key in dynamic schema when migrating database

Highlighted
Eight Stars

Define key in dynamic schema when migrating database

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 SettingInput Setting

 

tMap and schema

tMap and SchematMap and Schema

 

OutputOutput SettingOutput Setting

 

Input DB (MSSQL)

mssql-inputmssql-input

Output Database (MySQL)

mysql-outputmysql-output


Accepted Solutions
Highlighted
Six Stars

All Replies
Highlighted
Six Stars

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Talend Cloud Developer Series – Defining Metadata

This video focuses on different methods of adding metadata to a job in Talend Cloud

Watch Now

Talend Cloud Developer Series – Updating Context Variables

This video will show you how to add context parameters to a job in Talend Cloud

Watch Now

Talend Cloud Developer Series – Deploying First Job to Cloud

This video will show you how to run a job in Studio and then publish that job to Talend Cloud

Watch Now