How merge Gamedb to other Gamedb
as the title said, we want to merge all gamedb to other gamedb also. we check the stored procedure to copy the multiple character to, but we don't want to touch it because we don't want to messed our database, anyone can give an advice to merge it properly without getting mess?
Re: How merge Gamedb to other Gamedb
Quote:
Originally Posted by
mikkomoley
as the title said, we want to merge all gamedb to other gamedb also. we check the stored procedure to copy the multiple character to, but we don't want to touch it because we don't want to messed our database, anyone can give an advice to merge it properly without getting mess?
Create in SQL GameDB2 and expotr ther current GameDB, and wor good work u need off manager SQL and copy GameDB and rename to GameDB2 then u copy the new GameDB2 do Data files in SQL and Run SQL.
:)
Re: How merge Gamedb to other Gamedb
Quote:
Originally Posted by
pierr32
Create in SQL GameDB2 and expotr ther current GameDB, and wor good work u need off manager SQL and copy GameDB and rename to GameDB2 then u copy the new GameDB2 do Data files in SQL and Run SQL.
:)
your instruction is not clear. i have 2 servers with 1 Account database and 2 Gamedb. i want to merge the gamedb to gamedb2 without messing the characters or the database.
Re: How merge Gamedb to other Gamedb
I think that first you need to change the char idx for all the chars in DB2 to be continued from the one in DB1,I like to believe that anything is possible but what you are trying to accomplish now give me headache just thinking of it,so good luck dude.
Re: How merge Gamedb to other Gamedb
This is a complex procedure and you should do everything verry carefully.Googling around will help you with this procedure.However I don't recommend it if you are a beginner in SQL procedures.
@Popa
What you are suggesting is leading into a mess in the database.Caracter_idx are randomly generated and they are primary keys in Gamedb and foreign keys in Account.
Changing those will lead into a chaos and loosing characters.
Re: How merge Gamedb to other Gamedb
Quote:
Originally Posted by
emi
This is a complex procedure and you should do everything verry carefully.Googling around will help you with this procedure.However I don't recommend it if you are a beginner in SQL procedures.
@Popa
What you are suggesting is leading into a mess in the database.Caracter_idx are randomly generated and they are primary keys in Gamedb and foreign keys in Account.
Changing those will lead into a chaos and loosing characters.
They are not randomly generated... Character ID's are calculated like so: account ID * 8 + slot.
Re: How merge Gamedb to other Gamedb
Even so, changing it will consequently result in extreme data loss.
Re: How merge Gamedb to other Gamedb
How would it cause data loss? I fail to see your logic.
Re: How merge Gamedb to other Gamedb
I think this is perfectly doable, but rather a pain in the butt.
You have to update every CharId related field to conserve the uniqueness of each entity. You could archieve this with a single query.
My advise: Back up everything before you do anything.
Mikko, did I undestand you right: You want to merge two gamedbs from different servers?