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

x
?
Solved

the best best product to transfer sql server database to oracle

Posted on 2011-05-11
10
Medium Priority
?
327 Views
Last Modified: 2012-05-11
the best best product to transfer sql server database to oracle
0
Comment
Question by:besttimes
  • 3
  • 3
  • 3
  • +1
10 Comments
 

Author Comment

by:besttimes
ID: 35736398
Dear,
we have MS SQL server DB and we need a tool or product to transfer its DB to Oracle.
i want to know what is the best best product to transfer sql server database to oracle.

Regards
Mohammad Fathallah
Fathallahm@arabsat.com
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 35736416
0
 

Accepted Solution

by:
besttimes earned 0 total points
ID: 35736467
Thanks, i found a product called "SQL WAYS" to do this transfer, what do you think?
i just want to use the best product achieving this objective, not any product .

Regards
0
Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 35736511
Used SQL Ways too which is also a good tool
0
 
LVL 23

Expert Comment

by:OP_Zaharin
ID: 35736950
- you can also consider Oracle SQL Developer tool (free and fully support by Oracle):
http://www.oracle.com/technetwork/database/migration/sqlserver-095136.html
0
 
LVL 57

Expert Comment

by:Raja Jegan R
ID: 35737021
>> We are receiving too many emails

I am wondering how this can be reason for deleting this question.
0
 
LVL 23

Expert Comment

by:OP_Zaharin
ID: 35737105
- step to migrate from SQL Server using Oracle SQL Developer
http://www.oracle.com/webfolder/technetwork/tutorials/obe/db/hol08/sqldev_migration/mssqlserver/migrate_microsoft_sqlserver_otn.htm

- you must also consider the datatype conversion regardless of the tool for the migration:
http://download.oracle.com/docs/html/B10544_01/apa.htm
0
 
LVL 23

Expert Comment

by:OP_Zaharin
ID: 35737688
- why choose to pay for any product when there is FREE SQL Server and Oracle migration tool provided by both product owner themself to do the migration? who know best of their own product? ;)

-Oracle have Migration Workbench and SQL Developer for migration from SQL Server
-SQL Server have SSIS and DTS for migration to Oracle database.
0
 

Author Closing Comment

by:besttimes
ID: 35767555
Thanks, i found a product called "SQL WAYS" to do this transfer, what do you think?
i just want to use the best product achieving this objective, not any product .
0

Featured Post

NFR key for Veeam Agent for Linux

Veeam is happy to provide a free NFR license for one year.  It allows for the non‑production use and valid for five workstations and two servers. Veeam Agent for Linux is a simple backup tool for your Linux installations, both on‑premises and in the public cloud.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

I remember the day when someone asked me to create a user for an application developement. The user should be able to create views and materialized views and, so, I used the following syntax: (CODE) This way, I guessed, I would ensure that use…
Shell script to create broker configuration file using current broker Configuration, solely for purpose of backup on Linux. Script may need to be modified depending on OS-installation. Please deploy and verify the script in a test environment.
This video explains what a user managed backup is and shows how to take one, providing a couple of simple example scripts.
This video shows how to copy an entire tablespace from one database to another database using Transportable Tablespace functionality.
Suggested Courses
Course of the Month19 days, 21 hours left to enroll

873 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question