DB migration (Only for MD5 DB Version)

[chocman1]

Im post this mod guide from http://forum.ragezone.com/f196/guide...-story-152800/.
Credit's for point777 and me

If you need move accounts from another version like 0.99.6X(MD5) to another version like 1.02K(MD5) download attached guide, this have pictures for reference ^^

You need use Acrobat Reader to open the guide :kenshin2:

[MentaL]

[Tchekler]

Tanks :) i search this guide !!! :) really good !

[DiliBau]

i think las3r allready made a video "tutorial" for this:busted_co
don`t exactly remember the link but i still have the .avi fil in my computer ^_^

[djspankman]

why don't ya share that with us then ;)

[TheJAZZman]

This is great 10/10 ....tested, worked 1.02Q to 1.02N :)

Note that when moving items from one version to another, I'm thinking the hex codes are not always identical, as some items are lost. However, the accounts are in tact, all stats, user info, inventory (except a few items, I'm thinking that are just different). Anyway, great job, thanks for sharing. A true asset to RZ!!

[themad]

I haven't used a 5databased version..but my guess is that it would be better to move them all to 1 DB (MuOnline)

Which would happen quite easy (if working the same way as before)
Change the ODBC databases selected to MuOnline, export all stored procedures from all databases and execute them in the "Muonline" database, then use the method specified above (must change it a bit) and you should have np with it. (has not been tested - but logic tells it should work)

[bypanter]

Thank You

[chocman1]

Guide update: can be downloaded and have pictures.

[bextbox]

Just now i just tried the MuOnline export option and I got these error message, what could be the possible reasons for the error?

Execute the transfer with the TransferProvider. (Error)
Messages
ERROR : errorCode=-1071636471 description=SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "陣容規格的無效字元值".
helpFile=dtsmsg.rll helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC} (Microsoft.SqlServer.DtsTransferProvider)

For help, click: http://go.microsoft.com/fwlink?ProdN...r&LinkId=20476


- Copying to [dbo].[vCharacterPreview] (Error)
Messages
• ERROR : errorCode=-1071636471 description=SSIS Error Code DTS_E_OLEDBERROR. An OLE DB error has occurred. Error code: 0x80004005.
An OLE DB record is available. Source: "Microsoft SQL Native Client" Hresult: 0x80004005 Description: "陣容規格的無效字元值".
helpFile=dtsmsg.rll helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}

For help, click: http://go.microsoft.com/fwlink?ProdN...r&LinkId=20476

• ERROR : errorCode=-1071607780 description=There was an error with input column "Inventory" (52) on input "OLE DB Destination Input" (29). The column status returned was: "The value could not be converted because of a potential loss of data.".
helpFile=dtsmsg.rll helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}

For help, click: http://go.microsoft.com/fwlink?ProdN...r&LinkId=20476

• ERROR : errorCode=-1071607767 description=SSIS Error Code DTS_E_INDUCEDTRANSFORMFAILUREONERROR. The "input "OLE DB Destination Input" (29)" failed because error code 0xC0209077 occurred, and the error row disposition on "input "OLE DB Destination Input" (29)" specifies failure on error. An error occurred on the specified object of the specified component. There may be error messages posted before this with more information about the failure.
helpFile=dtsmsg.rll helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}

For help, click: http://go.microsoft.com/fwlink?ProdN...r&LinkId=20476

• ERROR : errorCode=-1073450974 description=SSIS Error Code DTS_E_PROCESSINPUTFAILED. The ProcessInput method on component "OLE DB Destination" (2) failed with error code 0xC0209029. The identified component returned an error from the ProcessInput method. The error is specific to the component, but the error is fatal and will cause the Data Flow task to stop running. There may be error messages posted before this with more information about the failure.
helpFile=dtsmsg.rll helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}

For help, click: http://go.microsoft.com/fwlink?ProdN...r&LinkId=20476

• ERROR : errorCode=-1073450975 description=SSIS Error Code DTS_E_THREADFAILED. Thread "WorkThread0" has exited with error code 0xC0209029. There may be error messages posted before this with more information on why the thread has exited.
helpFile=dtsmsg.rll helpContext=0 idofInterfaceWithError={8BDFE893-E9D8-4D23-9739-DA807BCDC2AC}

[=Ady=]

how to transfer guilds from old db to new db?

[=Ady=]

can i use the same codes to transfer acc,char,items,guild? from 99.88T (1.02n client) to 1.00.16 ( 1.04h) ?


and what command do i need to use for guilds transfer?