Oracle Corp. provides a free tool called Oracle9i Migration Workbench that you can use to convert the database from SQL Server to Oracle9i.
Now, in order to migrate the ASP application, you will need the Oracle9iAS Migration Kit for ASP.
Oracle9iAS Migration Kit for ASP supports most major technologies used by ASP applications, including some popular third-party components:
|IIS||Version 4.x and 5.x|
|ASP||Version 2.x and 3.x|
|ASP COM and COM+||Component Object Model for Windows NT 4.0 and Windows 2000|
|MTS||Microsoft Transaction Server for Windows NT 4.0 and Windows 2000|
|Third-party components||ASPChart, ASPExec, ASPFileUp, ASPGrid, ASPHTTP, ASPImage, ASPINET, ASPMail, ASPNNTP,ASPPOP3, ASPSock, ASPUpload|
The four major components of Oracle9iAS Migration Kit are
This is a GUI-based application. It is used to migrate and package the ASP application for deployment.
If the ASP application that you are migrating uses COM objects, Bean Creator creates Java Beans that allow the migrated application to access the COM objects used by the original application.
Runtime Services is a Java servlet application and it runs inside Oracle9iAS containers for J2EE (OC4J). It enables the migrated application to run in a J2EE environment within Oracle9iAS.
If you want to use existing native Windows code, COM services enables the migrated Java application to do so.
PLEASE NOTE: There are a small number of ASP object models that the migration tool cannot convert. The product documentation provides some possible work around. You may want to review them. Also, remember that WINDOWS environment may be case insensitive but UNIX environment is not.
This was first published in February 2004