Take the 2-minute tour ×
Server Fault is a question and answer site for professional system and network administrators. It's 100% free, no registration required.

We have a reasonably heavy Oracle 10G database (~ 120 GB space occupied). The database consists of tables, packages, materialized views, procedures etc. We are planning to decommission Oracle and migrate to SQL server 2008.

Can you provide your experience on this similar exercise? What is the best approach to undertake this exercise? Are there any tools available with Microsoft to implement this?

Once SQL server is commissioned, is it possible to connect SQL server to Oracle server in downstream applications?

share|improve this question

migrated from stackoverflow.com Feb 11 '11 at 16:10

This question came from our site for professional and enthusiast programmers.

4 Answers 4

I suspect that the greatest problem will be converting your PL-SQL code.

I have not used this tool, but I would definitely investigate Microsoft's own "SQL Server Migration Assistant for Oracle". 1

You should be able to connect SQL Server directly to Oracle using SQL Servers "Linked Server" feature. That will allow querying the Oracle data from a SQL Server client, without having to make a direct connection to the Oracle instance. If you have a 64 bit SQL Server, be sure that 64 bit database drivers for Oracle are installed and configured on the SQL Server host or the connectivity will not work.

share|improve this answer

The best work savings idea is to use Microsoft BI development studio and create Integration service project. Transformations and data analysis are excellent. Soft is free trial for 180 days... Regards Krzysztof K

share|improve this answer

I would recommend our DB migration tool from http://dbconvert.com/convert-oracle-to-mssql-pro.php

It is able to convert db structure and tables, but it's impossible to convert procedures and views for the moment :(

share|improve this answer

I have used SSMA and it give you a very good starting point. I would say it will try to convert all objects and can also give you a clue what the time estimate will be if you are going to re-write some of the codes. It is free and why not have a go.

Teshome Asfaw.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.