ConquerDatabaseHandler

03/15/2021 06:16 lpf333#1
i want Looking for a merge database tool

Dear gods, who can share：p：p：p
03/15/2021 09:32 bashondegek#2
What kind of 'merge' tool are you looking for?
03/15/2021 10:11 lpf333#3
Quote:
Originally Posted by bashondegek View Post
What kind of 'merge' tool are you looking for?

Merge two databases into one:)
03/15/2021 13:35 bashondegek#4
Quote:
Originally Posted by lpf333 View Post
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.
03/16/2021 05:54 lpf333#5
Quote:
Originally Posted by bashondegek View Post
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
;)
03/16/2021 09:07 bashondegek#6
Quote:
Originally Posted by lpf333 View Post
All tables and fields are the same. I need a tool
;)
Just try it with queries.
Something like this will do the job;

Code:
INSERT INTO database2.table_name
SELECT * FROM database1.table_name
ON DUPLICATE KEY IGNORE;
03/19/2021 09:03 turk55#7
Quote:
Originally Posted by bashondegek View Post
Just try it with queries.
Something like this will do the job;

Code:
INSERT INTO database2.table_name
SELECT * FROM database1.table_name
ON DUPLICATE KEY IGNORE;
Sure, if you don’t mind data loss.
03/19/2021 16:31 bashondegek#8
Quote:
Originally Posted by turk55 View Post
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.
03/19/2021 19:08 turk55#9
Quote:
Originally Posted by bashondegek View Post
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.
03/19/2021 23:29 bashondegek#10
Quote:
Originally Posted by turk55 View Post
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.