Save data in a flatfile

[Raphael ottiger]

Hello everybody,

I am a beginner in database technology. But now I want to realize a project for our company.

Data is recorded and saved in the database. This data must then be available to everyone.

So far, I have had no problems building the MySql database in the company network.

However, our company has a number of sales representatives who only have access to this database in the office.

This is where my "problem" begins. Most of the data is collected by the customer with a laptop, but as already mentioned there is no direct connection to the database.

I create the user interface and the program in Visual Studio using the programming language C #.


Now I wanted to know from you whether my solution approach will be implemented in practice or whether there is a better solution.

My solution: The data is recorded in the UI, as soon as the end user saves the data, it is now saved in a flat file. When the user is in the office, he can connect to the database via the network. The data that have been temporarily stored are transferred to the database and the data is deleted in the flat file after the successful transfer. In the next step the complete database (maximum 1000 entries) is saved in a flat file, which is also available locally on the laptop. So that you have the data when you are back at the customer and have no access to the database.

How would you do that?

Have a nice weekend!