MIgrate SQL Server 2005 to Oracle 10g

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

Sachin
sachin_dbaAsked:
Who is Participating?
 
sachin_dbaConnect With a Mentor Author Commented:
SP 4 did the connection for me.

Next problem is ....... SQL user definied datatypes are not the part of migration. Is there any work around for this, or we need to map these datatype manually.

Sachin
0
 
Tapan PattanaikSenior EngineerCommented:
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
0
 
tbsgadiCommented:
Hi sachin_dba,

Have a look at the following EE solution
http://www.experts-exchange.com/Microsoft/Development/MS-SQL-Server/SQL-Server-2005/Q_23931167.html


Good Luck!

Gary
0
Cloud Class® Course: CompTIA Cloud+

The CompTIA Cloud+ Basic training course will teach you about cloud concepts and models, data storage, networking, and network infrastructure.

 
sachin_dbaAuthor Commented:
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
0
 
Tapan PattanaikSenior EngineerCommented:
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.