<div>
I don't think there's a 'simple' way to do it. It's just a question of putting the work in
</div>


I don't think there's a 'simple' way to do it. It's just a question of putting the work in

<div>
Hi,<br />
<br />
But any approach you suggest?<br />
<br />
Br.
</div>


<div>
You need to issue a series of queries for each and every table
</div>


You need to issue a series of queries for each and every table

<div>
Should i do this e.g<br />
A) Table 2 fk (source): insert into Table 2' fk (target)<br />
<br />
B) Table 1 pk (source): insert into Table 1' pk (target)<br />
<br />
Should i do in this order (A, B) <br />
<br />
Fk: foreign key, Pk: primary key<br />
<br />
Prime tables are the tables that will have the merged data
</div>


Should i do this e.g
A) Table 2 fk (source): insert into Table 2' fk (target)

B) Table 1 pk (source): insert into Table 1' pk (target)

Should i do in this order (A, B)

Fk: foreign key, Pk: primary key

Prime tables are the tables that will have the merged data

<div>
Foreign keys would be a consideration if you are going to get referential integrity violations, yes. In that case, you need to do them in an order that doesn't cause violations
</div>


Foreign keys would be a consideration if you are going to get referential integrity violations, yes. In that case, you need to do them in an order that doesn't cause violations

<div>
Do you think my above order is correct?
</div>


<div>
<div class="content wysiwyg-content">
Hi,<br />
<br />
I need to merge 2 mysql databases with java or python.<br />
<br />
The databases are exactly the same in schema but data is different.<br />
<br />
in terms of the query which i need to pass in java or python. Anything i should care about?<br />
<br />
Would it be the case that i need to insert data to the table having foreign key first?<br />
<br />
what is the strategy?<br />
<br />
Br.
</div>
</div>


Hi,

I need to merge 2 mysql databases with java or python.

The databases are exactly the same in schema but data is different.

in terms of the query which i need to pass in java or python. Anything i should care about?

Would it be the case that i need to insert data to the table having foreign key first?

what is the strategy?

Br.

merging 2 mysql databases with java

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.

MySQL Server

Java is a platform-independent, object-oriented programming language and run-time environment, designed to have as few implementation dependencies as possible such that developers can write one set of code across all platforms using libraries. Most devices will not run Java natively, and require a run-time component to be installed in order to execute a Java program.

Java

Python is a widely used general-purpose, high-level programming language. Its design philosophy emphasizes code readability, and its syntax allows programmers to express concepts in fewer lines of code than would be possible in other languages. Python supports multiple programming paradigms, including object-oriented, imperative and functional programming or procedural styles. It features a dynamic type system and automatic memory management and has a large and comprehensive set of standard libraries, including NumPy, SciPy, Django, PyQuery, and PyLibrary.