How to insert table values from one database to another database? [closed]

Question

I want a query to insert records from one table to another table in a different database if the destination table already exists, it should append the records at the end of the table.

Answer 1

How about this:

USE TargetDatabase GO  INSERT INTO dbo.TargetTable(field1, field2, field3)    SELECT field1, field2, field3      FROM SourceDatabase.dbo.SourceTable      WHERE (some condition) 

Answer 2

How to insert table values from one server/database to another database?

1 Creating Linked Servers {if needs} (SQL server 2008 R2 - 2012) http://technet.microsoft.com/en-us/library/ff772782.aspx#SSMSProcedure

2 configure the linked server to use Credentials a) http://technet.microsoft.com/es-es/library/ms189811(v=sql.105).aspx

EXEC sp_addlinkedsrvlogin 'NAMEOFLINKEDSERVER', 'false', null, 'REMOTEUSERNAME', 'REMOTEUSERPASSWORD'

-- CHECK SERVERS

SELECT * FROM sys.servers 

-- TEST LINKED SERVERS

EXEC sp_testlinkedserver N'NAMEOFLINKEDSERVER' 

---

INSERT INTO NEW LOCAL TABLE

SELECT * INTO NEWTABLE FROM [LINKEDSERVER\INSTANCE].remoteDATABASE.remoteSCHEMA.remoteTABLE 

OR

INSERT AS NEW VALUES IN REMOTE TABLE

INSERT INTO    [LINKEDSERVER\INSTANCE].remoteDATABASE.remoteSCHEMA.remoteTABLE SELECT  * FROM    localTABLE 

INSERT AS NEW LOCAL TABLE VALUES

INSERT INTO    localTABLE SELECT  * FROM    [LINKEDSERVER\INSTANCE].remoteDATABASE.remoteSCHEMA.remoteTABLE