ConquerDatabaseHandler

[lpf333]

i want Looking for a merge database tool

Dear gods, who can share：p：p：p

[bashondegek]

What kind of 'merge' tool are you looking for?

[lpf333]

Originally Posted by bashondegek

What kind of 'merge' tool are you looking for?

Merge two databases into one

[bashondegek]

Originally Posted by lpf333

Merge two databases into one

Tables and columns are all the same?
Column types, names etc?

If not, you'll have a hard time merging 2 databases into one.

[lpf333]

Originally Posted by bashondegek

Tables and columns are all the same?
Column types, names etc?

If not, you'll have a hard time merging 2 databases into one.

All tables and fields are the same. I need a tool

[bashondegek]

Originally Posted by lpf333

All tables and fields are the same. I need a tool

Just try it with queries.
Something like this will do the job;

INSERT INTO database2.table_name
SELECT * FROM database1.table_name
ON DUPLICATE KEY IGNORE;

[turk55]

Originally Posted by bashondegek

Just try it with queries.
Something like this will do the job;

INSERT INTO database2.table_name
SELECT * FROM database1.table_name
ON DUPLICATE KEY IGNORE;

Sure, if you don’t mind data loss.

[bashondegek]

Originally Posted by turk55

Sure, if you don’t mind data loss.

Well, you shouldn't lose data since it don't delete.
probably a bunch of duplicates.

There are other ways to do this, but it isn't as simple as press a button and go.

[turk55]

Originally Posted by bashondegek

Well, you shouldn't lose data since it don't delete.
probably a bunch of duplicates.

Nope, you are merging 2 separate databases into a single one. The only stuff that could be duplicate are names, whether it be account usernames or character names.

All other data is unique aside from their identifier.

When I have 2 databases, both identifiers starting with the value of 1, the data in them are unique in both cases except that they both have the identifier value of 1.

In case of a database merge, when you start skipping records because 2 records have the same identifier, you are basically saying to not insert the unique data from one database.

[bashondegek]

Originally Posted by turk55

Nope, you are merging 2 separate databases into a single one. The only stuff that could be duplicate are names, whether it be account usernames or character names.

All other data is unique aside from their identifier.

When I have 2 databases, both identifiers starting with the value of 1, the data in them are unique in both cases except that they both have the identifier value of 1.

In case of a database merge, when you start skipping records because 2 records have the same identifier, you are basically saying to not insert the unique data from one database.

Ahh, i now understand what you mean.
Yep, you are right, haha.