db link - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

SQL Server 2008 Forums

SQL Server Administration (2008)

db link

Author

Topic

AgaK
Yak Posting Veteran

86 Posts

Posted - 2010-11-24 : 18:30:47

Hi,
I am looking for pros and cons for using database link between sql and oracle dbs vs export data from one system to a text file and import it to the other.
Thank you
AK

X002548
Not Just a Number

15586 Posts

Posted - 2010-11-24 : 18:39:32

If you do a join, Oracle will have no idea and send you all the data..try it, set up a trace and watch

If you do SELECT Cols INTO #temp From Oracle Table Where something

you might get better performance

But it's not hard to set up triggers to keep a Oracle stage table in synch real time

MOO

You'll need a 1 time feed first anyway

Brett

8-)

Hint: Want your questions answered fast? Follow the direction in this link
http://weblogs.sqlteam.com/brettk/archive/2005/05/25/5276.aspx

Want to help yourself?

http://msdn.microsoft.com/en-us/library/ms130214.aspx

http://weblogs.sqlteam.com/brettk/

http://brettkaiser.blogspot.com/

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources