Code:
Insert Into AccountCharacter (Id, GameID1, GameID2, GameID3, GameID4, GameID5, GameIDC)
Select AccountCharacter2.Id, AccountCharacter2.GameID1, AccountCharacter2.GameID2, AccountCharacter2.GameID3, AccountCharacter2.GameID4, AccountCharacter2.GameID5, AccountCharacter2.GameIDC from AccountCharacter2
GO
Insert Into Character (AccountID, Name, cLevel, LevelUpPoint, Class, Experience, Strength, Dexterity,Vitality, Energy, Inventory, MagicList, Money, Life, MaxLife, Mana, MaxMana, MapNumber, MapPosX, MapPosY, MapDir, PkCount, PkLevel, PkTime, MDate, LDate, CtlCode, DbVersion, Quest)
Select Character2.AccountID, Character2.Name, Character2.cLevel, Character2.LevelUpPoint, Character2.Class, Character2.Experience, Character2.Strength, Character2.Dexterity,Character2.Vitality, Character2.Energy, Character2.Inventory, Character2.MagicList, Character2.Money, Character2.Life, Character2.MaxLife, Character2.Mana, Character2.MaxMana, Character2.MapNumber, Character2.MapPosX, Character2.MapPosY, Character2.MapDir, Character2.PkCount, Character2.PkLevel, Character2.PkTime, Character2.MDate, Character2.LDate, Character2.CtlCode, Character2.DbVersion, Character2.Quest from Character2
GO
Insert Into Guild ( G_Name, G_Mark, G_Score, G_Master, G_Count, G_Notice)
Select Guild2.G_Name, Guild2.G_Mark, Guild2.G_Score, Guild2.G_Master, Guild2.G_Count, Guild2.G_Notice from Guild2
GO
Insert Into GuildMember ( Name, G_Name, G_Level)
Select GuildMember2.Name, GuildMember2.G_Name, GuildMember2.G_Level from GuildMember2
GO
Insert Into MEMB_INFO ( memb___id, memb__pwd, memb_name, sno__numb, post_code, addr_info, addr_deta, tel__numb, phon_numb, mail_addr, fpas_ques, fpas_answ, job__code, appl_days, modi_days, out__days, true_days, mail_chek, bloc_code, ctl1_code)
Select MEMB_INFO2.memb___id, MEMB_INFO2.memb__pwd, MEMB_INFO2.memb_name, MEMB_INFO2.sno__numb, MEMB_INFO2.post_code, MEMB_INFO2.addr_info, MEMB_INFO2.addr_deta, MEMB_INFO2.tel__numb, MEMB_INFO2.phon_numb, MEMB_INFO2.mail_addr, MEMB_INFO2.fpas_ques, MEMB_INFO2.fpas_answ, MEMB_INFO2.job__code, MEMB_INFO2.appl_days, MEMB_INFO2.modi_days, MEMB_INFO2.out__days, MEMB_INFO2.true_days, MEMB_INFO2.mail_chek, MEMB_INFO2.bloc_code, MEMB_INFO2.ctl1_code from MEMB_INFO2
GO
Insert Into MEMB_STAT ( memb___id, ConnectStat, ServerName, IP, ConnectTM, DisConnectTM)
Select MEMB_STAT2.memb___id, MEMB_STAT2.ConnectStat, MEMB_STAT2.ServerName, MEMB_STAT2.IP, MEMB_STAT2.ConnectTM, MEMB_STAT2.DisConnectTM from MEMB_STAT2
GO
Insert Into OptionData (Name, Skillkey, GameOption, Qkey, Wkey, Ekey, ChatWindow)
Select OptionData2.Name, OptionData2.Skillkey, OptionData2.GameOption, OptionData2.Qkey, OptionData2.Wkey, OptionData2.Ekey, OptionData2.ChatWindow from OptionData2
GO
Insert Into VI_CURR_INFO ( ends_days, chek_code, used_time, memb___id, memb_name, memb_guid, sno__numb, Bill_Section, Bill_Value, Bill_Hour,Surplus_Point, Surplus_Minute, Increase_Days)
Select VI_CURR_INFO2.ends_days, VI_CURR_INFO2.chek_code, VI_CURR_INFO2.used_time, VI_CURR_INFO2.memb___id, VI_CURR_INFO2.memb_name, VI_CURR_INFO2.memb_guid, VI_CURR_INFO2.sno__numb, VI_CURR_INFO2.Bill_Section, VI_CURR_INFO2.Bill_Value, VI_CURR_INFO2.Bill_Hour, VI_CURR_INFO2.Surplus_Point, VI_CURR_INFO2.Surplus_Minute, VI_CURR_INFO2.Increase_Days from VI_CURR_INFO2
GO
Insert Into warehouse ( AccountID, Items, Money, EndUseDate, DbVersion, pw)
Select warehouse2.AccountID, warehouse2.Items, warehouse2.Money, warehouse2.EndUseDate, warehouse2.DbVersion, warehouse2.pw from warehouse2
GO
And ready we have db totally functional for the 1.1E