GUIDE How to migrate your ep6DB to EP7DB With out loosing your inventory item I also include a fresh db all you need to do is migrate the data base table column's
STEP 1: Restore And Re-name Your old RanGame1 Data Base to RanGame1_ep6
STEP 2: Restore the data base bak file that i included My dataBase is back up is mssql2005 and mssql2008 RanOnline_EP7_FRESH_DB_2005_and_2008_BACKUP.7z
STEP 3: Now you have to modify the primary key in ChaInfo in RanGame1(THE DATA BASE THAT I INCLUDED IN STEP 2) of your new fresh ep7 Data Base so that the data on the columns to be copied on your old database will be accepted by the new database.
3.1): In Your Object Explorer Locate RanGame1 expand or click the (+) sign.
3.2): after expanding RanGame1 find Table and expand again or click the (+) sign.
3.3): then locate Chainfo
Right click on ChaInfo
Design
and look for the ChaNum Column <<<This is the primary key
then look for Identify Specification
Set it to NO
then save table
it should look like this
STEP 4: EXCUTE THIS INTO YOUR NEW QUERY AFTER EXECUTING THIS THEN YOU SEE SUCCESS THEN THE DATA BASE MIGRATION IS DONE BUT IT IS NOT YET FINISH.. YOU MUST FOLLOW THE FINAL STEP
Code:USE RanGame1 INSERT INTO ChaInfo ( chanum, SGNum, UserNum, 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, 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 RanGame1_ep6.dbo.chainfo
STEP 5: Now you have to RE-modify the primary key in ChaInfo in RanGame1(THE DATA BASE THAT YOU MODIFIED IN STEP 3)
5.1): In Your Object Explorer Locate RanGame1 expand or click the (+) sign.
5.2): after expanding RanGame1 find Table and expand again or click the (+) sign.
5.3): then locate Chainfo
Right click on ChaInfo
Design
and look for the ChaNum Column <<<This is the primary key
then look for Identify Specification
Set it to YES
then save table
it should look like this
then it's now done...
about the RanShop and RanUser just use your ep6 there is no files that need to be modified.. ONLY THE RanGame1 AND RanLog Are important.... about the RanLog Thing just Restore my RanLog that i include in the data base...
if you have question feel free to ask.. me
just read my whole post.. before asking question
NOTE : IF YOU ENCOUNTER THIS ERROR
Originally Posted by dev02
finalyy yrah gonna try this..
---------- Post added at 04:37 PM ---------- Previous post was at 03:36 PM ----------
I got error on this one
see:
try this.. this should fix your problem..
![[Guide] How to migrate your OLD ep6DB to EP7DB](http://ragezone.com/hyper728.png)
