I have two tables (eg: Table1 and Table 2) in Database1 (Local) at the Head Office. These tables store records for multiple Units.
eg:
UnitCode PlanNo Product Quantity
===========================================
Unit1 Plan1 Product1 10000
Unit1 Plan1 Product2 20000
Unit1 Plan1 Product3 30000
Unit2 Plan2 Product7 15000
Unit2 Plan2 Product11 25000
Unit2 Plan2 Product15 35000

I want to fetch data (Unitwise) from these tables and send it to the respective units database.

Each Unit will be having the same tables and structure.

What should be the method and process

Please help
Thanks in advance