Powerhouse migration questions

[Viet Nguyen]

Hi ,
I am in the process of moving from cisam to oracle using AIX - (we are
keeping powerhouse in Unix) I would like to know if anyone out there has
a parser or a smart search/replace routine to help with converting the
Access statement otherwise I think it will take us forever to manually
make these changes!
Thanks in advance.
Viet.


-----Original Message-----
From: powerh-l-admin@lists.sowder.com
[mailto:powerh-l-admin@lists.sowder.com] On Behalf Of Jon Kvisli
Sent: Wednesday, January 12, 2005 10:00 AM
To: Pat Shugart; powerh-l@lists.sowder.com
Subject: SV: QTP migration questions

>We're not replacing Powerhouse. 
 
Then I strongly advise you to KEEP your QTP programs, but spend some
time optimizing ACCESS statements using cursors and SQL. This advise is
based on personal, practical experience from converting two large
systems (2-300 QTPs) from HP3000/Image to HP9000/Oracle. We then
searched for other / better batch-processig tools, but finally decided
to stay with QTP.
 
However, you WILL have to do changes in the QTP source. Due to the way
QTP interacts with a relational database, most QTPs will do a high
number of SQL-calls and perform VERY bad if ACCESS statements are left
unchanged. The big issue is to let the databaseserver do most of the job
by extracting only the data needed by QTP (that is moving functionality
into the database). This will reduce the number of SQL calls from QTP to
Oracle, and also reduce network traffic returning data back to QTP. If
you do a good job rewriting ACCESS statements using cursors and SQL, you
will most likely get performance that is even much better than the
original qtp. 
 
Another way of moving functionality into the database, is using stored
procedures in PL/SQL, but this is more useful for moving business logic
away from QDESIGN/QUICK programs, than with QTP.
 
regards
Jon Kvisli
principal consultant
3800 Bo in Telemark
Norway
jon.kvisli@exchangemail.no
 
 

= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.sowder.com
Subscribe: "subscribe" in message body to
powerh-l-request@lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to
powerh-l-request@lists.sowder.com
http://lists.sowder.com/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.