Solved

Migrating Oracle Schema to SQL Server 2008R2

Posted on 2013-01-09
7
561 Views
Last Modified: 2013-01-14
I have found links on Microsoft's website to a SQL Server Migration Assistant (SSMA) for Oracle. Some of them only give information, or instructions for installing. The one link that actually references the download takes me to a Certification and Training website. Does someone have the full link to retrieve the download file(s) for the SSMA? We are running SQL Server 2008 R2 and Oracle 10g.
0
Comment
Question by:dbbishop
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
7 Comments
 
LVL 22

Accepted Solution

by:
Steve Wales earned 500 total points
ID: 38761135
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 38761161
sjwales provided the correct answer and deserves the points but I was curious how hard you looked?

It took 3 seconds with Google to have the link above be the first one:
http://www.google.com/#hl=en&q=SSMA+for+Oracle+download
0
 
LVL 21

Expert Comment

by:Alpesh Patel
ID: 38761770
The best tool provided by Microsoft "SQL Server Migration tool for Oracle"
0
Technology Partners: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

 
LVL 15

Author Comment

by:dbbishop
ID: 38772872
slightwv: Quite a bit. I navigated quite a few MS links and got to documentation about SSMA, information about SSMA, and other links, but not to the actual download itself.

I don't mind someone asking me a question for clarification, but do not appreciate condescending comments, as I am sure no one does. I come to this site for answers to questions, and I've given quite a few answers myself. I hope that my rank as Wizard in the SQL Server zone would attest to the fact that I do know enough to follow links and have given back somewhat to the EE community.
0
 
LVL 15

Author Comment

by:dbbishop
ID: 38772873
Thank you.
0
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 38774201
Sorry if my post cam across as condescending.  That was not the intent.

I also think you should have accepts sjwales post since it was the correct answer.

I'll have a Moderator take care of this.
0

Featured Post

Announcing the Most Valuable Experts of 2016

MVEs are more concerned with the satisfaction of those they help than with the considerable points they can earn. They are the types of people you feel privileged to call colleagues. Join us in honoring this amazing group of Experts.

Question has a verified solution.

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

Suggested Solutions

Title # Comments Views Activity
running myfile.SQL from command line SQLPLUS 12c does not exit. 7 52
sql query 5 57
Tracking Problematic Page Splits 1 49
oracle query 4 30
Using SQL Scripts we can save all the SQL queries as files that we use very frequently on our database later point of time. This is one of the feature present under SQL Workshop in Oracle Application Express.
When it comes to protecting Oracle Database servers and systems, there are a ton of myths out there. Here are the most common.
This video shows how to copy a database user from one database to another user DBMS_METADATA.  It also shows how to copy a user's permissions and discusses password hash differences between Oracle 10g and 11g.
This videos aims to give the viewer a basic demonstration of how a user can query current session information by using the SYS_CONTEXT function

732 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