Solved

Converting from Oracle to MS SQL

Posted on 2011-02-22
3
301 Views
Last Modified: 2012-06-27
Due to the economy, we are being asked to switch our DB form Oracle to SQL. This particular DB is currnetly used by one application (one instance of Oracle is converting). I am really looking for some helpful commentary from someone who has maybe perfromed this task recently.
0
Comment
Question by:EDATSUSYSOPS
[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
3 Comments
 
LVL 77

Expert Comment

by:slightwv (䄆 Netminder)
ID: 34957323
What makes you think SQL server is so much cheaper than Oracle?  They are pretty much dollar for dollar these days.

You need to look at total cost of ownership.  A big piece of it is support and in-house staff.

If you are mainly a SQL Server shop with limited Oracle expertise, SQL server is probably cheaper in the long run.  The opposite also applies. Expert Oracle staff will struggle in SQL server.
0
 
LVL 43

Accepted Solution

by:
Eugene Z earned 500 total points
ID: 34959643
...  What oracle version do you run?
###################################################
before you Start using SQL Server Migration Assistant for Oracle (SSMA for Oracle)
http://www.microsoft.com/sqlserver/2005/en/us/migration-oracle.aspx
#
check
Microsoft SQL Server 2008: SQL Server 2008 Compared to Oracle ...
Learn how Microsoft SQL Server has steadily gained ground on other database systems and now surpasses the competition in terms of performance, scalability, ...
http://www.microsoft.com/sqlserver/2008/en/us/sql2008-oracle11g.aspx¿
#
SQL Server 2008 for Oracle DBA
This workshop provides a quick start for the Oracle DBA to map, compare, and ...
technet.microsoft.com/en-us/sqlserver/dd548020
0

Featured Post

Free Tool: IP Lookup

Get more info about an IP address or domain name, such as organization, abuse contacts and geolocation.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

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

Ever needed a SQL 2008 Database replicated/mirrored/log shipped on another server but you can't take the downtime inflicted by initial snapshot or disconnect while T-logs are restored or mirror applied? You can use SQL Server Initialize from Backup…
The Delta outage: 650 cancelled flights, more than 1200 delayed flights, thousands of frustrated customers, tens of millions of dollars in damages – plus untold reputational damage to one of the world’s most trusted airlines. All due to a catastroph…
Viewers will learn how to use the INSERT statement to insert data into their tables. It will also introduce the NULL statement, to show them what happens when no value is giving for any given column.
Viewers will learn how to use the SELECT statement in SQL to return specific rows and columns, with various degrees of sorting and limits in place.

623 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