Member Avatar for 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.

  • 3 Contributors
  • 2 Replies
  • 121 Views
  • 22 Hours Discussion Span
  • Latest Post Latest Post by Ramy Mahrous
Member Avatar for binoj_daniel

What are the keys in the table?

Member Avatar for Ramy Mahrous

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

insert into table1 values (select distinct a,b,c.. from table2)
Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.