链接服务器到Oracle [英] Linked Server to Oracle
问题描述
我有一个Oracle（8.1）&带有
生产数据的SQL Server 2000数据库。在某些情况下，我需要来自
数据库的数据。我的第一选择是将Oracle链接到SQL并在一夜之间运行DTS
。但这将有1天的延迟，更不用说它需要的时间
。
1.有没有人试过通过Linked服务器实时访问Oracle？
性能有多好？
2. Oracle数据库相当大，所以我不赞成
一夜之间将整个事情复制到SQL中。是否有一种更简单的方法只能从Oracle获得更改的记录？
3.有更好的解决方案吗？
4.最后，如果我使用OPENROWSET或OPENQUERY，我可以动态地改变你传递它的SQL吗？例如可以查询接受
参数吗？
提前致谢
Sudhesh
Sudhesh Nayak写道：
我有一个Oracle（8.1）&带有生产数据的SQL Server 2000数据库。在某些情况下，我需要来自两个数据库的数据。我的第一选择是将Oracle链接到SQL并在一夜之间运行DTS。但这会有1天的延迟，更不用说它需要的时间。
1.有没有人尝试通过Linked服务器实时访问Oracle？
有多好性能如何？
2. Oracle数据库相当大，所以我有点不赞成将整个事情一夜之间复制到SQL中。是否有一种更简单的方法只能从Oracle获得更改的记录？
3.有更好的解决方案吗？
4.最后，如果我使用OPENROWSET或OPENQUERY，我可以动态地更改你传递的SQL吗？例如可以查询接受
参数吗？
提前致谢
Sudhesh
为什么不使用Oracle数据库链接用于实时访问SQL Server？
另请参阅Oracle的SQL Server透明网关以访问SQL
带有PL / SQL的
服务器。
< br $> b $ b -
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
da******@x.washington.edu
（将''x''替换为''u''来回复）
我需要从SQL转到Oracle作为Oracle db由公司内部的一个不同的团队拥有......我们哈哈更多（更好）访问
SQL框...
感谢您提出的建议
Sudhesh
Daniel Morgan< da ****** @ x.washington.edu>在消息新闻中写道：< 1072723371.798845@yasure> ...Sudhesh Nayak写道：
我有一个Oracle（8.1 ）&带有生产数据的SQL Server 2000数据库。在某些情况下，我需要来自两个数据库的数据。我的第一选择是将Oracle链接到SQL并在一夜之间运行DTS。但这会有1天的延迟，更不用说它需要的时间。
1.有没有人尝试通过Linked服务器实时访问Oracle？
有多好性能如何？
2. Oracle数据库相当大，所以我有点不赞成将整个事情一夜之间复制到SQL中。是否有一种更简单的方法只能从Oracle获得更改的记录？
3.有更好的解决方案吗？
4.最后，如果我使用OPENROWSET或OPENQUERY，我可以动态地更改你传递的SQL吗？例如查询是否可以接受
参数？
提前致谢
Sudhesh
为什么不使用Oracle数据库链接进行实时访问SQL Server？
另请参阅Oracle的SQL Server透明网关，以便使用PL / SQL访问SQL
服务器。
< blockquote> Sudhesh Nayak写道：
我需要从SQL转到Oracle，因为Oracle数据库由公司内部的不同组拥有...我们有更多（更好）的访问权限
SQL框...
感谢你提出的建议
Sudhesh
然后我会建议你和Oracle小组交谈。他们可能不会允许您通过您选择的任何方式访问他们的数据库，但是他们的DBA很可能会有他们想要放置的强大条件
你的活动：我知道我会的。
-
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
http：// www。 outreach.washington.edu/e...oa/aoa_crs.asp
da **** **@x.washington.edu
（将''x''替换为''u''来回复）
Hi,
I have an Oracle (8.1) & a SQL Server 2000 database with
Production data. There are situations when I need data from both the
databases. My first choice was to link Oracle to SQL and run DTS
overnight. But this would have a 1 day latency not to mention the time
it would take.
1. Has any one tried real time access via Linked server to Oracle?
How good is the performance?
2. The Oracle db is fairly big, so I''m kinda not in favor of
copying the whole thing over into SQL overnight. Is there an easier
way to just get only the changed records from Oracle?
3. Is there a better solution to this?
4. Lastly, if I use OPENROWSET or OPENQUERY, can I dynamically
change the SQL that you pass it? e.g. can the query accept a
parameter?
Thanks in advance
Sudhesh
Sudhesh Nayak wrote:
Hi,
I have an Oracle (8.1) & a SQL Server 2000 database with
Production data. There are situations when I need data from both the
databases. My first choice was to link Oracle to SQL and run DTS
overnight. But this would have a 1 day latency not to mention the time
it would take.
1. Has any one tried real time access via Linked server to Oracle?
How good is the performance?
2. The Oracle db is fairly big, so I''m kinda not in favor of
copying the whole thing over into SQL overnight. Is there an easier
way to just get only the changed records from Oracle?
3. Is there a better solution to this?
4. Lastly, if I use OPENROWSET or OPENQUERY, can I dynamically
change the SQL that you pass it? e.g. can the query accept a
parameter?
Thanks in advance
Sudhesh
Why not use an Oracle database link for real-time access to SQL Server?
Also look at Oracle''s SQL Server Transparent Gateway for accessing SQL
Server with PL/SQL.
--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
da******@x.washington.edu
(replace ''x'' with a ''u'' to reply)
I need to go from SQL to Oracle as the Oracle db is owned by a
different group within the company... We have more (better) access to
the SQL box...
Thanks for the suggestion though
Sudhesh
Daniel Morgan <da******@x.washington.edu> wrote in message news:<1072723371.798845@yasure>...Sudhesh Nayak wrote:Hi,
I have an Oracle (8.1) & a SQL Server 2000 database with
Production data. There are situations when I need data from both the
databases. My first choice was to link Oracle to SQL and run DTS
overnight. But this would have a 1 day latency not to mention the time
it would take.
1. Has any one tried real time access via Linked server to Oracle?
How good is the performance?
2. The Oracle db is fairly big, so I''m kinda not in favor of
copying the whole thing over into SQL overnight. Is there an easier
way to just get only the changed records from Oracle?
3. Is there a better solution to this?
4. Lastly, if I use OPENROWSET or OPENQUERY, can I dynamically
change the SQL that you pass it? e.g. can the query accept a
parameter?
Thanks in advance
Sudhesh
Why not use an Oracle database link for real-time access to SQL Server?
Also look at Oracle''s SQL Server Transparent Gateway for accessing SQL
Server with PL/SQL.
Sudhesh Nayak wrote:I need to go from SQL to Oracle as the Oracle db is owned by a
different group within the company... We have more (better) access to
the SQL box...
Thanks for the suggestion though
Sudhesh
Then I''d suggest you talk to the Oracle group. They will likely not
allow you to access their database by whatever means you choose but
their DBAs will likely have strong conditions they will want to place
you your activities: I know I would.
--
Daniel Morgan
http://www.outreach.washington.edu/e...ad/oad_crs.asp
http://www.outreach.washington.edu/e...oa/aoa_crs.asp
da******@x.washington.edu
(replace ''x'' with a ''u'' to reply)
这篇关于链接服务器到Oracle的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！
