RE: SQL Server DTS
- To: <Jeff.Wiegand@xxxxxxxxxxx>, <oracle-l@xxxxxxxxxxxxx>
- Date: Tue, 12 Jul 2005 11:01:43 -0700
Hi Jeff,
I have a customer that regularly runs DTS extracts from their Oracle database
and we haven't had any problems so far, but the queries they run are pretty
large, generating a lot physical reads. I think that's the main thing to watch
out for (as with anyone writing any queries against your database) - just don't
let them bog down the database. We haven't had any trouble with locking -
they're just running SELECTs. I've thought about replicating to another
instance, but haven't had the need yet. By replicating to another schema in
the same database, seems like you'd just be adding more overhead - one set of
reads from the source tables, then writes to the replicated tables, then
another set of reads from the replicated tables by the DTS extracts - probably
just better off to let them select from the original tables.
Regards,
Brandon
-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx
[mailto:oracle-l-bounce@xxxxxxxxxxxxx]
Sent: Tuesday, July 12, 2005 10:48 AM
To: oracle-l@xxxxxxxxxxxxx
Subject: SQL Server DTS
Good Day.
We have a group of folks with limited Oracle experience who are looking
to use SQL Server DTS packages to pull data from our Oracle server to
populate a SQL Server data warehouse.
I have limited experience with DTS. One concern is the locking behavior
that we'd see and all the other crap that comes with SQL Server.
Does anyone use DTS in this way? Wouldn't I be better off replicating
the requisite data to a different schema and letting them run their DTS
packages against that schema, rather than running directly against
production tables?
Thanks,
jeff
--
//www.freelists.org/webpage/oracle-l
Privileged/Confidential Information may be contained in this message or
attachments hereto. Please advise immediately if you or your employer do not
consent to Internet email for messages of this kind. Opinions, conclusions and
other information in this message that do not relate to the official business
of this company shall be understood as neither given nor endorsed by it.
--
//www.freelists.org/webpage/oracle-l
Other related posts:
