RE: Oracle vs SQL Server
- From: "Bryan Thomas" <bthomas@xxxxxxxxxxxxxx>
- To: <sbecker6925@xxxxxxxxx>, "'oracle-l'" <oracle-l@xxxxxxxxxxxxx>
- Date: Sun, 1 Oct 2006 14:05:39 -0500
Sandy,
Microsoft has a tool for this called the SQL Server Migration Assistant.
You can download it for free. Run it on a windows machine with an Oracle
client against your current Oracle database. It will give you a man hour
estimate for migrating to SQL Server. This tool will transfer your schema's
to SQL Server.
I have used the tool several times. Even with Microsoft's help, it normally
comes out to 2000 to 5000 man hours. It does a bad job of migrating PL/SQL
to T-SQL.
Here is the link http://www.microsoft.com/sql/migration.
Thanks,
Bryan
_____
From: oracle-l-bounce@xxxxxxxxxxxxx [mailto:oracle-l-bounce@xxxxxxxxxxxxx]
On Behalf Of Sandra Becker
Sent: Sunday, October 01, 2006 12:35 PM
To: oracle-l
Subject: Oracle vs SQL Server
My boss believes that if Oracle can't come down in price to that of SQL
Server, we should just switch. I have never used SQL Server so I had
nothing to draw on other than what I've heard. We're a small company with
limited financial resources, but I believe the decision should be based on
more than strictly price. To that end I have three questions.
1. Is there an article comparing either 9i or 10g (currently on 9i Standard
One Edition preparing to migrate to 10g Standard Edition) with SQL Server
2005? We run on RHEL3 and will be moving to RHEL4 within then next
month or so on a Dell 64 bit dual core server. I have reviewed the articles
mentioned on Tom Kyte's website, but nothing did a comparison of Oracle
and SQL Server 2005, which is the release my boss is considering.
2. I know absolutely nothing about Java code. We develop and deploy Java
code for a very specific application for a specific industry. The code uses
PL/SQL procedures and sequences extensively. It also uses a db_link to
move data from production to a demo database for our new customers and
for demonstrating new features for current customers. What might be
involved in changing the code? Would it need to be changed at all?
Obivously,
it would have be tested under load.
I would appreciate any information that will help us make an informed
decision rather than a knee-jerk reaction to pricing structures.
Thank you.
Sandy
Other related posts:
