Moving Rows USERDATA -> USERDATA

[HellFire]

trying to figure this out lately.

for example:

DB: lol
TABLE: USERDATA

i wanna move the contents of USERDATA to

DB: lol2
TABLE: USERDATA

by just copy and pasting rows i noticed it cant be done.
the strSkill strItem etc are encoded so it aint gonna work.

theres a query to do it just in 1 click.

like SELECT FROM * USERDATA INTO USERDATA.

i really dont know, never tryed this. and googling doesnt help me at al.


thanks

thanks twostars

i got it

INSERT INTO [KN_online]..USERDATA SELECT * FROM [OURKO]..USERDATA

really a usefull code

 

[Advocate]

INSERT INTO [KN_online]..USERDATA SELECT * FROM [OURKO]..USERDATA

this will not export all the info from one table to another not entirely alot of data from item ect.. will not move correctly.

another thing getting help from twostars is NOT advisable . unless you wish to put your entire dedicated server in jeopardy

 

[ZeroTears]

I got this problem before, i suggest you should move the tables that you have changef instead of the user informations data tables (like userdata,tb_user,accountchar,Skillshorcut,... a lot).

 

[cherry]

use lol
insert into userdata
select * from lol2.dbo.userdata



of course you must be logged in as sa or have authority over both databases.

 

[spamman]

select * into dbname.dbo.tablename from dbname2.dbo.tablename

That should work

 

[HellFire]

erhm the method of twostars works fine, whats the difference actualy?

 

[Chadlust]

Thanks Man .. u save my ass

 

[Aory]

what was the answer to this thread?