Solved

Converting from Oracle to MS SQL

Posted on 2011-02-22
3
290 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
3 Comments
 
LVL 76

Expert Comment

by:slightwv (䄆 Netminder)
Comment Utility
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 42

Accepted Solution

by:
EugeneZ earned 500 total points
Comment Utility
...  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

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

JSON is being used more and more, besides XML, and you surely wanted to parse the data out into SQL instead of doing it in some Javascript. The below function in SQL Server can do the job for you, returning a quick table with the parsed data.
Slowly Changing Dimension Transformation component in data task flow is very useful for us to manage and control how data changes in SSIS.
This video shows how to recover a database from a user managed backup
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.

728 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

Need Help in Real-Time?

Connect with top rated Experts

8 Experts available now in Live!

Get 1:1 Help Now