Converting from Oracle to MS SQL

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.
EDATSUSYSOPSAsked:
Who is Participating?
 
Eugene ZConnect With a Mentor Commented:
...  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
 
slightwv (䄆 Netminder) Commented:
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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.