RE: Compare (diff) Oracle DB and MS-SQLServer DB

Well, how about creating a common source file for both databases? Say, a delimited ascii file that can be read into either db using sql*loader and bcv. If you load all new instances of either database from the common source, it would at least ensure parity at the start.

For ongoing data-syncing, I'd investigate someof the replication management software from Sybase, Quest, Oracle (generic or heterogeneous services), SQL Server's utility (I forget the name), etc.

Scott Shafer
San Antonio, TX
210-581-6217

> -----Original Message-----
> From: Ray Gordon [SMTP:rgordon_1_at_hotmail.com]
> Sent: Thursday, April 18, 2002 3:40 PM
> To: Multiple recipients of list ORACLE-L
> Subject: Re: Compare (diff) Oracle DB and MS-SQLServer DB
>
> We do have to deploy our software on both ORACLE and MS-SQLServer,
> depending
> on customer deployment/request. So, we need both databases anyway...
> whether we go from SQLServer to Oracle, or the other way... the issues
> will
> be the same.
>
>
> Ray
>
>
> >From: "Tim Gorman" <Tim_at_SageLogix.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:48:45 -0800
> >
> >...this is even worse than the myth that programming to the ANSI SQL
> >standard will allow you to port an application between RDBMS products,
> such
> >as Oracle and SQL Server... :-)
> >
> >Oracle does not charge for development usage of it's products. That's
> why
> >all software is downloadable for free from OTN. It is when you try to
> seek
> >support that you should be properly licensed. That takes care of the
> cost
> >issue...
> >
> >As far as the "skills" issue, the investment in learning how to install
> an
> >Oracle development environment for an Oracle-based production system
> would
> >be more than justified by the cost you are going to incur trying to put
> an
> >application developed under SQL Server into an Oracle production system.
> >"Pay" up now, or "pay" up later...
> >
> >This question of a script or tool to determine deltas is only the first
> of
> >many installments of the "pay up later" choice...
> >
> >----- Original Message -----
> >To: "Multiple recipients of list ORACLE-L" <ORACLE-L_at_fatcity.com>
> >Sent: Thursday, April 18, 2002 11:28 AM
> >
> >
> > > 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).
> >
> >--
> >Please see the official ORACLE-L FAQ: http://www.orafaq.com
> >--
> >Author: Tim Gorman
> > INET: Tim_at_SageLogix.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).
>
>
>
> _________________________________________________________________
> 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).

-- 
Please see the official ORACLE-L FAQ: http://www.orafaq.com
-- 
Author: 
  INET: Scott.Shafer_at_dcpds.cpms.osd.mil

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).