SQL Server Performance Forum – Threads Archive

copy data from two database

hi all,
I have one database qlns and qlnsluu, each database have one table hoso with the same definition. Now I want to insert some record from hoso of qlns to hoso of qlnsluu. could any one tell me the sql statement.
thanks.

1 Use DTS
2 Use query Insert into hoso.dbo.qlnsluu(columns)
Select columns from hoso.dbo.qlns Madhivanan Failing to plan is Planning to fail

Madhivanan, I think you swapped the database names and table names in that query: INSERT INTO qlnsluu.dbo.hoso (<columns&gt<img src=’/community/emoticons/emotion-5.gif’ alt=’

‘ /> SELECT <columns> FROM qlns.dbo.hoso

Link server is a antoher possibility. but Query is the best way —————————————-
http://dineshasanka.blogspot.com/

quote:Originally posted by dineshasanka Link server is a antoher possibility. but Query is the best way —————————————-
http://dineshasanka.blogspot.com/

Linked Server is necessary only if the db resides in other Server. Otherwise no need for Linked Server Adriaan, Questioner says
Now I want to insert some record from hoso of qlns to hoso of qlnsluu.
So copying is from hoso of qlns to hoso of qlnsluu. So the target is hoso of qlnsluu
Am I missing anything? Madhivanan Failing to plan is Planning to fail

Madhivanan, your query copies data from table dbo.qlns to table dbo.qlnsluu in the same database, hoso. The question was about two different databases, qlns and qlnsluu, which both have a table dbo.hoso, and how to copy data from one database to the other.

<blockquote id="quote">quote:<hr height="1" noshade id="quote">Originally posted by Adriaan Madhivanan, your query copies data from table dbo.qlns to table dbo.qlnsluu in the same database, hoso. The question was about two different databases, qlns and qlnsluu, which both have a table dbo.hoso, and how to copy data from one database to the other. <hr height="1" noshade id="quote"></blockquote id="quote"> Thanks. I forget to check the Database Name [<img src=’/community/emoticons/emotion-1.gif’ alt=’

‘ />] Madhivanan Failing to plan is Planning to fail

]]>