I have a requirement to write a script to copy records from one server to other server .There is no linked server between them.It should be done by using temp table.Can anyone help me in this?
I should use a temp table to copy data from server:sql1\pr,database:db1.dbo.table1and should check like the records doesn't already exist using a left join.
If you want to do it in T-SQL, you really could do with using a linked server. Otherwise you can investigate using OPENROWSET to use a connection string.
So, something like
However, if you can do it using other tools, then you will find that SSIS is probably a much better bet.
answered Nov 08 '10 at 09:12 AM
Matt Whitfield ♦♦
My Dear Freind you can use Import Export utility in SQL server to Copy record from one server to another..
answered Nov 10 '10 at 12:34 PM