I am using sqlite version 3.6.15.I upgraded my database from sqlite
3.5.4 to 3.6.15. I am not able to open database from sqlite3.exe cmd
utility .
I can do sqlite3.exe test.DB but if type
.database ,it gives me error malformed database schema.
pragma integrity_check , gives error malformed database schema
So I took the dump of db in test.sql using .dump command. If try to
create database using test.sql I get bunch of errors.
default value of column is not constant, no such table etc.
I have to go manually and edit sql ,make changes so that everything
works fine.
I am just curious why my database structure get corrupted /changed .Will
changing database engine cause schema to change or is it dump command
changing my database schema.
Thanks,
-Kalyani
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
