NET CAPITAL
Welcome To NET CAPITAL, Please Register to join forum

NET CAPITAL

NET CAPITAL
 
HomeHome  PortalPortal  RegisterRegister  Log inLog in  

Share | 
 

 Re: [Share]Ep6 Database & Migrate your ep4 -ep5 dabatase to Ep6 S2

View previous topic View next topic Go down 
AuthorMessage
[ADMIN]Roy
Admin
Admin
avatar

Posts : 93
WDM-Points : 266
Join date : 2009-03-24

PostSubject: Re: [Share]Ep6 Database & Migrate your ep4 -ep5 dabatase to Ep6 S2   Tue Jun 15, 2010 4:03 pm

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

Spoiler:
 

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 =)

Spoiler:
 
Back to top Go down
http://netcapital.darkbb.com
 

Re: [Share]Ep6 Database & Migrate your ep4 -ep5 dabatase to Ep6 S2

View previous topic View next topic Back to top 
Page 1 of 1

Permissions in this forum:You cannot reply to topics in this forum
NET CAPITAL :: RELEASE SECTION :: Server Releases-