topic Re: db to db migration in Talend Studio

db to db migration

Anonymous — Sat, 16 Nov 2024 13:18:31 GMT

Can anybody help me how to migrate one mysql db to another mysql db present on another host machine? I am really blank about which components to use to achieve this data migration. Any kind of help will be really appreciated. Thanks

Re: db to db migration

Anonymous — Thu, 19 Aug 2010 14:59:28 GMT

Hi
Do you want to migrate the whole db or only some of tables? Please learn the usage of tMysqlInput and tMysqlOutput components on user documentation.

Best regards
Shong

Re: db to db migration

Anonymous — Fri, 20 Aug 2010 05:47:01 GMT

I want to migrate the whole db. Can you help me how to achieve that using tMySqlInput and tMySqlOutput?

Re: db to db migration

Anonymous — Fri, 20 Aug 2010 13:46:17 GMT

Hi,
just a few more hints ...
- tMySQLConnection
|
- tMySQLTableList --- tMySQLInput --- tMySQLOutput

Hope this helps

Best regards
Christian

Re: db to db migration

Anonymous — Tue, 24 Aug 2010 11:30:20 GMT

I am using mysql 4.1 and I am getting this exception and unable to load the table information 😞
Exception in component tMysqlTableList_1
com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Table 'information_schema.tables' doesn't exist
Can anybody help?

Re: db to db migration

Anonymous — Tue, 24 Aug 2010 11:55:28 GMT

Hi,
I just found this information :

Starting from MySQL 5, when you execute show databases command, information_schema will be listed in the database list. information_schema is a virtual MySQL database that stores metadata information of all the MySQL databases.

So, with MySQL 4.1 the tables are not accessible via information_schmea.tables ... I think there is an option in the MySQL Connection element, where you can define what version of MySQL you are using. I dont't have a 4.x version at hand right now. Sorry!
Maybe this information is still helpful

Good Luck!
Christian

: http://www.thegeekstuff.com/2008/11/overview-of-mysql-information_schema-database-with-practical-examples/

Re: db to db migration

Anonymous — Tue, 24 Aug 2010 11:59:03 GMT

I think there is an option in the MySQL Connection element, where you can define what version of MySQL you are using. I dont't have a 4.x version at hand right now. Sorry!

I just checked the tMySQLConnection component. You can choose between two values for DB Version: Mysql 5 and Mysql 4
Have you checked, that you realy set this option to Mysql 4?
Regards,
Christian

Re: db to db migration

Anonymous — Tue, 24 Aug 2010 12:42:36 GMT

I have just checked with it and still getting the same exception

Re: db to db migration

Anonymous — Tue, 24 Aug 2010 19:38:30 GMT

I would also like to chime in that I am attempting to do something similar with the tMySQLTableList component, and am receiving the same error message. Is this component only compatible with MySQL 5? There is nothing in the documentation that I can see that states that. If there is no quick solution then this needs to be entered into the Bugtracker system since this is blocking our progress.
Thanks,
Ryan

Re: db to db migration

Anonymous — Wed, 22 Sep 2010 04:52:44 GMT

What Collation are you all using?
I'm trying to get tMSSQLTableList working on SQL Server 2008 with Latin1_General_BIN and in MSSQL the View is INFORMATION_SCHEMA.TABLES where the error comes back as information_schema.tables (invalid object name)
Can anyone help?

Re: db to db migration

Anonymous — Thu, 23 Sep 2010 19:27:57 GMT

I want to migrate the whole db. Can you help me how to achieve that using tMySqlInput and tMySqlOutput?

If you database source and database destination have the same structure. You don't really need talend. Just an import/Export with any MySQL client (phpMyadmin, MySQLQueryBrowser, etc.)
If you table structure are differents or you you want to transform some data. Talend can do that perfectly.
1) Open new projet
2) Add job
3) Add data base connection source
4) Add data base connection destination
5) Add tMysqlInput (drag and drop table from source table list as input)
6) Add tMysqlOutput (drag and drop table from destination table list as output)
7) Add tMap component
😎 Connect all your compenent
9) Verify compenent parameters
10) Execute you job and have fun
This video may help you to start.