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
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.