[Zope] InterBase to SAP DB

[Brad Clements]

On 5 Sep 2002 at 14:30, Vitor Varalonga wrote:

>  Therefore, I'd like to know if anyone knows of a software that
> could easily export the database from InterBase to SAP DB.

My projects all use SQLDict in addition to ZSQLMethods and straight SQL in an 
execute().

To support SQLDict, I actually keep all table meta-data in an MS-Access database 
(argh!).. I then use Python to generate class definitions for all the tables.. 

Python also generates the "create table" commands to create tables.

Switching from Interabase was simple using this method. I wrote a simple script to read 
the two "generated sqldict modules", attach to the src and dest database and copy all 
records. This wasn't fast.. 300 meg took about 5 hours.

You'll probably fair better writing a simple python script to select from Interbase then 
insert into SAP DB.

--


I must say that SAP is turning out to be much faster in Zope than Interbase. Nearly 6 
times faster.. Also trying a test of switching from page templates to XML/XSLT.. 



Brad Clements,                bkc@murkworks.com   (315)268-1000
http://www.murkworks.com                          (315)268-9812 Fax
AOL-IM: BKClements