Four Stars

merge two databases into one

Hello,

 

I would like to know how to merge two Mysql database and oracle into one (oracle or mysql).

 

Thank you.

 

4 REPLIES
Fifteen Stars

Re: merge two databases into one

Get your company to hire a data integration expert. This is a bit like asking a decorator "How do I decorate my house?". The decorator will probably quite happily advise you of which paints to use and which brushes are the best ones. They may even point you to some tutorials on how to get the best finish. But if you ask them "How do I decorate my house" they will either hand you a quote or ask you to break the problem down into smaller, targeted questions.

Rilhia Solutions
Moderator

Re: merge two databases into one

Hello,

Please give us more information about your job requirement so that we can design a demo job for you.

Best regards

Sabrina

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Four Stars

Re: merge two databases into one

Hello,

Thank's for your help, 

I have realized this job until now, 

 

tContextLoad->tFileInputDelimited

                                                       |_-->tJDBCInput(database_source_1)----->tMap------->tJDBCOutput(database_destination)

 

i have repository containt my files of parametres of my databases Input (databases_source_1 and databases_source_2) and i want to merge theses data

(databases_source_1 and databases_source_2 from to (database_destination), so for that i want to set up a iterate on the repository who contain db_sources.

 

theres is a example of my repository and how the files are structured : 

 

my repertory named "databasesParameters " structured as follows:
database1.txt:
            - host, xxxx
            - port, xxxx
            - data_base_name, xxxx
            - user, xxxx
            - password, xxxx
            - table_name, xxxx

 

database2.txt:
            - host, xxxx
            - port, xxxx
            - data_base_name, xxxx
            - user, xxxx
            - password, xxxx

            - table_name, xxxx

 

 

Real Exemple : 

 

productsDb.txt

 

            - host,127.0.0.1
            - port, 5487
            - data_base_name, productsDb
            - user, free
            - password, pass

            - table_name, construction_products_holding

 

 

Thanks again for your help.

 

 

 

Four Stars

Re: merge two databases into one

Ok, first of all thank you for trying helping me ,

in the second, this is my case, i have a repository who containt text files, this is a simple case of the organisation of theses files : 

database1.txt:
            - host, xxxx
            - port, xxxx
            - data_base_name, xxxx
            - user, xxxx
            - password, xxxx
            - table_name, xxxx

 

database2.txt:
            - host, xxxx
            - port, xxxx
            - data_base_name, xxxx
            - user, xxxx
            - password, xxxx

            - table_name, xxxx

 

so i want to iterate on the texte file to migrate data from database source to destination(only one destination and multiples source).

 

 

thank you