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]
-----------------------------------------------------------------------------

Reply via email to