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.
seharmks
0
Newbie Poster
Recommended Answers
Jump to PostWhat are the keys in the table?
All 2 Replies
binoj_daniel
14
Practically a Master Poster
What are the keys in the table?
Ramy Mahrous
401
Postaholic
Featured Poster
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.