<table cellspacing="0" cellpadding="0" border="0" ><tr><td valign="top" style="font: inherit;"><DIV>Hi,</DIV>
<DIV> </DIV>
<DIV>My recommendation is to keep Oracle. I have not done such a migration but I know of 2 instances where it was done, one from AS400/DB2 ro SQL server and the other from HP3000/Image to SQL server and in both cases there were performance issues.</DIV>
<DIV> </DIV>
<DIV>Krikor<BR><BR>--- On <B>Wed, 3/9/11, powerh-l-request@lists.sowder.com <I><powerh-l-request@lists.sowder.com></I></B> wrote:<BR></DIV>
<BLOCKQUOTE style="PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: rgb(16,16,255) 2px solid"><BR>From: powerh-l-request@lists.sowder.com <powerh-l-request@lists.sowder.com><BR>Subject: powerh-l Digest, Vol 70, Issue 2<BR>To: powerh-l@lists.sowder.com<BR>Date: Wednesday, March 9, 2011, 1:00 PM<BR><BR>
<DIV class=plainMail>Send powerh-l mailing list submissions to<BR> <A href="http://us.mc1120.mail.yahoo.com/mc/compose?to=powerh-l@lists.sowder.com" ymailto="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</A><BR><BR>To subscribe or unsubscribe via the World Wide Web, visit<BR> <A href="http://lists.sowder.com/mailman/listinfo/powerh-l" target=_blank>http://lists.sowder.com/mailman/listinfo/powerh-l</A><BR>or, via email, send a message with subject or body 'help' to<BR> <A href="http://us.mc1120.mail.yahoo.com/mc/compose?to=powerh-l-request@lists.sowder.com" ymailto="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com</A><BR><BR>You can reach the person managing the list at<BR> <A href="http://us.mc1120.mail.yahoo.com/mc/compose?to=powerh-l-owner@lists.sowder.com"
ymailto="mailto:powerh-l-owner@lists.sowder.com">powerh-l-owner@lists.sowder.com</A><BR><BR>When replying, please edit your Subject line so it is more specific<BR>than "Re: Contents of powerh-l digest..."<BR><BR><BR>Today's Topics:<BR><BR> 1. Migrating from AIX/Oracle to Linux/SQL server (Lemvigh, Ole)<BR> 2. RE:[Bulk] Migrating from AIX/Oracle to Linux/SQL server<BR> (Ken Langendock)<BR> 3. RE:[Bulk] Migrating from AIX/Oracle to Linux/SQL server<BR> (Vidyasagar Goparaju)<BR><BR><BR>----------------------------------------------------------------------<BR><BR>Message: 1<BR>Date: Wed, 9 Mar 2011 16:57:58 +0100<BR>From: "Lemvigh, Ole" <<A href="http://us.mc1120.mail.yahoo.com/mc/compose?to=ole.lemvigh@logica.com" ymailto="mailto:ole.lemvigh@logica.com">ole.lemvigh@logica.com</A>><BR>Subject: Migrating from AIX/Oracle to Linux/SQL server<BR>To: "'<A
href="http://us.mc1120.mail.yahoo.com/mc/compose?to=powerh-l@lists.sowder.com" ymailto="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</A>'" <<A href="http://us.mc1120.mail.yahoo.com/mc/compose?to=powerh-l@lists.sowder.com" ymailto="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</A>><BR>Cc: "Ibarra-Hansen, Kjeld" <<A href="http://us.mc1120.mail.yahoo.com/mc/compose?to=kjeld.ibarra.hansen@logica.com" ymailto="mailto:kjeld.ibarra.hansen@logica.com">kjeld.ibarra.hansen@logica.com</A>><BR>Message-ID:<BR> <<A href="http://us.mc1120.mail.yahoo.com/mc/compose?to=E43264F8709F59448606B603A1940BD729419A2F8E@SE-EX008.groupinfra.com" ymailto="mailto:E43264F8709F59448606B603A1940BD729419A2F8E@SE-EX008.groupinfra.com">E43264F8709F59448606B603A1940BD729419A2F8E@SE-EX008.groupinfra.com</A>><BR>Content-Type: text/plain; charset="us-ascii"<BR><BR>We are considering a migration from a setup with PowerHouse on
AIX backed by an Oracle database running on the same box to PowerHouse on Linux backed by a Microsoft SQL server running on a Windows box.<BR>We have no concerns regarding running PowerHouse on Linux but do see some challenges with using SQL server. For instance, is the existing Oracle database with views, triggers and similar PL/SQL based functionality easily migrated to SQL server using the tools Microsoft supply?<BR>Is communication with the SQL server database from Powerhouse code functioning, without any need for rewriting?<BR>Any references to examples of successful migrations of this kind and/or whitepapers, guidelines or other relevant material would be very much appreciated.<BR><BR>Best regards,<BR><BR>Ole Henrik Lemvigh<BR>________________________________________<BR>Logica<BR><BR>Lautrupvang 10<BR>DK-2750 Ballerup<BR>Denmark<BR>T: +45 21 71 72 65<BR>E: <A href="http://us.mc1120.mail.yahoo.com/mc/compose?to=ole.lemvigh@logica.com"
ymailto="mailto:ole.lemvigh@logica.com">ole.lemvigh@logica.com</A><BR>www.logica.dk<BR><BR><BR><BR><BR>Think green - keep it on the screen.<BR>This e-mail and any attachment is for authorised use by the intended recipient(s) only. It may contain proprietary material, confidential information and/or be subject to legal privilege. It should not be copied, disclosed to, retained or used by, any other party. If you are not an intended recipient then please promptly delete this e-mail and any attachment and all copies and inform the sender. Thank you. <BR><BR><BR><BR><BR>------------------------------<BR><BR>Message: 2<BR>Date: Wed, 9 Mar 2011 11:21:01 -0500<BR>From: "Ken Langendock" <<A href="http://us.mc1120.mail.yahoo.com/mc/compose?to=ken.langendock@rogers.com" ymailto="mailto:ken.langendock@rogers.com">ken.langendock@rogers.com</A>><BR>Subject: RE: [Bulk] Migrating from AIX/Oracle to Linux/SQL server<BR>To: "'Lemvigh, Ole'" <<A
href="http://us.mc1120.mail.yahoo.com/mc/compose?to=ole.lemvigh@logica.com" ymailto="mailto:ole.lemvigh@logica.com">ole.lemvigh@logica.com</A>>,<BR> <<A href="http://us.mc1120.mail.yahoo.com/mc/compose?to=powerh-l@lists.sowder.com" ymailto="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</A>><BR>Cc: "'Ibarra-Hansen, Kjeld'" <<A href="http://us.mc1120.mail.yahoo.com/mc/compose?to=kjeld.ibarra.hansen@logica.com" ymailto="mailto:kjeld.ibarra.hansen@logica.com">kjeld.ibarra.hansen@logica.com</A>><BR>Message-ID: <001501cbde75$fb88fd70$f29af850$@<A href="http://us.mc1120.mail.yahoo.com/mc/compose?to=langendock@rogers.com" ymailto="mailto:langendock@rogers.com">langendock@rogers.com</A>><BR>Content-Type: text/plain; charset="us-ascii"<BR><BR>Here is my advice, and I have worked on every platform (except AS400) since<BR>1986.<BR><BR>DO NOT USE SQL Server when working with
Powerhouse.<BR><BR>Keep your existing Oracle Database and move it to the Linux machine.<BR><BR>OR<BR><BR>If you want to move to the windows platform, migrate your application and<BR>database to Powerhouse for Windows and Oracle for Windows.<BR>There have been people on this list who have tried to use SQL Server, and<BR>FAILED! I know the product will work, but performance SUCKS!<BR><BR>I have a client that has been running this platform for 2 years now, without<BR>any issues.<BR>I also have a client that has been running powerhouse for Windows since 2003<BR>(ISAM), with no issues.<BR><BR>Ken<BR><BR>-----Original Message-----<BR>From: powerh-l-bounces+ken.langendock=<A href="http://us.mc1120.mail.yahoo.com/mc/compose?to=rogers.com@lists.sowder.com" ymailto="mailto:rogers.com@lists.sowder.com">rogers.com@lists.sowder.com</A><BR>[mailto:powerh-l-bounces+ken.langendock=<A href="http://us.mc1120.mail.yahoo.com/mc/compose?to=rogers.com@lists.sowder.com"
ymailto="mailto:rogers.com@lists.sowder.com">rogers.com@lists.sowder.com</A>] On<BR>Behalf Of Lemvigh, Ole<BR>Sent: March 9, 2011 10:58 AM<BR>To: '<A href="http://us.mc1120.mail.yahoo.com/mc/compose?to=powerh-l@lists.sowder.com" ymailto="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</A>'<BR>Cc: Ibarra-Hansen, Kjeld<BR>Subject: [Bulk] Migrating from AIX/Oracle to Linux/SQL server<BR><BR>We are considering a migration from a setup with PowerHouse on AIX backed by<BR>an Oracle database running on the same box to PowerHouse on Linux backed by<BR>a Microsoft SQL server running on a Windows box.<BR>We have no concerns regarding running PowerHouse on Linux but do see some<BR>challenges with using SQL server. For instance, is the existing Oracle<BR>database with views, triggers and similar PL/SQL based functionality easily<BR>migrated to SQL server using the tools Microsoft supply?<BR>Is communication with the SQL server database from Powerhouse
code<BR>functioning, without any need for rewriting?<BR>Any references to examples of successful migrations of this kind and/or<BR>whitepapers, guidelines or other relevant material would be very much<BR>appreciated.<BR><BR>Best regards,<BR><BR>Ole Henrik Lemvigh<BR>________________________________________<BR>Logica<BR><BR>Lautrupvang 10<BR>DK-2750 Ballerup<BR>Denmark<BR>T: +45 21 71 72 65<BR>E: <A href="http://us.mc1120.mail.yahoo.com/mc/compose?to=ole.lemvigh@logica.com" ymailto="mailto:ole.lemvigh@logica.com">ole.lemvigh@logica.com</A><BR>www.logica.dk<BR><BR><BR><BR><BR>Think green - keep it on the screen.<BR>This e-mail and any attachment is for authorised use by the intended<BR>recipient(s) only. It may contain proprietary material, confidential<BR>information and/or be subject to legal privilege. It should not be copied,<BR>disclosed to, retained or used by, any other party. If you are not an<BR>intended recipient then please promptly delete this
e-mail and any<BR>attachment and all copies and inform the sender. Thank you. <BR><BR><BR>-- <BR>= = = = = = = = = = = = = = = = = = = = = = = = = = = =<BR>Mailing list: <A href="http://us.mc1120.mail.yahoo.com/mc/compose?to=powerh-l@lists.sowder.com" ymailto="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</A><BR>Subscribe: 'subscribe' in message body to <A href="http://us.mc1120.mail.yahoo.com/mc/compose?to=powerh-l-request@lists.sowder.com" ymailto="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com</A><BR>Unsubscribe: 'unsubscribe &lt;password&gt;' in message body to<BR><A href="http://us.mc1120.mail.yahoo.com/mc/compose?to=powerh-l-request@lists.sowder.com" ymailto="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com</A><BR><A href="http://lists.sowder.com/mailman/listinfo/powerh-l" target=_blank>http://lists.sowder.com/mailman/listinfo/powerh-l</A><BR>This list is closed, thus to
post to the list you must be a subscriber.<BR>Add 'site:lists.sowder.com powerh-l' to your search terms to search the list<BR>archive at Google.<BR><BR><BR><BR>------------------------------<BR><BR>Message: 3<BR>Date: Wed, 9 Mar 2011 11:48:48 -0500<BR>From: "Vidyasagar Goparaju" <<A href="http://us.mc1120.mail.yahoo.com/mc/compose?to=Vidyasagar.Goparaju@kewill.com" ymailto="mailto:Vidyasagar.Goparaju@kewill.com">Vidyasagar.Goparaju@kewill.com</A>><BR>Subject: RE: [Bulk] Migrating from AIX/Oracle to Linux/SQL server<BR>To: "Ken Langendock" <<A href="http://us.mc1120.mail.yahoo.com/mc/compose?to=ken.langendock@rogers.com" ymailto="mailto:ken.langendock@rogers.com">ken.langendock@rogers.com</A>>, "Lemvigh, Ole"<BR> <<A href="http://us.mc1120.mail.yahoo.com/mc/compose?to=ole.lemvigh@logica.com" ymailto="mailto:ole.lemvigh@logica.com">ole.lemvigh@logica.com</A>>, <<A
href="http://us.mc1120.mail.yahoo.com/mc/compose?to=powerh-l@lists.sowder.com" ymailto="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</A>><BR>Cc: "Ibarra-Hansen, Kjeld" <<A href="http://us.mc1120.mail.yahoo.com/mc/compose?to=kjeld.ibarra.hansen@logica.com" ymailto="mailto:kjeld.ibarra.hansen@logica.com">kjeld.ibarra.hansen@logica.com</A>><BR>Message-ID:<BR> <<A href="http://us.mc1120.mail.yahoo.com/mc/compose?to=3FC84A1B471FCB4AB93F650B53446BCD01ADFFB4@exch-2-003.KWLCORP.NET" ymailto="mailto:3FC84A1B471FCB4AB93F650B53446BCD01ADFFB4@exch-2-003.KWLCORP.NET">3FC84A1B471FCB4AB93F650B53446BCD01ADFFB4@exch-2-003.KWLCORP.NET</A>><BR>Content-Type: text/plain; charset="utf-8"<BR><BR>I agree.<BR><BR>We had issues migrating to Powerhouse on AIX with SQL server on windows<BR>box. We had several issues with the migration and finally ended up with<BR>Powerhouse on AIX with Oracle on windows
server.<BR><BR>If I remember correctly we had to use a third party API to connect to<BR>SQL Server database which is not straightforward like connecting to<BR>Oracle from Powerhouse.<BR><BR>Two major technical issues within our application forced us to drop it.<BR><BR>1. We could not figure out a way to implement record level locking from<BR>within Powerhouse quick programs on a multi-user environment with SQL<BR>server databases.<BR><BR>2. We had issues with our reports due to difference in collating<BR>sequence on SQL server. Tried several things and finally gave up.<BR><BR>Sagar<BR><BR>-----Original Message-----<BR>From: powerh-l-bounces+vidyasagar.goparaju=<A href="http://us.mc1120.mail.yahoo.com/mc/compose?to=kewill.com@lists.sowder.com" ymailto="mailto:kewill.com@lists.sowder.com">kewill.com@lists.sowder.com</A><BR>[mailto:powerh-l-bounces+vidyasagar.goparaju=<A href="http://us.mc1120.mail.yahoo.com/mc/compose?to=kewill.com@lists.sowder.com"
ymailto="mailto:kewill.com@lists.sowder.com">kewill.com@lists.sowder.com</A><BR>] On Behalf Of Ken Langendock<BR>Sent: Wednesday, March 09, 2011 10:21 AM<BR>To: 'Lemvigh, Ole'; <A href="http://us.mc1120.mail.yahoo.com/mc/compose?to=powerh-l@lists.sowder.com" ymailto="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</A><BR>Cc: 'Ibarra-Hansen, Kjeld'<BR>Subject: RE: [Bulk] Migrating from AIX/Oracle to Linux/SQL server<BR><BR>Here is my advice, and I have worked on every platform (except AS400)<BR>since<BR>1986.<BR><BR>DO NOT USE SQL Server when working with Powerhouse.<BR><BR>Keep your existing Oracle Database and move it to the Linux machine.<BR><BR>OR<BR><BR>If you want to move to the windows platform, migrate your application<BR>and<BR>database to Powerhouse for Windows and Oracle for Windows.<BR>There have been people on this list who have tried to use SQL Server,<BR>and<BR>FAILED! I know the product will work, but performance
SUCKS!<BR><BR>I have a client that has been running this platform for 2 years now,<BR>without<BR>any issues.<BR>I also have a client that has been running powerhouse for Windows since<BR>2003<BR>(ISAM), with no issues.<BR><BR>Ken<BR><BR>-----Original Message-----<BR>From: powerh-l-bounces+ken.langendock=<A href="http://us.mc1120.mail.yahoo.com/mc/compose?to=rogers.com@lists.sowder.com" ymailto="mailto:rogers.com@lists.sowder.com">rogers.com@lists.sowder.com</A><BR>[mailto:powerh-l-bounces+ken.langendock=<A href="http://us.mc1120.mail.yahoo.com/mc/compose?to=rogers.com@lists.sowder.com" ymailto="mailto:rogers.com@lists.sowder.com">rogers.com@lists.sowder.com</A>] On<BR>Behalf Of Lemvigh, Ole<BR>Sent: March 9, 2011 10:58 AM<BR>To: '<A href="http://us.mc1120.mail.yahoo.com/mc/compose?to=powerh-l@lists.sowder.com" ymailto="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</A>'<BR>Cc: Ibarra-Hansen, Kjeld<BR>Subject: [Bulk] Migrating from
AIX/Oracle to Linux/SQL server<BR><BR>We are considering a migration from a setup with PowerHouse on AIX<BR>backed by<BR>an Oracle database running on the same box to PowerHouse on Linux backed<BR>by<BR>a Microsoft SQL server running on a Windows box.<BR>We have no concerns regarding running PowerHouse on Linux but do see<BR>some<BR>challenges with using SQL server. For instance, is the existing Oracle<BR>database with views, triggers and similar PL/SQL based functionality<BR>easily<BR>migrated to SQL server using the tools Microsoft supply?<BR>Is communication with the SQL server database from Powerhouse code<BR>functioning, without any need for rewriting?<BR>Any references to examples of successful migrations of this kind and/or<BR>whitepapers, guidelines or other relevant material would be very much<BR>appreciated.<BR><BR>Best regards,<BR><BR>Ole Henrik Lemvigh<BR>________________________________________<BR>Logica<BR><BR>Lautrupvang 10<BR>DK-2750
Ballerup<BR>Denmark<BR>T: +45 21 71 72 65<BR>E: <A href="http://us.mc1120.mail.yahoo.com/mc/compose?to=ole.lemvigh@logica.com" ymailto="mailto:ole.lemvigh@logica.com">ole.lemvigh@logica.com</A><BR>www.logica.dk<BR><BR><BR><BR><BR>Think green - keep it on the screen.<BR>This e-mail and any attachment is for authorised use by the intended<BR>recipient(s) only. It may contain proprietary material, confidential<BR>information and/or be subject to legal privilege. It should not be<BR>copied,<BR>disclosed to, retained or used by, any other party. If you are not an<BR>intended recipient then please promptly delete this e-mail and any<BR>attachment and all copies and inform the sender. Thank you. <BR><BR><BR>-- <BR>= = = = = = = = = = = = = = = = = = = = = = = = = = = =<BR>Mailing list: <A href="http://us.mc1120.mail.yahoo.com/mc/compose?to=powerh-l@lists.sowder.com" ymailto="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</A><BR>Subscribe:
'subscribe' in message body to<BR><A href="http://us.mc1120.mail.yahoo.com/mc/compose?to=powerh-l-request@lists.sowder.com" ymailto="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com</A><BR>Unsubscribe: 'unsubscribe &lt;password&gt;' in message body to<BR><A href="http://us.mc1120.mail.yahoo.com/mc/compose?to=powerh-l-request@lists.sowder.com" ymailto="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com</A><BR><A href="http://lists.sowder.com/mailman/listinfo/powerh-l" target=_blank>http://lists.sowder.com/mailman/listinfo/powerh-l</A><BR>This list is closed, thus to post to the list you must be a subscriber.<BR>Add 'site:lists.sowder.com powerh-l' to your search terms to search the<BR>list<BR>archive at Google.<BR><BR>-- <BR>= = = = = = = = = = = = = = = = = = = = = = = = = = = =<BR>Mailing list: <A href="http://us.mc1120.mail.yahoo.com/mc/compose?to=powerh-l@lists.sowder.com"
ymailto="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</A><BR>Subscribe: 'subscribe' in message body to<BR><A href="http://us.mc1120.mail.yahoo.com/mc/compose?to=powerh-l-request@lists.sowder.com" ymailto="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com</A><BR>Unsubscribe: 'unsubscribe &lt;password&gt;' in message body to<BR><A href="http://us.mc1120.mail.yahoo.com/mc/compose?to=powerh-l-request@lists.sowder.com" ymailto="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com</A><BR><A href="http://lists.sowder.com/mailman/listinfo/powerh-l" target=_blank>http://lists.sowder.com/mailman/listinfo/powerh-l</A><BR>This list is closed, thus to post to the list you must be a subscriber.<BR>Add 'site:lists.sowder.com powerh-l' to your search terms to search the<BR>list archive at Google.<BR><BR><BR>IMPORTANT NOTICE: This email is intended solely for the use of the individual to whom it is
addressed and may contain information that is privileged, confidential or otherwise exempt from disclosure under applicable law. If the reader of this email is not the intended recipient or the employee or agent responsible for delivering the message to the intended recipient, you are hereby notified that any dissemination, distribution, or copying of this communication is strictly prohibited. If you have received this communication in error, please immediately notify us by telephone at (978) 482-2500 and return the original message to us at the listed email address. In accordance with Kewill policy, emails sent and received may be monitored. Kewill accepts no responsibility for any loss or damage should this email contain any virus, or similar destructive or mischievous code. Thank You. Copyright ? 2010 by Kewill Inc.<BR><BR><BR><BR>------------------------------<BR><BR>-- <BR>= = = = = = = = = = = = = = = = = = = = = = = = = = = =<BR>Mailing list: <A
href="http://us.mc1120.mail.yahoo.com/mc/compose?to=powerh-l@lists.sowder.com" ymailto="mailto:powerh-l@lists.sowder.com">powerh-l@lists.sowder.com</A><BR>Subscribe: &quot;subscribe&quot; in message body to <A href="http://us.mc1120.mail.yahoo.com/mc/compose?to=powerh-l-request@lists.sowder.com" ymailto="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com</A><BR>Unsubscribe: &quot;unsubscribe &lt;password&gt;&quot; in message body to <A href="http://us.mc1120.mail.yahoo.com/mc/compose?to=powerh-l-request@lists.sowder.com" ymailto="mailto:powerh-l-request@lists.sowder.com">powerh-l-request@lists.sowder.com</A><BR><A href="http://lists.sowder.com/mailman/listinfo/powerh-l" target=_blank>http://lists.sowder.com/mailman/listinfo/powerh-l</A><BR>This list is closed, thus to post to the list you must be a subscriber.<BR>Add 'site:lists.sowder.com powerh-l' to your search terms to search the list archive at
Google.<BR><BR>End of powerh-l Digest, Vol 70, Issue 2<BR>***************************************<BR></DIV></BLOCKQUOTE></td></tr></table>