MySQL Forums
Forum List  »  General

Save data in a flatfile
Posted by: Raphael ottiger
Date: February 01, 2020 03:39PM

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!

Options: ReplyQuote

Written By
Save data in a flatfile
February 01, 2020 03:39PM
February 01, 2020 04:39PM

Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.