How to migrate mysql database to postgresql 9.1 database?

One Star

How to migrate mysql database to postgresql 9.1 database?

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
One Star

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

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
One Star

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

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
One Star

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

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

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

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?