Heya folks, I'm looking for a way to grab all the data from a database (running on an ACD call center) into a mysql or postgres database running on a linux system. The call center system is network attached, and it can be accessed via ODBC. Here's the scenario... The call center system is slow. It stores all of its logs/call-detail stuff in an SQL database, and it takes about 20 seconds to do a pretty simple query, hence the desire to pull all the data into a different database running on a dedicated system. The goal is to grab the data files every night and import them into mysql or postgres, and then build a web interface with Zope so that the PHBs can view their reports via the intranet. Some of them like to grab the report and import it into excel so they can further customize their reports themselves for their records. To support that, I'm thinking about generating a tab delimited text file for each report every night that they can download. The formating will be atrocious, but they will be able to get their raw numbers without trying to cut/paste an html document into excel. The web interface also lets us build some predefined queries with some variables that some of the PHBs have been asking us for, giving them a little more control over the reports that they get. Hopefully if I can make this work the way I want it to we won't need to spend our time doing custom reports whenever they want to see something specific that the generic reports don't show very well. Anyway, I know how to do everything except sucking the data out of the call center in one big chunk and importing it into mysql or postgres. I'm thinking I could write something in python to do a query on the call center (select everything from each table) and import the results of the query into the appropriate table in mysql, but my python skills aren't stellar just yet so I'm hoping there's an easier and more direct way that I've overlooked. The data files total about 750 megs on the call center, so I want to grab all the data once, and then every night grab the previous days data. Thanks, Jeff