Buenas chicos tengo un problema tengo un server s2 con los files de emu louis, y los 2 server de distintas datas pero quiero pasar las cuentas del 2°do Server al Server principal solo que algunos usuarios no me hicieron caso de no colocar id y pj con el mismo nick del server principal y ahora cuando ejecuto el script sql para trasladar los datos del 2do server al principal tengo este problema de duplicidad y bueno ya imagino que deben saber que pasa, alguna sugerencia que pueda hacer para forzar o al menos omitir los registro que se detecten como duplicados al server principal???
Insert Into [MuOnline].[dbo].AccountCharacter (Id, GameID1, GameID2, GameID3, GameID4, GameID5, GameIDC)
Select DISTINCT [MuOnline2].[dbo].AccountCharacter.Id, [MuOnline2].[dbo].AccountCharacter.GameID1, [MuOnline2].[dbo].AccountCharacter.GameID2, [MuOnline2].[dbo].AccountCharacter.GameID3, [MuOnline2].[dbo].AccountCharacter.GameID4, [MuOnline2].[dbo].AccountCharacter.GameID5, [MuOnline2].[dbo].AccountCharacter.GameIDC from [MuOnline2].[dbo].AccountCharacter
GO
Insert Into [MuOnline].[dbo].Character (AccountID, Name, cLevel, ResetCount, MasterResetCount, 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 DISTINCT [MuOnline2].[dbo].Character.AccountID, [MuOnline2].[dbo].Character.Name, [MuOnline2].[dbo].Character.cLevel, [MuOnline2].[dbo].Character.ResetCount, [MuOnline2].[dbo].Character.MasterResetCount, [MuOnline2].[dbo].Character.LevelUpPoint, [MuOnline2].[dbo].Character.Class, [MuOnline2].[dbo].Character.Experience, [MuOnline2].[dbo].Character.Strength, [MuOnline2].[dbo].Character.Dexterity,[MuOnline2].[dbo].Character.Vitality, [MuOnline2].[dbo].Character.Energy, [MuOnline2].[dbo].Character.Inventory, [MuOnline2].[dbo].Character.MagicList, [MuOnline2].[dbo].Character.Money, [MuOnline2].[dbo].Character.Life, [MuOnline2].[dbo].Character.MaxLife, [MuOnline2].[dbo].Character.Mana, [MuOnline2].[dbo].Character.MaxMana, [MuOnline2].[dbo].Character.MapNumber, [MuOnline2].[dbo].Character.MapPosX, [MuOnline2].[dbo].Character.MapPosY, [MuOnline2].[dbo].Character.MapDir, [MuOnline2].[dbo].Character.PkCount, [MuOnline2].[dbo].Character.PkLevel, [MuOnline2].[dbo].Character.PkTime, [MuOnline2].[dbo].Character.MDate, [MuOnline2].[dbo].Character.LDate, [MuOnline2].[dbo].Character.CtlCode, [MuOnline2].[dbo].Character.DbVersion, [MuOnline2].[dbo].Character.Quest from [MuOnline2].[dbo].Character
GO
Insert Into [MuOnline].[dbo].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, AccountLevel, AccountExpireDate, Lock)
Select DISTINCT [MuOnline2].[dbo].MEMB_INFO.memb___id, [MuOnline2].
[dbo].MEMB_INFO.memb__pwd, [MuOnline2].[dbo].MEMB_INFO.memb_name, [MuOnline2].
[dbo].MEMB_INFO.sno__numb, [MuOnline2].[dbo].MEMB_INFO.post_code, [MuOnline2].
[dbo].MEMB_INFO.addr_info, [MuOnline2].[dbo].MEMB_INFO.addr_deta, [MuOnline2].
[dbo].MEMB_INFO.tel__numb, [MuOnline2].[dbo].MEMB_INFO.phon_numb, [MuOnline2].
[dbo].MEMB_INFO.mail_addr, [MuOnline2].[dbo].MEMB_INFO.fpas_ques, [MuOnline2].
[dbo].MEMB_INFO.fpas_answ, [MuOnline2].[dbo].MEMB_INFO.job__code, [MuOnline2].
[dbo].MEMB_INFO.appl_days, [MuOnline2].[dbo].MEMB_INFO.modi_days, [MuOnline2].
[dbo].MEMB_INFO.out__days, [MuOnline2].[dbo].MEMB_INFO.true_days, [MuOnline2].
[dbo].MEMB_INFO.mail_chek, [MuOnline2].[dbo].MEMB_INFO.bloc_code, [MuOnline2].
[dbo].MEMB_INFO.ctl1_code, [MuOnline2].[dbo].MEMB_INFO.AccountLevel, [MuOnline2].
[dbo].MEMB_INFO.AccountExpireDate, [MuOnline2].[dbo].MEMB_INFO.Lock from [MuOnline2].[dbo].MEMB_INFO
GO
Insert Into [MuOnline].[dbo].OptionData (Name, Skillkey, GameOption, Qkey, Wkey, Ekey, ChatWindow, Rkey, QWERLevel )
Select DISTINCT [MuOnline2].[dbo].OptionData.Name, [MuOnline2].[dbo].OptionData.Skillkey, [MuOnline2].[dbo].OptionData.GameOption, [MuOnline2].[dbo].OptionData.Qkey, [MuOnline2].[dbo].OptionData.Wkey, [MuOnline2].[dbo].OptionData.Ekey, [MuOnline2].[dbo].OptionData.ChatWindow, [MuOnline2].[dbo].OptionData.Rkey, [MuOnline2].[dbo].OptionData.QWERLevel from [MuOnline2].[dbo].OptionData
GO
Insert Into [MuOnline].[dbo].warehouse ( AccountID, Items, Money, EndUseDate, DbVersion, pw)
Select DISTINCT [MuOnline2].[dbo].warehouse.AccountID, [MuOnline2].[dbo].warehouse.Items, [MuOnline2].[dbo].warehouse.Money, [MuOnline2].[dbo].warehouse.EndUseDate, [MuOnline2].[dbo].warehouse.DbVersion, [MuOnline2].[dbo].warehouse.pw from [MuOnline2].[dbo].warehouse
GO
Insert Into [MuOnline].[dbo].CashShopData ( AccountID, WCoinC, WCoinP, GoblinPoint, Ruud)
Select DISTINCT [MuOnline2].[dbo].CashShopData.AccountID, [MuOnline2].[dbo].CashShopData.WCoinC, [MuOnline2].[dbo].CashShopData.WCoinP, [MuOnline2].[dbo].CashShopData.GoblinPoint, [MuOnline2].[dbo].CashShopData.Ruud
from [MuOnline2].[dbo].CashShopData
GO
Home
TOP Ranking MU
Magichand
Fanpage
Tags
Login
Register
Topic: Migracion de Una Data a Otra (Visto 403 veces)
August 24, 2018, 04:29:17 PM
