AciDCooL

Hey CDawg, I already started scripting something together. Since I was reading up on databases and combining two is a big no no. And it's not discouragement since I thrive on problems like these I was just wondering if I was going in the right direction. I have two semi compatible sides so writing something around pdump is my best and fastest route. Thanks for the headsup!

Heya Guys, I have been fiddling with this question, on how to merge two databases. Because I want to merge one server with another. Is there even a way to merge two distinct databases? And with this merge i mean only auth and characters since world is identical anyway. The options I researched are: - NULL all the primairy key's so auto increment will do its job, but there are so many primary keys that i'm not sure that this is even possible. Since removing the keys from say character-aura would mean that the second row correspond to a totally different user. I'm a bit lost with this one. - Export all characters with pdump, since there are more then 300 accounts im not sure this is the best use of my time. If any dba guru or code monkey could step up and give me a hint in the right direction, this will be sincerely appreciated.

it's AuctionHouseBot.Items.ItemLevel.Max = 199