Printable View
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?
Quote:
Originally Posted by mikkomoley
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.Quote:
Originally Posted by pierr32
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.
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.Quote:
Originally Posted by emi
Even so, changing it will consequently result in extreme data loss.
How would it cause data loss? I fail to see your logic.
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?