Query migrador

[LucasHZ]

tem a mesma funcionalidade deste [Somente membros podem ver os links. ]

DECLARE 
    @Conta varchar(10), 
    @contador int
     
select @contador = 0
 
DECLARE LISTA CURSOR LOCAL FOR 


SELECT memb___id FROM MuOnline2.dbo.MEMB_INFO


OPEN LISTA 


FETCH NEXT FROM LISTA INTO @Conta 


WHILE @@FETCH_STATUS = 0 


begin 
if (SELECT migrado FROM MuOnline2.dbo.MEMB_INFO where memb___id=@Conta) = 0 
begin
 select @contador = @contador + 1
 --MIGRA CONTA
 INSERT INTO MuOnline.dbo.MEMB_INFO (memb___id,memb__pwd,memb_name,mail_addr,fpas_ques,fpas_answ,sno__numb,bloc_code,ctl1_code,post_code,addr_info,tel__numb,phon_numb,addr_deta,mail_chek,cash,vip,datebegin,dateend,dateEndInteger) SELECT memb___id,memb__pwd,memb_name,mail_addr,fpas_ques,fpas_answ,sno__numb,bloc_code,ctl1_code,post_code,addr_info,tel__numb,phon_numb,addr_deta,mail_chek,cash,vip,datebegin,dateend,dateEndInteger from MuOnline2.dbo.MEMB_INFO where memb___id = @Conta
 --CHARACTER
 INSERT INTO MuOnline.dbo.AccountCharacter (Id,GameID1,GameID2,GameID3,GameID4,GameID5,GameIDC,MoveCnt) SELECT Id,GameID1,GameID2,GameID3,GameID4,GameID5,GameIDC,MoveCnt FROM MuOnline2.dbo.AccountCharacter WHERE Id = @Conta
 INSERT INTO MuOnline.dbo.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, Leadership, ChatLimitTime, FruitPoint, Resets) SELECT 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, Leadership, ChatLimitTime, FruitPoint, Resets from MuOnline2.dbo.character where AccountID  = @Conta
--MIGRAR BAUS
 INSERT INTO MuOnline.dbo.warehouse(AccountID, Items, Money, EndUseDate, DbVersion, pw) SELECT AccountID, Items, Money, EndUseDate, DbVersion, pw from [MuOnline2].[dbo].[warehouse] where AccountID  = @Conta
--MIGRAR BAUS EXTRAS
 INSERT INTO MuOnline.dbo.Extwarehouse(VaultID, AccountID, Items, EndUseDate, DbVersion, Money, pw) SELECT VaultID, AccountID, Items, EndUseDate, DbVersion, Money, pw from MuOnline2.dbo.Extwarehouse where AccountID  = @Conta
 UPDATE MuOnline2.dbo.MEMB_INFO SET migrado = 1 WHERE memb___id = @Conta
end


FETCH NEXT FROM LISTA INTO @Conta 
end 
CLOSE LISTA 
DEALLOCATE LISTA 
print @contador