Data From MySQL to SQLite

[Devin Asay]

On May 23, 2013, at 3:06 PM, Dr. Hawkins wrote:

> Library???  assuming that the names/types are compatible,
> 
> put revDataFromQuery(tab,vtab,inDbno,"SELECT * FROM inTable) into theData
> 
> put "BEGIN TRANSACTION;" & cr into dcmd
> 
> set the itemDel to vtab
> repeat for each item theLin  in theData
> put "INSERT INTO outTable VALUES( " & theLin & ");" & cr after dcmd
> end repeat
> put "COMMIT;" & cr after dcmd
> 
> revExecuteSql outDb, dcmd
> 
> 
> You could also simply insert the values at each step of the loop, but
> that's time consuming if you have a remote db.

Richard,

Thanks, I'll give that a try. Any idea if this might work for records containing binary data? I have one table with around 74 MB of data that I need to transfer over.

Devin



Devin Asay
Office of Digital Humanities
Brigham Young University