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