How can I copy data from one SQL server data into another. I am trying to copy a table data from server1 to server2. In server1.table1 the data from the table gets added/deleted for an example if I have 10 rows and five more rows gets added, after some time the first ten gets deleted. On the other hand I am copying into an other server, server2.table2. I am using How can I copy data from one SQL server data in