Insert data from one DB table to another DB table

MOHAMED JACKARIAH

12y1.5kLINQ

I have urgent issue in my application. Can you please help me for the following scenario.

I have two table with same schema, In different server. I Need to insert into table from one database to another database table based on user criteria.

Before insert i want to check record is already exists in the designation table or not.

If the records are exists don't want to insert the records. I need to insert only different records.

2 Replies

Know the answer? Post it — somebody with the same question will find it here.

MOHAMED JACKARIAH12y ago
Thanks for your reply my friend. I need do this using my asp.net application. i have two different server. One is on my local and another is on my client place. right now i am doing with sample using Northwind DB in my local its working fine. But i don't know how to the same in the different server. Below is my sample

BEGIN TRY
BEGIN TRANSACTION

INSERT INTO ToTable(SecondID,Name,fromdate)
SELECT
NEWID() AS SecondID,
Name,
fromdate
FROM(
SELECT
ROW_NUMBER() OVER(PARTITION BY FRMTBL.id ORDER BY FRMTBL.id) AS row,
FRMTBL.Id,
FRMTBL.Name,
FRMTBL.FromDate
FROM
FromTable FRMTBL
WHERE
NOT EXISTS (
SELECT * FROM ToTable TOTBL
WHERE
FRMTBL.Id=TOTBL.Id)
) t WHERE row =1
COMMIT
END TRY
BEGIN CATCH
ROLLBACK
END CATCH
Jignesh Trivedi12y ago
Hi,
Using Linked server, it is possible...
to create linked server please refer
http://msdn.microsoft.com/en-us/library/ff772782.aspx
http://msdn.microsoft.com/en-us/library/aa560998.aspx

once you have linked server than you can write following query to insert records.
Insert into table1 (col1,col2,col3)
select col1,col2,col3 from [linkedServerName].DatabaseName.Schema.tableName
where col1 not in (select col1 from table1)
hope this will help you.