| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> RE: Compare (diff) Oracle DB and MS-SQLServer DB - DBArtisan
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" <mark_at_cool-tools.co.uk>
>Reply-To: ORACLE-L_at_fatcity.com
>To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
>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: mark_at_cool-tools.co.uk
>===================================================
> 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 <jraube_at_yahoo.com>
> >Reply-To: ORACLE-L_at_fatcity.com
> >To: Multiple recipients of list ORACLE-L <ORACLE-L_at_fatcity.com>
> >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 <rgordon_1_at_hotmail.com> 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: rgordon_1_at_hotmail.com
> > >
> > > 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: 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).
> >
> >
> >__________________________________________________
> >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: jraube_at_yahoo.com
> >
> >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: 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).
>
>
>
>
>_________________________________________________________________
>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: rgordon_1_at_hotmail.com
>
>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: 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.com
>--
>Author: Mark Leith
> INET: mark_at_cool-tools.co.uk
>
>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: 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.com -- Author: Ray Gordon INET: rgordon_1_at_hotmail.com 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: 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).Received on Fri Apr 26 2002 - 14:04:22 CDT
 |
 |