RE: SQL Server DTS

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_at_freelists.org
[mailto:oracle-l-bounce_at_freelists.org]
Sent: Tuesday, July 12, 2005 10:48 AM
To: oracle-l_at_freelists.org
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
--

http://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.

--

http://www.freelists.org/webpage/oracle-l Received on Tue Jul 12 2005 - 13:02:58 CDT