Moving Vsro accounts to Tsro.

[keppel22]

Hello, Epvp.

I wonder if I can pass the accounts of my old server to my new server?
I will explain better.
I changed my server from VSRO to TSRO, but would like to keep all the accounts created by players from my previous server.
I can do that?
any help?

[flozz]

Originally Posted by keppel22

Hello, Epvp.

I wonder if I can pass the accounts of my old server to my new server?
I will explain better.
I changed my server from VSRO to TSRO, but would like to keep all the accounts created by players from my previous server.
I can do that?
any help?

Only accounts or chars too?

[keppel22]

Both Accounts and chars..

[neisser1]

also I have the same question. Possible?

[A new hope]

It's possible, not that hard, but takes a few hours.

[Kape7]

It's complicated, specially with the items, I think the TSRO and VSRO item IDs doesn't match.

[ZiCo*]

Originally Posted by A new hope

It's possible, not that hard, but takes a few hours.

I think you never had a close look.

[A new hope]

Originally Posted by Synx7

It's complicated, specially with the items, I think the TSRO and VSRO item IDs doesn't match.

can be done with a simple query.

[royalblade]

Yeah its actually not difficult at all

Hit me up on skype:Akasch93;

PS: Inside the CSRO db theres a stored procedure to move accounts,chars,items etc. It might be useable to a certain extent.

[IceAmStiel]

Difficulty depends on whether the TSRO DB contains valid characters or not. If it's a clean database you want to move the accounts + characters to, it won't be time-consuming at all.
But if it does contain characters and accounts you want to keep, you'd have to loop through the vsro.dbo._Items table until the MAX(ID64) of tsro.dbo._Items is reached (afterwards identity insert), check if the RefItemID has the same CodeName128 at both databases, recreate the Item in the tsro.dbo._Items table and replace the old ID64 with the new ID64 at the vsro DB.

First case can be theoretically accomplished manually, second one definitely not. But if you once finished a proper procedure for the second case that does the job right, you will only have to wait until the (usually) millions of records of _Items got ran through.

[neisser1]

and change the account + the char?, any item, guild nothing but char + lvl?