Home kettle Converting from other Databases to PostgreSQL
Reply: 0

kettle Converting from other Databases to PostgreSQL

user650
1#
user650 Published in July 16, 2018, 3:08 am

I have a problem when I convert mysql database to postgres.

mysql tablenames and columns are all uppercase but kettle creates postgres tables all lowercase when i run this job. The components of tableoutput prints log just like this

INSERT INTO USER_MENU ("FLOW_ID", "USER_ID" .... ,

I try mysql all lowercase, run successfully. I know postgres is case-sensitive but how to solve this case when mysql all uppercase or how to make the tableoutput to output lowercase sql.

Using kettle 6.1.0.1-R

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.304416 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO