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

[Ken Langendock]

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.