Implemented based on Primary key in the tables And / Or based on datetime Columns that are used to track the data that needs to be moved.
It's a general question and you need to give specifics about your data upon which it would be easy to suggest.
Blog -- LearnSQLWithBru
Join on Facebook Page Facebook.comLearnSQLWithBru
Twitter -- BruMedishetty