从ORACLE中存在的表在SQL Server中创建视图 [英] create view in SQL Server from table present in ORACLE

问题描述

大家好.

我想在SQL Server数据库中创建视图(实体视图)，DB表存在于ORACLE数据库和另一台服务器上.

方案是::我的应用程序仅使用sql server数据库.并通过应用程序我想要选择/更新/插入/删除ORACLE表数据.

我尝试使用授予权限/创建数据库链接.
我在ORACLE中创建了一个数据库链接..并使用该链接我想创建视图...尝试的第二个选项是GRANT操作...

假设我只能访问一个数据库名称"sushil".

其中包含一个用户"UserABC"，因此我可以说创建数据库链接并将其提供给我用于访问数据的第三方.....

但我不知道确切的步骤..

谁能帮帮我.

感谢进阶

问候
Sushilkumar Bondre

hi all.

i want to create view (materialzied view) in SQL Server Database, DB tables are present on ORACLE database and on another server.

Scenario is :: my application is using sql server database only. and through application i want to select/update/insert/delete ORACLE Table data.

i tried using granting permissions / creating database link.
i created a Database link in ORACLE .. and using that link i want to creating view... second option tried is GRANT operation...

suppose i am having access only to only one database name "sushil".

which contains a user "UserABC" so i can say third party that create a database link and give it to me for accessing data.....

but i dont know the exact steps..

can anyone help me out.

Thank in Advanced

Regards
Sushilkumar Bondre

推荐答案

我唯一看到的解决方案是在SQL Server中借助C#CLR创建存储过程，并执行选择/更新/插入/删除操作在这些过程中，使用ODBC/OLE db连接到Oracle.
或者甚至可以为SQL Server创建程序集，以包装整个ADO.Net函数的批处理:execute，executeScalar，executeNonScalar，并保持与Oracle的连接.

The only solution that I can see is to create Stored Procedures with aid of C# CLR in SQL Server, and to perform select/update/insert/delete inside these procedures using ODBC/OLE db connection to Oracle.
Or you may even create assembly for SQL Server to wrap the whole ADO.Net functions'' batch: execute, executeScalar, executeNonScalar, and keep connection to Oracle as well.

这篇关于从ORACLE中存在的表在SQL Server中创建视图的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！