Migrating from AIX/Oracle to Linux/SQL server

[Lemvigh, Ole]

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.