Board index » delphi » Fastest way to transfer data from Interbase to SQLite?

2006-12-08 03:47:36 AM
delphi145
Could anybody tell me what the fastest way is to move data from Interbase
(5.6) to a SQLite database?
I am programming in VB/VBA. Thanks for any advice.
RBS
 

--
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
www.upscene.com
My thoughts:
blog.upscene.com/martijn/
Database development questions? Check the forum!
www.databasedevelopmentforum.com
 

It is a regular job, happening many times in the same Excel session.
It will always be different data. This is part of a .xla frontend reporting
software.
It is a medical database and the data would first be moved from Interbase to
SQLite with
fast, light-weight queries (has to be otherwise it would slow down the main
clinical application
too much) then the analysis and conversion will be done in SQLite and
finally the results will
be dumped in Excel. Ideally this whole process will take seconds. The
bottleneck currently is the
transfer of data from Interbase to SQLite. All else is very fast.
Hope this makes it clearer.
RBS
"Martijn Tonies" <XXXX@XXXXX.COM>writes

Any suggestions now with the extra information?
RBS
"Martijn Tonies" <XXXX@XXXXX.COM>writes

--
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
www.upscene.com
My thoughts:
blog.upscene.com/martijn/
Database development questions? Check the forum!
www.databasedevelopmentforum.com
 

OK, so you haven't got any ready-made solution in mind then?
RBS
"Martijn Tonies" <XXXX@XXXXX.COM>writes

command line DataPump tool with a previously set up project
and an ODBC connection to SQLite, but I think that using
SQLite directly should be faster. Or any bulk insert tool for
SQLite or something. I have no idea if that is available.
--
Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
www.upscene.com
My thoughts:
blog.upscene.com/martijn/
Database development questions? Check the forum!
www.databasedevelopmentforum.com
 

OK, thanks, I (somebody is doing it for me) am working on a custom app.
RBS
"Martijn Tonies" <XXXX@XXXXX.COM>writes