Migrating Database

[dev02]

Hi pro devs/masters..
Could you release a full guide migrating Ep6 to Ep7 database..I found some servers already done upgrading their server so kindly teach us how...Thanks...

[MentaL]

[raverking]

First Restore and rename your databases

Old Database( ep4 - ep5)
Rangame2
RanUser2

New Episode 6 Database
Rangame1
RanGame1

Now we have to modify something on our New Ep6 database so that the data on the columns to be copied on our old database will be accepted by the new database.

Right click on ChaInfo
Design
and look for the ChaNum Column
then look for Identify Specification
Set it to NO
then save table
(refres with the screenshot)

after that

heres the script that we will use to copy the datas on the columns =)

now take note to copy all the important columns , just delete or add if the columns does or does not exist on your table =)

then execute this query
Quote:
use rangame1

insert into chainfo
(chanum,
SGNum,
UserNum,
GuNum,
GuPosition,
ChaName,
ChaGuName,
ChaTribe,
ChaClass,
ChaSchool,
ChaHair,
ChaFace,
ChaLiving,
ChaLevel,
ChaMoney,
ChaPower,
ChaStrong,
ChaStrength,
ChaSpirit,
ChaDex,
ChaIntel,
ChaStRemain,
ChaExp,
ChaViewRange,
ChaHP,
ChaMP,
ChaStartMap,
ChaStartGate,
ChaPosX,
ChaPosY,
ChaPosZ,
ChaSaveMap,
ChaSavePosX,
ChaSavePosY,
ChaSavePosZ,
ChaReturnMap,
ChaReturnPosX,
ChaReturnPosY,
ChaReturnPosZ,
ChaBright,
ChaAttackP,
ChaDefenseP,
ChaFightA,
ChaShootA,
ChaSP,
ChaPK,
ChaSkillPoint,
ChaInvenLine,
ChaDeleted,
ChaOnline,
ChaCreateDate,
ChaDeletedDate,
ChaStorage2,
ChaStorage3,
ChaStorage4,
ChaGuSecede,
ChaQuest,
ChaSkills,
ChaSkillSlot,
ChaActionSlot,
ChaPutOnItems,
ChaInven,
ChaSex,
ChaReborn,
ChaHairColor

)

select

ChaNum,
SGNum,
UserNum,
GuNum,
GuPosition,
ChaName,
ChaGuName,
ChaTribe,
ChaClass,
ChaSchool,
ChaHair,
ChaFace,
ChaLiving,
ChaLevel,
ChaMoney,
ChaPower,
ChaStrong,
ChaStrength,
ChaSpirit,
ChaDex,
ChaIntel,
ChaStRemain,
ChaExp,
ChaViewRange,
ChaHP,
ChaMP,
ChaStartMap,
ChaStartGate,
ChaPosX,
ChaPosY,
ChaPosZ,
ChaSaveMap,
ChaSavePosX,
ChaSavePosY,
ChaSavePosZ,
ChaReturnMap,
ChaReturnPosX,
ChaReturnPosY,
ChaReturnPosZ,
ChaBright,
ChaAttackP,
ChaDefenseP,
ChaFightA,
ChaShootA,
ChaSP,
ChaPK,
ChaSkillPoint,
ChaInvenLine,
ChaDeleted,
ChaOnline,
ChaCreateDate,
ChaDeletedDate,
ChaStorage2,
ChaStorage3,
ChaStorage4,
ChaGuSecede,
ChaQuest,
ChaSkills,
ChaSkillSlot,
ChaActionSlot,
ChaPutOnItems,
ChaInven,
ChaSex,
ChaReborn,
ChaHairColor

from rangame2.dbo.chainfo
after the copying of datas is done

we have to remodify the ChaNum again to set it to its default option

Right click on ChaInfo
Design
and look for the ChaNum Column
then look for Identify Specification
Set it to YES
then save table


there you go.. =)

it will be just the same with the ranuser, just modify the script with the columns you want to copy =)

i forgot to truncate the ep6 database, just execute this query first =)

Quote:
use rangame1
truncate table "chafriend"
truncate table "chafriendbackup"
truncate table "chainfo"
truncate table "chanameinfo"
truncate table "gdcn_filterword"
truncate table "gdcn_tgy_active_user"
truncate table "guildAlliance"
truncate table "guildinfo"
truncate table "guildregion"
truncate table "itemcustomize"
truncate table "logpartymatch"
truncate table "petinfo"
truncate table "petinven"
truncate table "petstyleflag"
truncate table "pettypeflag"
truncate table "userinven"
truncate table "vehicleInfo"

use ranlog


truncate table "hackprogramlist"
truncate table "itemlist"
truncate table "logaction"
truncate table "logexchangeflag"
truncate table "loghackprogram"
truncate table "logitemexchange"
truncate table "logitemmax"
truncate table "logitemrandom"
truncate table "logmaketype"
truncate table "logpetaction"
truncate table "logpetactionflag"
truncate table "logserverstate"
truncate table "logshoppurchase"
truncate table "logvehicleaction"
truncate table "logvehicleactionflag"
truncate table "shopitemmap"
truncate table "shoppurchase"
truncate table "shoppurflag"
truncate table "skilllist"


use ranshop

truncate table "award"
truncate table "awarduserlist"
truncate table "dtproperties"
truncate table "itemlisttemp"
truncate table "logshoppurchase"
truncate table "masteradm"
truncate table "shopitemmap"
truncate table "shopitemtype"
truncate table "shoppurchase"
truncate table "shoppurflag"




use ranuser

truncate table "accountinfo"
truncate table "addattlog"
truncate table "blockaddress"
truncate table "checkid"
truncate table "daumloggametime"
truncate table "daumloglogin"
truncate table "daumuserinfo"
truncate table "fulluserinfo"
truncate table "htlog"
truncate table "ipinfo"
truncate table "lockzblog"
truncate table "logaction"
truncate table "loggametime"
truncate table "loggmcmd"
truncate table "loglogin"
truncate table "logserverstate"
truncate table "lvlist"
truncate table "manage"
truncate table "newcheckid"
truncate table "newtype"
truncate table "shopgoumaiinfo"
truncate table "shophjf"
truncate table "statgametime"
truncate table "statlogin"
truncate table "user_tjj"
truncate table "userinfo"
truncate table "userpoint"
truncate table "userpointlog"
truncate table "web"
truncate table "web_admin"
truncate table "web_download"
truncate table "web_links"
truncate table "web_mail"
truncate table "web_mail_store"
truncate table "web_news"
truncate table "web_servers"
truncate table "web_siteck"
truncate table "web_siteckbak"
truncate table "xf_tjlog"
truncate table "xy_sendzblog"
truncate table "xy_sskilllog"
truncate table "xy_zbdhlog"
truncate table "zbsjlog"

from: jonluis thread, read faq's

[dev02]

I got stuck on these one
Right click on ChaInfo
Design
and look for the ChaNum Column
then look for Identify Specification
Set it to NO
then save table

It wont save...