How to copy distinct records from one table to another using SQL 2005

[seharmks]

I have a table on an offline database having let say 2000 rows and same table on an online database with let say 3000 rows. Now I want to copy just those records (1000) from online database that are not in the offline database table. Also, both tables have same name, same schema etc.

[binoj_daniel]

What are the keys in the table?

[Ramy Mahrous]

Use differential Backup...
or you can use insert select
like

insert into table1 values (select distinct a,b,c.. from table2)