powerh-l Digest, Vol 70, Issue 2
krikor Gullekian
krigul at yahoo.com
Wed Mar 9 12:56:39 CST 2011
Hi,
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.
Krikor
--- On Wed, 3/9/11, powerh-l-request at lists.sowder.com <powerh-l-request at lists.sowder.com> wrote:
From: powerh-l-request at lists.sowder.com <powerh-l-request at lists.sowder.com>
Subject: powerh-l Digest, Vol 70, Issue 2
To: powerh-l at lists.sowder.com
Date: Wednesday, March 9, 2011, 1:00 PM
Send powerh-l mailing list submissions to
powerh-l at lists.sowder.com
To subscribe or unsubscribe via the World Wide Web, visit
http://lists.sowder.com/mailman/listinfo/powerh-l
or, via email, send a message with subject or body 'help' to
powerh-l-request at lists.sowder.com
You can reach the person managing the list at
powerh-l-owner at lists.sowder.com
When replying, please edit your Subject line so it is more specific
than "Re: Contents of powerh-l digest..."
Today's Topics:
1. Migrating from AIX/Oracle to Linux/SQL server (Lemvigh, Ole)
2. RE:[Bulk] Migrating from AIX/Oracle to Linux/SQL server
(Ken Langendock)
3. RE:[Bulk] Migrating from AIX/Oracle to Linux/SQL server
(Vidyasagar Goparaju)
----------------------------------------------------------------------
Message: 1
Date: Wed, 9 Mar 2011 16:57:58 +0100
From: "Lemvigh, Ole" <ole.lemvigh at logica.com>
Subject: Migrating from AIX/Oracle to Linux/SQL server
To: "'powerh-l at lists.sowder.com'" <powerh-l at lists.sowder.com>
Cc: "Ibarra-Hansen, Kjeld" <kjeld.ibarra.hansen at logica.com>
Message-ID:
<E43264F8709F59448606B603A1940BD729419A2F8E at SE-EX008.groupinfra.com>
Content-Type: text/plain; charset="us-ascii"
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.
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?
Is communication with the SQL server database from Powerhouse code functioning, without any need for rewriting?
Any references to examples of successful migrations of this kind and/or whitepapers, guidelines or other relevant material would be very much appreciated.
Best regards,
Ole Henrik Lemvigh
________________________________________
Logica
Lautrupvang 10
DK-2750 Ballerup
Denmark
T: +45 21 71 72 65
E: ole.lemvigh at logica.com
www.logica.dk
Think green - keep it on the screen.
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.
------------------------------
Message: 2
Date: Wed, 9 Mar 2011 11:21:01 -0500
From: "Ken Langendock" <ken.langendock at rogers.com>
Subject: RE: [Bulk] Migrating from AIX/Oracle to Linux/SQL server
To: "'Lemvigh, Ole'" <ole.lemvigh at logica.com>,
<powerh-l at lists.sowder.com>
Cc: "'Ibarra-Hansen, Kjeld'" <kjeld.ibarra.hansen at logica.com>
Message-ID: <001501cbde75$fb88fd70$f29af850$@langendock at rogers.com>
Content-Type: text/plain; charset="us-ascii"
Here is my advice, and I have worked on every platform (except AS400) since
1986.
DO NOT USE SQL Server when working with Powerhouse.
Keep your existing Oracle Database and move it to the Linux machine.
OR
If you want to move to the windows platform, migrate your application and
database to Powerhouse for Windows and Oracle for Windows.
There have been people on this list who have tried to use SQL Server, and
FAILED! I know the product will work, but performance SUCKS!
I have a client that has been running this platform for 2 years now, without
any issues.
I also have a client that has been running powerhouse for Windows since 2003
(ISAM), with no issues.
Ken
-----Original Message-----
From: powerh-l-bounces+ken.langendock=rogers.com at lists.sowder.com
[mailto:powerh-l-bounces+ken.langendock=rogers.com at lists.sowder.com] On
Behalf Of Lemvigh, Ole
Sent: March 9, 2011 10:58 AM
To: 'powerh-l at lists.sowder.com'
Cc: Ibarra-Hansen, Kjeld
Subject: [Bulk] Migrating from AIX/Oracle to Linux/SQL server
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.
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?
Is communication with the SQL server database from Powerhouse code
functioning, without any need for rewriting?
Any references to examples of successful migrations of this kind and/or
whitepapers, guidelines or other relevant material would be very much
appreciated.
Best regards,
Ole Henrik Lemvigh
________________________________________
Logica
Lautrupvang 10
DK-2750 Ballerup
Denmark
T: +45 21 71 72 65
E: ole.lemvigh at logica.com
www.logica.dk
Think green - keep it on the screen.
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.
--
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l at lists.sowder.com
Subscribe: 'subscribe' in message body to powerh-l-request at lists.sowder.com
Unsubscribe: 'unsubscribe <password>' in message body to
powerh-l-request at 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.
Add 'site:lists.sowder.com powerh-l' to your search terms to search the list
archive at Google.
------------------------------
Message: 3
Date: Wed, 9 Mar 2011 11:48:48 -0500
From: "Vidyasagar Goparaju" <Vidyasagar.Goparaju at kewill.com>
Subject: RE: [Bulk] Migrating from AIX/Oracle to Linux/SQL server
To: "Ken Langendock" <ken.langendock at rogers.com>, "Lemvigh, Ole"
<ole.lemvigh at logica.com>, <powerh-l at lists.sowder.com>
Cc: "Ibarra-Hansen, Kjeld" <kjeld.ibarra.hansen at logica.com>
Message-ID:
<3FC84A1B471FCB4AB93F650B53446BCD01ADFFB4 at exch-2-003.KWLCORP.NET>
Content-Type: text/plain; charset="utf-8"
I agree.
We had issues migrating to Powerhouse on AIX with SQL server on windows
box. We had several issues with the migration and finally ended up with
Powerhouse on AIX with Oracle on windows server.
If I remember correctly we had to use a third party API to connect to
SQL Server database which is not straightforward like connecting to
Oracle from Powerhouse.
Two major technical issues within our application forced us to drop it.
1. We could not figure out a way to implement record level locking from
within Powerhouse quick programs on a multi-user environment with SQL
server databases.
2. We had issues with our reports due to difference in collating
sequence on SQL server. Tried several things and finally gave up.
Sagar
-----Original Message-----
From: powerh-l-bounces+vidyasagar.goparaju=kewill.com at lists.sowder.com
[mailto:powerh-l-bounces+vidyasagar.goparaju=kewill.com at lists.sowder.com
] On Behalf Of Ken Langendock
Sent: Wednesday, March 09, 2011 10:21 AM
To: 'Lemvigh, Ole'; powerh-l at lists.sowder.com
Cc: 'Ibarra-Hansen, Kjeld'
Subject: RE: [Bulk] Migrating from AIX/Oracle to Linux/SQL server
Here is my advice, and I have worked on every platform (except AS400)
since
1986.
DO NOT USE SQL Server when working with Powerhouse.
Keep your existing Oracle Database and move it to the Linux machine.
OR
If you want to move to the windows platform, migrate your application
and
database to Powerhouse for Windows and Oracle for Windows.
There have been people on this list who have tried to use SQL Server,
and
FAILED! I know the product will work, but performance SUCKS!
I have a client that has been running this platform for 2 years now,
without
any issues.
I also have a client that has been running powerhouse for Windows since
2003
(ISAM), with no issues.
Ken
-----Original Message-----
From: powerh-l-bounces+ken.langendock=rogers.com at lists.sowder.com
[mailto:powerh-l-bounces+ken.langendock=rogers.com at lists.sowder.com] On
Behalf Of Lemvigh, Ole
Sent: March 9, 2011 10:58 AM
To: 'powerh-l at lists.sowder.com'
Cc: Ibarra-Hansen, Kjeld
Subject: [Bulk] Migrating from AIX/Oracle to Linux/SQL server
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.
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?
Is communication with the SQL server database from Powerhouse code
functioning, without any need for rewriting?
Any references to examples of successful migrations of this kind and/or
whitepapers, guidelines or other relevant material would be very much
appreciated.
Best regards,
Ole Henrik Lemvigh
________________________________________
Logica
Lautrupvang 10
DK-2750 Ballerup
Denmark
T: +45 21 71 72 65
E: ole.lemvigh at logica.com
www.logica.dk
Think green - keep it on the screen.
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.
--
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l at lists.sowder.com
Subscribe: 'subscribe' in message body to
powerh-l-request at lists.sowder.com
Unsubscribe: 'unsubscribe <password>' in message body to
powerh-l-request at 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.
Add 'site:lists.sowder.com powerh-l' to your search terms to search the
list
archive at Google.
--
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l at lists.sowder.com
Subscribe: 'subscribe' in message body to
powerh-l-request at lists.sowder.com
Unsubscribe: 'unsubscribe <password>' in message body to
powerh-l-request at 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.
Add 'site:lists.sowder.com powerh-l' to your search terms to search the
list archive at Google.
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.
------------------------------
--
= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l at lists.sowder.com
Subscribe: "subscribe" in message body to powerh-l-request at lists.sowder.com
Unsubscribe: "unsubscribe <password>" in message body to powerh-l-request at 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.
Add 'site:lists.sowder.com powerh-l' to your search terms to search the list archive at Google.
End of powerh-l Digest, Vol 70, Issue 2
***************************************
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sowder.com/pipermail/powerh-l/attachments/20110309/de238f09/attachment-0001.htm
More information about the powerh-l
mailing list