Database change connection in sqlite

Question

I have made some database change in my local SQLite for a windows form app using c# but when i generate the build and run in another system the database changes made are not available they are goin off so how to check how the sync is happening in the app n??

Answer 1

You asked this question as if the community knows what you are thinking and how you application works.

Since Sqlite is a local database, I'm guessing your deployment process does not copy the correct database or your seed logic does not work properly. But, this is only a guess.

If you want community debugging services, then share enough code to reproduce this issue.

Answer 2

That's to less on informations.
How do you create/update the database? A Code First Entity Framework solution? Own code? With a tool?

Answer 3

Seems like you need to consider how do changes affect current data prior to database changes if any and if so you need to write code to handle current data and if it does not affect current data redistribute the new database to the client.

When considering adapting to current data, create say a console utility that first backs up current data, modify to suit the new schema followed by validating the changes work all done on your development machine than once satisfied give the utility to clients.

What is involved in writing a utility, you have not supplied enough information to tell you but best advice is to write out requirements than work from there.