Clone problem with mySQL and Postgres

Five Stars

Clone problem with mySQL and Postgres

Hi, 

 

I have an issue when cloning mySQL properties of a database to Postgres. 

Does it have something to do with mySQL-Postgres incompatibility that the comments for a tables columns isn't cloned in the process?

 

In this screenshot on the left side i have the source table and on the other side dest table. It clearly has the comments field but when I check it to postgres, that field is empty. 

 

 

 

 

Forteen Stars

Re: Clone problem with mySQL and Postgres

Hi,

 

it is not related to incompatibility, it just mean Talend do not create comments in database

it not only one "issue", so be careful and always check - what created?

 

best practice - do not create database objects by Talend, do this by SQL code and/or tools.

 

-----------

2019 GARNER 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

What’s New for Talend Summer ’19

Watch the recorded webinar!

Watch Now

How OTTO Utilizes Big Data to Deliver Personalized Experiences

Read about OTTO's experiences with Big Data and Personalized Experiences

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog

Talend Integration with Databricks

Take a look at this video about Talend Integration with Databricks

Watch Now