RB Smissaert wrote:
I think I might have asked this before, but I still haven't figured it out.
What would be the fastest way to move data from Interbase to SQLite?
I will have to do this in VB/VBA, unless I could use a dll written in for
example C or C++.
Currently I get the data with the Intersolve ODBC driver, moving that to an
ADO recordset and I then loop through that recordset and move the data to
SQLite with inserts via the VB wrapper dll from TerraInformatica.
Speed is just about acceptable, but maybe somebody who has done this before
(Interbase to SQLite) could advise me about a better way to do this.
You might want to try CodeGear's (formerly Borland's) Turbo C++
Explorer. This is the new *free* version of their IDE that includes a
development version of InterBase (20 users max) and their fast dbXpress
drivers for InterBase. Since it is a C/C++ compiler you can use SQLite
directly, or through one of the C++ wrappers. I suspect that this will
produce an application that is about as fast a you will get for moving
data from Interbase to SQLite.
HTH
Dennis Cote
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------