how to upgrade the sqlite database without lost data? -


i have application in c# uses system.data.sqlite. in case use recent version of sql lite database, can see new versión has released, , int sqlite.org webpage says recommended upgrade database.

my question how upgrade without lost information in actual database.

how can chech version of data

thanks.

edit: mean when create new database sqlite3 library, guess database file, database.db has version. when update sqlite3 library, update sqlite3 command line, database file still has version had when created it.

so if in new versions example add new features database, example triggers, foreign keys , on, if not wrong, features must in database file, not in sqlite3 library, because when access database example entity framework, don't use sqlite3 library, use system.sqlite.data library.

am wrong? datafile never update , library can updated?

thanks.

upgrading sqlite library not have effect on database file.

changes foreign keys not affect database file. last change affected file format a long time ago.


Comments

Popular posts from this blog

c# - Send Image in Json : 400 Bad request -

jquery - Fancybox - apply a function to several elements -

An easy way to program an Android keyboard layout app -