How to migrate mysql database to postgresql 9.1 database?

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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?