Problem solve Get help with specific problems with your technologies, process and projects.

Migrating ASP app from SQL Server to Oracle

I was given an application written in ASP for SQL Server 2000. It's my first experience with .asp file. Can you give pointers regarding converting these .asp files over to an Oracle database? What's the best method, convert it to .jsp files, or another type? Can I use ODBC to import the app over to Oracle?
Well before you migrate the ASP (Active Server Pages) application to Java (J2EE) and Oracle9i open environments, you must first convert the Database running in SQL Server 2000 to Oracle database, say Oracle9i.

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:

Technology Description
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

Migration Tool

This is a GUI-based application. It is used to migrate and package the ASP application for deployment.

Bean Creator

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

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.

COM Services

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.

Dig Deeper on Using Oracle PL-SQL

Have a question for an expert?

Please add a title for your question

Get answers from a TechTarget expert on whatever's puzzling you.

You will be able to add details on the next page.

Start the conversation

Send me notifications when other members comment.

Please create a username to comment.