How to transfer information without internet to MsSQL?

Question

SQL

In general, sometimes the Internet between outlets disappears for various reasons and you need to go and manually transfer the information or through the phone in different ways.
I sketched such a scheme in my head, in the program (a trading program that uses the local mssql database) I click something like "upload to a USB flash drive", it writes this invoice, for example, in csv (however, it does not matter which one). Then I go with this flash drive and insert it into another computer, where the mini-program listens to the usb port and automatically turns the csv file into an sql query and sends it to the database.
The entire database does not need to be transferred, only small parts (for example, invoices). How to organize it, what are the ready-made solutions?

Answer 1

You didn't describe how you synchronize two databases when there is an Internet. It’s just that when I implemented projects that provided for a local and shared database, I always formed synchronization rules and conflict resolution methods based on the task.
Imagine the following situation: Therefore, I doubt that a ready-made solution will suit you, most likely you will have to write your own.
you copied to csv and loaded the information from the local database into the main one,
then decided to copy something else, put the flash drive again. question: what kind of information should the program write to csv this time, only new information or what was recorded for the first time. If only new, then after each operation, you must note that this information has been uploaded. But then the second moment arises, you uploaded it to CSV, but you lost the flash drive. We decided to repeat, but there are no more entries.