[meta] How to best merge in another site into Ask.SSC?
Hello, as some of you might know, there is another SQLServer Q&A site hosted at stack exchange, [
ask.sqlteam.com], and they would like to merge the two communities. The merge is planned for the beginning of the next week, and we would like to get some feedback on how to best do that so existing users common to both sites can be merged properly. Also, if you have any technical concerns about the merge, please share them here, and I'll try to do my best to answer them. EDIT: The merge will be complected in the next few days, I've noticed that one of the biggest concerns is about tag names. Would like to hear your opinion about which sqlteam tags have to be renamed during the merge. :
Wonderful idea. Welcome
ask.sqlteam.com members!! And Thanks for the heads up =) your really surprised us with the last migration! Edit: I see some users that are members in both sites. What are you going to do with them? Add thier karma and merge them in to a single user?
I'm probably biased, but I would like to see us maintain our versions of tags rather than others, eg 'sql-server-2005', over 'sql-2005'. Not being a duplicated user, I have no preference for handling user accounts, but I guess rep/karma accrued elsewhere should be added? Questions - just throw them in - if there are any dupes then the mods can close. (sorry guys speaking on behalf of all mods there....)
I believe the best approach to doing this would be to set up another OSQA site, temporarily. Let the mods here log in to that site, and clean up tags (so we could do with a rename tag function for that). EDIT -> actually, we will probably need merge tags too... After that process is complete, merging the data from one to the other should be a lot simpler. I'm not sure how the question IDs work, but I'm hoping that you guys will have a process for handling those. Karma should be added together from both sites, as should repeatable badges. Non-repeatable badges should not be duplicated i.e. something akin to -> DELETE temposqa.badgeawards FROM temposqa.badgeawards INNER JOIN askssc.badgeawards ON temposqa.badgeawards.badgeID = askssc.badgeawards.badgeID AND temposqa.badgeawards.userOpenID = askssc.badgeawards.userOpenID INNER JOIN temposqa.badges ON temposqa.badgeawards.badgeID = temposqa.badges WHERE temposqa.badges.repeatable = 0 When that process is complete, I think we'll be merged and happy...
Yeah, what he said (points to all other answers)! seriously though I agree with: merge tags to be 'ours' if duplicated sum rep for users in both camps how about creating a generic "SQLTeam" user that gets 1 gabillion questions transferred from all 1rep users at SQLTeam?