Hi Simon, Thanks for all the help. I was able to get my SQLite database imported from the dump file after correcting several issues with the exported SQL statements like VARCHAR with no length and a few other stuff. The fact that I have to use REAL for DATETIME field will be an issue, but I'll have to try to work around it.
Ted On Jan 12, 2013, at 1:38 PM, Simon Slavin <[email protected]> wrote: On 12 Jan 2013, at 9:22pm, Ted Heng <[email protected]> wrote: > Here's another problem. I presumed the problem is with the dump value in > fraction instead of in the format 'YYYYMMDD ...', etc. Can I change the date > format of the dump? SQLite doesn't have a date format. You can choose to store a date in various formats including text, real numbers and integers, with various interpretations for each. Fortunately, DATETIME2 is a SQL Server format, and you shouldn't much trouble interpreting these. I would import them into REAL fields (change the table definition line in your SQL text file) and later use SQL Server code to UPDATE using a 'cast()'. No idea what a SQL Server-only type is doing in a SQLite database. Simon. _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users _______________________________________________ sqlite-users mailing list [email protected] http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
