On 31 Oct 2015, at 7:42pm, Andi Palo <sanandrea8080 at gmail.com> wrote:
> I used the command: > "pragma integrity_check" with db opened with version 3.9.1. > > The result is: > > Error: database disk image is malformed > > Am I missing something or this error is more silent that the original fault? As later and later versions of SQLite are produced, one of the things that is improved is the ability to spot database corruption. > I am planning to make a patch of the conversion utility. But it uses > System.Data.Sqlite library not the sqlite3.dll, so I think it is a little > more complicated. The standard way to convert from one type of SQL to another is 1) Use 'old' SQL engine to dump the schema and data to a text file as SQL commands. 2) Process the text file to cope with the minor differences in SQL between the two versions of SQL. 3) Use the 'new' SQL engine to create a new database by running the SQL commands. For SQLite you would use the sqlite command-line tool (free download for many platforms) for step 3. It has both a '.dump' and a '.read' command to convert to and from SQL commands. Simon.
