[Bulk] Migrating from AIX/Oracle to Linux/SQL server

[Vidyasagar Goparaju]

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.