How to store the data in the local DB source file and not in what the application creates?

Question

SQL

I use a local database, which, when the program is launched (if there is access to the server), is synchronized with the central database. The user works with a local database, not suspecting anything that all information is automatically synchronized. And it doesn't seem to work well. The data is saved and then displayed. I have not done synchronization yet, but, as they say, the song is not about that at all. I was at a loss when the program worked fine, without crashes and displayed everything well, but when I opened the source file of the local database, there was nothing new there. I found that the problem is that in the properties of the database it is marked "copy if newer", as a result another file is created in the source folder of the program and everything is saved in it. But how to me to make, what all would be saved in a source code??? I am using SQL database. Thanks in advance

Answer 1

set this property to "don't copy"