Hi! Although this subject is not exactly Zope related, I thought I'd still try to throw in question, since many of the subscribers are well aware of this area. I've developed an application with Zope and all the data is stored in an InterBase database. After some study and research, I decided to move on to SAP DB. Therefore, I'd like to know if anyone knows of a software that could easily export the database from InterBase to SAP DB. I've tried to use SQL Enterprise Manage, but even though he manages to successfully create the tables, it stucks when it comes to transferring the tables' content. kind regards, Vitor Varalonga
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
Brad Clements wrote:
You'll probably fair better writing a simple python script to select from Interbase then insert into SAP DB.
Thanks for the suggestion. Anyway, I think I might haven't been that especific on my orginal mail. I'm (still) having problems with ZsapdbDA and I need to get my DB into SAP DB first of all. Since, I can't count with Zope for that right now, what I ment to know is if anyone knew any good external tool (Non-Zope) that could be used to transfer the database from the InterBase DB engine to the SAP DB engine. kind regards, Vitor Varalonga
On Thu, 2002-09-05 at 09:40, Vitor Varalonga wrote:
Brad Clements wrote:
You'll probably fair better writing a simple python script to select from Interbase then insert into SAP DB.
Thanks for the suggestion. Anyway, I think I might haven't been that especific on my orginal mail. I'm (still) having problems with ZsapdbDA and I need to get my DB into SAP DB first of all. Since, I can't count with Zope for that right now, what I ment to know is if anyone knew any good external tool (Non-Zope) that could be used to transfer the database from the InterBase DB engine to the SAP DB engine.
Yes, as Brad said: Python. This will work just fine so long as *Python* has the db bindings, and I believe it does for both. If not, you may need to do it in C. I highly recommend the python route first. -- Bill Anderson Linux in Boise Club http://www.libc.org Amateurs built the Ark, professionals built the Titanic. Amateurs build Linux, professionals build Windows(tm).
what I ment to know is if anyone knew any good external tool (Non-Zope) that could be used to transfer the database from the InterBase DB engine to the SAP DB engine.
No, but this might get you close (or at least half way)... http://www.honeypot.net/~kirk/projects/dbreplicate.html It's for Interbase to PostgreSQL conversion :-) Adam
participants (4)
-
Adam Manock -
Bill Anderson -
Brad Clements -
Vitor Varalonga