topic Re: How to migrate mysql database to postgresql 9.1 database? in Talend Studio

How to migrate mysql database to postgresql 9.1 database?

Anonymous — Sat, 16 Nov 2024 12:17:22 GMT

Hi All,
I'm new Talend Tool.I need to import mysql database to postgresql 9.1 database.
Can anyone please suggest me where i can get this details.
Thanks in advance.
Sripada H R

Re: How to migrate mysql database to postgresql 9.1 database?

Anonymous — Mon, 21 May 2012 07:30:11 GMT

Hi
For Talend Open Studio, you have to create a job as follow.
tMysqlInput--main-->tPostgresqlOutput
And you have to migrate DB table by table.
For Talend Integration Suite(Commercial version), you can create a job with dynamic schema feature.
tMysqlConnection
|
OnsubjobOK
|
tMysqlTableList--Iterate-->tMysqlInput(dynamic schema)--main->tPostgresqlOutput
You needn't to create so much jobs table by table.
Regards,
Pedro

Re: How to migrate mysql database to postgresql 9.1 database?

Anonymous — Mon, 21 May 2012 07:45:41 GMT

Hi Pedro,
Thanks Alot!!!!!!!!!!!!!!!
Can you please suggest some videos in talend or youtube if available to watch and understand the working.
Thanks In Advance.
Sripada H R

Re: How to migrate mysql database to postgresql 9.1 database?

Anonymous — Mon, 21 May 2012 07:51:34 GMT

Hi
For a quick start, you might read tutorials here.
Besides, you can download document and get instructions and scenarios from it.
Regards,
Pedro

Re: How to migrate mysql database to postgresql 9.1 database?

Anonymous — Wed, 03 Aug 2016 16:12:06 GMT

Hi all,
I'm new to Talend Tool.I need to import mysql database to postgresql 9.1 database.
Can anyone please suggest me where i can get this details.
Please explain it some sample jobs.i don't know how to use the tTransferDatabase.please explain it?