如何将SQL Server转换为Oracle? [英] How to Convert SQL server to Oracle?

问题描述

我有一个SQL Server数据库(表，视图，SP ...).我需要将此数据库转换为Oracle 10g.我该怎么办?

I have a SQL server database (Tables, Views, SP...). I need to convert this database to Oracle 10g. How can I do it?

推荐答案

传输数据将很容易. SQL Server集成服务或Oracle的SQL Developer都可以做到这一点.

Transferring the data will be easy; SQL Server integration services can do that, or Oracle's SQL Developer.

但是，Oracle和SQL Server之间的视图和存储过程有所不同. SQL Server使用T-SQL，Oracle使用PL/SQL.这些不是很兼容，我不知道有什么工具可以在两者之间自动转换.如果您的数据库依赖于特定的T-SQL功能，则需要开发人员进行转换.

However, views and stored procedures are different between Oracle and SQL Server. SQL Server uses T-SQL, Oracle uses PL/SQL. These are not very compatible and I don't know a tool can automatically convert between the two. If your database relies on specific T-SQL features, you will need a developer to do the conversion.

这篇关于如何将SQL Server转换为Oracle?的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！