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. [EMAIL PROTECTED] -----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:[EMAIL PROTECTED]> ] 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 Hi 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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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: [EMAIL PROTECTED] 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: [EMAIL PROTECTED] (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 -- Author: DENNIS WILLIAMS INET: [EMAIL PROTECTED] Fat City Network Services -- 858-538-5051 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: [EMAIL PROTECTED] (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).
