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
tMap and schema
Input DB (MSSQL)
Output Database (MySQL)
Solved! Go to Solution.
Talend named a Leader.
Kickstart your first data integration and ETL projects.
This video focuses on different methods of adding metadata to a job in Talend Cloud
This video will show you how to add context parameters to a job in Talend Cloud
This video will show you how to run a job in Studio and then publish that job to Talend Cloud