BƯỚC 1: Restore và đổi tên DataBase RanGame1 cũ thành RanGame1_ep6

BƯỚC 2: Restore DataBase bak ở trong thư mục backup mssql2005 và mssql2008. Nếu dùng sql 2k5 thì restone db trong thư mục mssql2005, nếu dùng sql2k8 thì trong thư mục còn lại



BƯỚC 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


BƯỚC 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


BƯỚC 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


try this.. this should fix your problem..

âsasas

hơi khó hiểu ???????????????