Spent some long hours on DBArtisan...nice looking tool. However, it does not allow simultaneous connections for a compare. In fact, it does not have the word "compare" in its vocabulary/help/contents/find/index... Well, it "does not compare".
So in conclusion, I think NO TOOL EXISTS that compares Oracle and SQLServer. I now open the floor to sql scripts, just send me anything that will help, and which we can modify. I would like to thank Raj Shakti for sending a compare script for comparison between two Oracle users. I will forward this to the group. Ray >From: "Mark Leith" <[EMAIL PROTECTED]> >Reply-To: [EMAIL PROTECTED] >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> >Subject: RE: Compare (diff) Oracle DB and MS-SQLServer DB >Date: Fri, 19 Apr 2002 01:23:22 -0800 > >Ray, > >Have you looked at Embarcardero's DBArtisan tool? I'm not sure if it will >do >an active compare of the schemas etc. but it certainly works on both Oracle >and SQLServer concurrently, and is in the "ballpark" that you are looking >for.. > >May be worth checking it out: > >www.embarcadero.com > >HTH > >Mark > >=================================================== > Mark Leith | T: +44 (0)1905 330 281 > Sales & Marketing | F: +44 (0)870 127 5283 > Cool Tools UK Ltd | E: [EMAIL PROTECTED] >=================================================== > http://www.cool-tools.co.uk > Maximising throughput & performance > >-----Original Message----- >Sent: 18 April 2002 21:24 >To: Multiple recipients of list ORACLE-L > > >Mostly schema (tables, views, indexes, ...) and if possible data (reference >tables). > >Now, ERWin... I dont think so...not a good idea to use an ER tool. We >would >end up unnecessarily managing a model within ERWin, and we would have to >retrofit the model (complete compare) each time before running the compare. >Such a pain, and I would have to hire another person and keep paying >another >salary just to do this. I want to reduce my headcount not increase it. > >What we need is a very simple utility. Something like TOAD. But TOAD only >works for ORACLE and does not let you set conditions, so it will be useless >here. > >While I am dreaming... lets continue. We need something like an ADVANCED >TOAD, i.e. which not only identifies the diffs but shows the deltas >exactly, >and which allows us to set conditions for the compare (eg: ignore >tablespace, ignore INITIAL, ignore datatype, etc.). > >Ray > > > >From: Joe Raube <[EMAIL PROTECTED]> > >Reply-To: [EMAIL PROTECTED] > >To: Multiple recipients of list ORACLE-L <[EMAIL PROTECTED]> > >Subject: Re: Compare (diff) Oracle DB and MS-SQLServer DB > >Date: Thu, 18 Apr 2002 10:42:37 -0800 > > > >Diff of what? Data? Schema? Stored procs? > > > >Depends on what you need -- ERwin or another ER tool may be able to > >help find schema diffs... > > > >--- Ray Gordon <[EMAIL PROTECTED]> wrote: > > > One of our teams started programming in SQLServer, but now we are > > > live in a > > > production ORACLE environment. Due to several issues, such as > > > licensing,skills, etc., the development must stay on SQLServer. > > > > > > Is there a tool or whatever to find out the deltas between a > > > SQLServerDB > > > and an Oracle DB? Or any suggestions. > > > > > > Ray > > > > > > > > > _________________________________________________________________ > > > Send and receive Hotmail on your mobile device: > > > http://mobile.msn.com > > > > > > -- > > > Please see the official ORACLE-L FAQ: http://www.orafaq.com > > > -- > > > Author: Ray Gordon > > > INET: [EMAIL PROTECTED] > > > > > > Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > > > San Diego, California -- Public Internet access / Mailing > > > Lists > > > > >-------------------------------------------------------------------- > > > 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). > > > > > >__________________________________________________ > >Do You Yahoo!? > >Yahoo! Tax Center - online filing with TurboTax > >http://taxes.yahoo.com/ > >-- > >Please see the official ORACLE-L FAQ: http://www.orafaq.com > >-- > >Author: Joe Raube > > INET: [EMAIL PROTECTED] > > > >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 > >San Diego, California -- Public Internet access / Mailing Lists > >-------------------------------------------------------------------- > >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). > > > > >_________________________________________________________________ >MSN Photos is the easiest way to share and print your photos: >http://photos.msn.com/support/worldwide.aspx > >-- >Please see the official ORACLE-L FAQ: http://www.orafaq.com >-- >Author: Ray Gordon > INET: [EMAIL PROTECTED] > >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California -- Public Internet access / Mailing Lists >-------------------------------------------------------------------- >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.com >-- >Author: Mark Leith > INET: [EMAIL PROTECTED] > >Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 >San Diego, California -- Public Internet access / Mailing Lists >-------------------------------------------------------------------- >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). _________________________________________________________________ MSN Photos is the easiest way to share and print your photos: http://photos.msn.com/support/worldwide.aspx -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ray Gordon INET: [EMAIL PROTECTED] Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists -------------------------------------------------------------------- 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).
