asked on

MIgrate SQL Server 2005 to Oracle 10g

What are the steps to convert SQL Server 2005 database to Oracle 10G database.

Sachin

hi sachin_dba,

SQL Server 2005 Migration to Oracle 10g :

http://forums.oracle.com/forums/thread.jspa?threadID=365550&tstart=0

http://www.oracle.com/technology/tech/migration/workbench/index_sqldev_omwb.html

example:

A SQL Server Migration ("Northwind") is performed.

http://www.oracle.com/technology/tech/migration/workbench/viewlets/sqlserver.html

The steps are outlined in the doc here
http://download.oracle.com/docs/cd/E10405_01/doc/appdev.120/e10406/migration.htm

You can find more viewlets here
http://www.oracle.com/technology/tech/migration/workbench/files/sdmwb_viewlets.html

And the main SQL Developer Migration Workbench OTN page (which links to everything) here
http://www.oracle.com/technology/tech/migration//workbench/index_sqldev_omwb.html

ASKER

I am not able to connect SQL Server 2000 database to SQL Developer.

Snapshots attached.

Is it because of SQL Server 2000, version 2005 is mandatory?

Please review the setting and let me know if there is something missing.
SQL-Server-Service-Manager.JPG
Third-party-JDBC-Driver-Path.JPG
New-DB-Connection.JPG

ASKER CERTIFIED SOLUTION

membership

This solution is only available to members.

To access this solution, you must be a member of Experts Exchange.