On 8 Aug 2013, at 11:52pm, Inna Belakhova <inna.belakh...@melbourne.vic.gov.au> wrote:
> We have a database that is 8GB and most of the data is in a RESOURCE > table that contains BLOB type. > > > > Is there a limit on how much data can be inserted into the table? Limits for things in SQLite databases can be found here: <http://www.sqlite.org/limits.html> Item 1 answers your question: by default 1,000,000,000 bytes, with special compilation 2,147,483,647 bytes > Is it possible to convert SQLITe to SQL database and transferring the > BLOB data as well? You can extract the contents of a BLOB field and dump many ways; write it to a file if you want. You might like a command-line shell tool for SQLite: <http://www.sqlite.org/sqlite.html> you can download from the site pre-compiled for various OSes. It will dump the data in SQLite databases as SQL commands. It will dump BLOB fields as hexadecimal octets. Simon. _______________________________________________ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
