[Webinar] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1692
  • Last Modified:

MIgrate SQL Server 2005 to Oracle 10g

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

Sachin
0
sachin_dba
Asked:
sachin_dba
  • 3
  • 2
1 Solution
 
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
 
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
Get your Conversational Ransomware Defense e‑book

This e-book gives you an insight into the ransomware threat and reviews the fundamentals of top-notch ransomware preparedness and recovery. To help you protect yourself and your organization. The initial infection may be inevitable, so the best protection is to be fully prepared.

 
Tapan PattanaikSenior EngineerCommented:
0
 
sachin_dbaAuthor 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

Featured Post

Get free NFR key for Veeam Availability Suite 9.5

Veeam is happy to provide a free NFR license (1 year, 2 sockets) to all certified IT Pros. The license allows for the non-production use of Veeam Availability Suite v9.5 in your home lab, without any feature limitations. It works for both VMware and Hyper-V environments

  • 3
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now