Copy data from one SQL Server database table to the other
Posted
by lucky
on Stack Overflow
See other posts from Stack Overflow
or by lucky
Published on 2010-05-28T07:04:54Z
Indexed on
2010/05/28
7:31 UTC
Read the original article
Hit count: 240
Filed under:
sql-server
I don't know how to copy table data from
one server -> database -> table
TO
other sever -> database -> table.
If it is with in the same server and different databases, i have used the following
SELECT * INTO DB1..TBL1 FROM DB2..TBL1 (to copy with table structure and data)
INSERT INTO DB1..TBL1(F1, F2) SELECT F1, F2 FROM DB2..TBL1 (copy only data)
Now my question is copy the data from SERVER1 --> DB1--> TBL1 to SERVER2 --> DB2 -->TBL2
© Stack Overflow or respective owner
