Hi,

I have developped a lot of DTS packages on an SQL Server database.
1 of our client use Oracle instead-of SQL server for the same database (same
schema)

I want to use a linked server + views in an SQL Server database:

create view MyTable
as
select * from ORACLESERVER...MyTable

So my SQL Server database contain only views with the same names as the
Oracle table names.
This works.
So my DTS packages could use this "fucky" SQL Server database and I dont
have to change the SQL syntaxes.
But I want to know the performance impact and the known limitations using
complex queries (10 tables with sub-query joins, outer join etc...) .

1 of my queries could return more then 1 000 000 rows (1million)
Does it better to rewrite the query in an Oracle statement and change my DTS
package?

Thanks for your guides.

Jerome.

If you really want to knwo then try it. In my experience, using joins, or
predicates though linked servers is just asking for trouble. I would
re-write and point the DataPump directly at Oracle. The SQL shouldn't be
that different to just grab some data.

--
Darren Green
http://www.sqldts.com
http://www.sqlis.com


"Jéjé" <willgart_A_ (AT) hotmail_A_ (DOT) com> wrote

the syntax is somewhat so different this cause rewriting the SQL statement
is not a simple copy/paste, but the entire query must be rewritten.

but from my first tests, the performance is really different between linked
server and direct Oracle SQL, so... I'll convert my queries.


"Darren Green" <darren.green (AT) reply-to-newsgroup-sqldts (DOT) com> wrote