Oracle-L: RE: DATA MAPPING ISSUE

From: DENNIS WILLIAMS <DWILLIAMS_at_LIFETOUCH.COM>
Date: Wed, 15 Jan 2003 07:39:20 -0800
Message-ID: <F001.0053044A.20030115073920@fatcity.com>

Paula - I'm no expert in this area, but since I didn't notice a reply to your question . . .

Are relational constraints defined on these tables? If yes, then you have a simple task. If no, it is a bit more challenging. Recently someone here used Sybase Powerdesigner on a 100-table schema that didn't have constraints defined. The results were impressive. It managed to figure out correct relationships for most of the tables.

Dennis Williams
DBA, 40%OCP
Lifetouch, Inc.
dwilliams_at_lifetouch.com

-----Original Message-----
Sent: Tuesday, January 14, 2003 3:19 PM
To: Multiple recipients of list ORACLE-L

Guys,

Can anyone recommend a reasonably priced good data mapping tool that helps map legacy data to RDBMS's - Oracle and SQL Server and normalized to denormalized or normalized to different normalized schemas?

Thanks,
Paula

-----Original Message-----
<mailto:richard.ji_at_mobilespring.com> ]
Sent: Tuesday, January 14, 2003 3:10 PM To: Multiple recipients of list ORACLE-L

Really? I don't remember such a requirement. I think it works with or without MTS.

-----Original Message-----
Sent: Tuesday, January 14, 2003 2:34 PM To: Multiple recipients of list ORACLE-L

Is there a way to re-direct incoming database connection requests to another server? I believe Oracle Connection Manager can do this but it requires the database to be running in MTS mode. Is there another way? Thanks,

Ben

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net <http://www.orafaq.net>
--

Author: Ben
INET: poelsb_at_post.queensu.ca

Fat City Network Services -- 858-538-5051 http://www.fatcity.com <http://www.fatcity.com>
San Diego, California -- Mailing list and web hosting services

To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing).
--

Please see the official ORACLE-L FAQ: http://www.orafaq.net <http://www.orafaq.net>
--

Author: Richard Ji
INET: richard.ji_at_mobilespring.com

Fat City Network Services -- 858-538-5051 http://www.fatcity.com <http://www.fatcity.com>
San Diego, California -- Mailing list and web hosting services

--

Please see the official ORACLE-L FAQ: http://www.orafaq.net
--

Author: DENNIS WILLIAMS
INET: DWILLIAMS_at_LIFETOUCH.COM

Fat City Network Services    -- 858-538-5051 http://www.fatcity.com
San Diego, California        -- Mailing list and web hosting services
---------------------------------------------------------------------