Dear Experts

 We are having a web application build with combination of following technologies

Classic ASP 3.0
ASP.Net 1.0(Using VB.net)
ASP with VB Com DLLs
MS SQL Server 2000
Crystal Report 9

We are planning to change our database from MS SQL Server 2000 to Oracle 9i according to me following are the activities involved in this process.

1. Migration of SQL DB to Oracle DB (All the objects: Table, Views, Store Procedure, Functions, Cursor, SQL Jobs etc.)

2. Identify all the compatibility issues when migrating between Databases.

3. ASP.Net, Classic ASP 3.0, ASP with VB Com Components

A. All the .vb .asp pages including common Classes where SQL Server specific code is written i.e. references of System.Data.SqlClient, Objects of ADODB using SQL Server native Drivers and syntax level changes with reference to this changes, changes incompatible in open queries written at the Page Level.
B. Changes in VB Com classes for DB connectivity and various DB operation as well as managing Open Queries written in the various functions

4. Any Changes required for Crystal Reports developed using MS SQL Server to work with Oracle 9i.


Doing all these changes manually will turn to very big and time consuming activity, hence I am looking for any Automated Tool which can help me to complete this activity

For Point 1 i.e. Database Conversation, I have found various tools but i am not able to find out any tool which will help me in doing 3rd and 4th point. Please help me in identifying such tools.

Thanks & Regards
N. B. Sapkal

Hi Netaji,

We too were searching for answer to question-4 raised by you - what to do while migrating crystal reports developed with MS SQL server to work with Oracle 9i.

Strange that no one has any answers for this. Have you got any?

reg,
rajdori