Morning everyone,
I was hoping to use mdbtools to extract data from some Access databases overnight. I have yum installed the tools from Dag and also downloaded and (eventually!) compiled the latest release from the mdbtools web site, but I either get 'buffer overflow' errors or no output from most of the tools. I have been trying to cvs checkout the latest development version but sourceforge's cvs login keeps timing out.
Is anyone hereabouts using mdbtools successfully, or can anyone suggest any other tools that will dump access databases on a scheduled basis? I have done test migrations using the MySQL gui tools and that works fine, but I don't think the operation can be scripted.
On a side note, I also need to do the same for MS-SQL data - does anyone have any favourite tools for automating data extraction? Everything ultimately needs to end up in a MySQL database
Any advice appreciated.
Thanks
Nigel Kendrick
From: centos-bounces@centos.org [mailto:centos-bounces@centos.org] On
Behalf Of Nigel Kendrick
Sent: Friday, June 20, 2008 9:25 AM To: 'CentOS mailing list' Subject: [CentOS] mdbtools on CentOS
Morning everyone,
I was hoping to use mdbtools to extract data from some Access databases
overnight. I have yum installed the tools from Dag and also downloaded and (eventually!) compiled the latest
release from the mdbtools web site, but I either get 'buffer overflow'
errors or no output from most of the tools. I have been trying to cvs checkout the latest development version but
sourceforge's cvs login keeps timing out.
[Snip]
OK - managed to login to CVS at last and download the latest development version.
A straight configure/make created tools that ran, but generated no output. I re-did the configure with some suggested options (below) and it works!!!
./configure --enable-sql --with-unixodbc=/usr/local
It seems these options are needed even though I am accessing the mdb file directly off disk and not via odbc or SQL
Thanks to all who were just about to chip in with suggestions ;-)
On Fri, 2008-06-20 at 09:25 +0100, Nigel Kendrick wrote:
[snip]
If you, or others like you, insist on using HTML for email to this list please set your font size to 10!
Thank you! Bob
-
Bob Taylor -
Nigel Kendrick