Click here to Skip to main content
14,735,611 members
Please Sign up or sign in to vote.
0.00/5 (No votes)
I have a table inside local db called A which have 2 rows.

ID Name
1 X
2 Y

and my remote db table has 3 rows with same structure

ID Name
1 X
2 Y
3 Z

My problem is when i am inserting 2 new rows in tableA, then it must insert the 2 new rows in remote db as table B when the internet is available or when button clicked(whichever possible). I need to do this without loop as the new transactions are huge like 10000 per day. I have a risk of jobless, please help.

1 solution

You should have a look at SQL Server Replication[^].

This allows the correct synchronization between both database, whether records have been inserted, deleted, or modified.

Hope this helps.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

CodeProject, 20 Bay Street, 11th Floor Toronto, Ontario, Canada M5J 2N8 +1 (416) 849-8900