How do i transfer accounts to new database?

[afnan123]

How do i transfer accounts to new database? Hi guys, i've been trying to to transfer the accounts on my database to a new database, i was hoping i can find out when i need to copy from there. i need all accounts charactres in my new database, any help wuld be appreciate it. thanks in advance.

[MentaL]

[medotarek]

select all accounts and paste in new db :) xD and same way to other tables

[afnan123]

select all accounts and paste in new db :) xD and same way to other tables

Che accounts?can you tell me, what other tables i need to copy in order for everyone's characters to remain as well as table

[suhil1]

dbo.Account dbo.login dbo.character if u want items to dbo.characteritem

[Dave]

Account, AccountItem, Character, CharacterItem, CharacterEquipmentSlot, Friend, Login.

[afnan123]

Account, AccountItem, Character, CharacterItem, CharacterEquipmentSlot, Friend, Login.

Thanks Dave! youre the best btw i have question i am using msql 2008 why cant i see all registered users in my dbo,account? like it wouldnt show all the rows like i can only see up to 213 accounts in database, not 419. or is there a way for me to just copy the entire dbo account without having to highlight every account names?

[afnan123]

BUMP! please help, how do i copy more than 200 + accounts in mSQl 2008 database.

[Dave]

Maybe this will help you out.

[afnan123]

Maybe this will help you out.

Thanks again Dave, appreciate your help. by any chance do you still have this and is it anti-sql?