从SQL Server 2008迁移到oracle数据库. [英] Migration from SQL Server 2008 to oracle database.

问题描述

亲爱的所有人，

我正在开发基于Web的项目(ASP.net)，后端是sql server2008.我正在使用sql server 2008开发应用程序.现在，我想将数据库从sql server 2008迁移到oracle 11g.你能告诉我如何在不更改应用程序代码的情况下做到这一点吗?
谢谢！.

Dear All,

I am working on the web based project(ASP.net) where backend is sql server 2008. i am developing the application using sql server 2008. now i want to migrate my database from sql server 2008 to oracle 11g. can u please tell me how can i do it without changing my application code.
Thanks!.

推荐答案

看看这个链接:
http://forums.oracle.com/forums/thread.jspa?threadID=843319& tstart = 0 [ ^ ]

Have a look at this link:
http://forums.oracle.com/forums/thread.jspa?threadID=843319&tstart=0[^]

我正在做一个类似的项目-我们的应用程序现在可以与MS Access和SQL Server 2000/2005一起使用，并且还必须能够与Oracle一起运行.尽管尚未完全完成该操作，但我已经可以告诉您，您将不得不更改许多代码. Oracle无法理解甚至Access都知道的许多数据类型，例如指导许多表可能都有一些自动递增的数字作为主键-使用Access或SQL Server只是相应列的一个属性，在Oracle中，您还需要一个序列和一个触发器...为了检索最后一个如果插入ID，则无法执行选择@@ Identity"，但必须查询相应序列的CURRVAL.在自动迁移过程中，几个表/列被重命名，例如用户"变为"USER_".这是很多工作，并且SQL查询中的任何单词都几乎保持不变！

I am just doing a similar project - our application works now with MS Access and SQL Server 2000/2005, and has to be able run with Oracle also. Though not yet having accomplished that completely, I can tell you already that you will have to change lots of your code. Oracle does not understand many data types which even Access knows, e.g. Guid. Many tables likely have some auto-incrementing number as a primary key - with Access or SQL Server that''s simply a property of the respective column, in Oracle you will need a sequence and a trigger also... And for retrieving that last inserted ID, you cannot do a "Select @@Identity" but you have to query the CURRVAL of the respective sequence. Several tables/columns were renamed during automatic migration, e.g. "User" became "USER_". It is lots of work, and hardly any word of a SQL query will remain the same!

这篇关于从SQL Server 2008迁移到oracle数据库.的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！