Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Data compare Sybase and Oracle

4 posts in General Discussion Last posting was on 2009-11-12 20:35:20.0Z
Yog Posted on 2009-11-06 18:15:07.0Z
Sender: 3352.4af46104.1804289383@sybase.com
From: Yog
Newsgroups: sybase.public.ase.general
Subject: Data compare Sybase and Oracle
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <4af467ab.3458.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 6 Nov 2009 10:15:07 -0800
X-Trace: forums-1-dub 1257531307 10.22.241.41 (6 Nov 2009 10:15:07 -0800)
X-Original-Trace: 6 Nov 2009 10:15:07 -0800, 10.22.241.41
Lines: 12
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28622
Article PK: 77864

Situation:
Sybase database (core application database & source of
truth) is replicated to Oracle database using Data mirror.
Both are in production. Application
programs/interfaces/reports use Oracle for querying (select
only).

To prove that the data in Oracle is not changed, whats the
best way to compare Sybase and Oracle.

Thank you
Yog


Rob V [ Sybase ] Posted on 2009-11-06 19:51:32.0Z
Reply-To: "Rob V [ Sybase ]" <robv@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY>
From: "Rob V [ Sybase ]" <robv@DO.NOT.SPAM.sypron.nl.REMOVE.THIS.DECOY>
Newsgroups: sybase.public.ase.general
References: <4af467ab.3458.1681692777@sybase.com>
Subject: Re: Data compare Sybase and Oracle
Lines: 47
Organization: Sypron BV / TeamSybase / Sybase
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4af47e44$1@forums-1-dub>
Date: 6 Nov 2009 11:51:32 -0800
X-Trace: forums-1-dub 1257537092 10.22.241.152 (6 Nov 2009 11:51:32 -0800)
X-Original-Trace: 6 Nov 2009 11:51:32 -0800, vip152.sybase.com
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28623
Article PK: 77865

Do things like creating checksums of each column, e.g. adding up all
customer ID numbers. The sum isn't a meaningful number, but if the number of
rows are identical and this sum is identical, it's reasonably likely that
the data is identical -- at least for that column.

You have to be a bit creative here....
You can also do things like copy the table from Oracle to Sybase (or the
other way around) and then compare the two tables. Either with a
well-written join, or by copying both tables to a file and diff'ing the
files.

HTH,

Rob V.
-----------------------------------------------------------------
Rob Verschoor

Certified Sybase Professional DBA for ASE 15.0/12.5/12.0/11.5/11.0
and Replication Server 15.0.1/12.5 // TeamSybase

Author of Sybase books (order online at www.sypron.nl/shop):
"Tips, Tricks & Recipes for Sybase ASE" (ASE 15 edition)
"The Complete Sybase ASE Quick Reference Guide"
"The Complete Sybase Replication Server Quick Reference Guide"

mailto:rob@YOUR.SPAM.sypron.nl.NOT.FOR.ME
http://www.sypron.nl
Sypron B.V., Amersfoort, The Netherlands
Chamber of Commerce 27138666
-----------------------------------------------------------------

<Yog> wrote in message news:4af467ab.3458.1681692777@sybase.com...
> Situation:
> Sybase database (core application database & source of
> truth) is replicated to Oracle database using Data mirror.
> Both are in production. Application
> programs/interfaces/reports use Oracle for querying (select
> only).
>
> To prove that the data in Oracle is not changed, whats the
> best way to compare Sybase and Oracle.
>
> Thank you
> Yog


Eugene Posted on 2009-11-10 17:08:43.0Z
From: Eugene <ekorolkov@davidsohn.com>
User-Agent: Thunderbird 2.0.0.23 (Windows/20090812)
MIME-Version: 1.0
Newsgroups: sybase.public.ase.general
Subject: Re: Data compare Sybase and Oracle
References: <4af467ab.3458.1681692777@sybase.com>
In-Reply-To: <4af467ab.3458.1681692777@sybase.com>
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <4af99e1b$1@forums-1-dub>
Date: 10 Nov 2009 09:08:43 -0800
X-Trace: forums-1-dub 1257872923 10.22.241.152 (10 Nov 2009 09:08:43 -0800)
X-Original-Trace: 10 Nov 2009 09:08:43 -0800, vip152.sybase.com
Lines: 24
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28627
Article PK: 77871

Yog,

I think that newest version of Embarcadero Change manager (5.1.1)
supports cross-dbms data comparison. Also Sybase rep.server has
comparison utility.
Otherwise do bcp out(Sybase) and export in Oracle to text.files and use
diff.

Regards,
Eugene

Yog wrote:
> Situation:
> Sybase database (core application database & source of
> truth) is replicated to Oracle database using Data mirror.
> Both are in production. Application
> programs/interfaces/reports use Oracle for querying (select
> only).
>
> To prove that the data in Oracle is not changed, whats the
> best way to compare Sybase and Oracle.
>
> Thank you
> Yog


Axel Posted on 2009-11-12 20:35:20.0Z
From: "Axel" <tester@tester.cc>
Newsgroups: sybase.public.ase.general
Subject: Re: Data compare Sybase and Oracle
Date: Thu, 12 Nov 2009 12:35:20 -0800
Organization: Netfront http://www.netfront.net
Lines: 24
Message-ID: <hdhrij$a50$1@adenine.netfront.net>
References: <4af467ab.3458.1681692777@sybase.com>
NNTP-Posting-Host: 208.86.39.175
X-Trace: adenine.netfront.net 1258058132 10400 208.86.39.175 (12 Nov 2009 20:35:32 GMT)
X-Complaints-To: news@netfront.net
NNTP-Posting-Date: Thu, 12 Nov 2009 20:35:32 +0000 (UTC)
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.5843
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.5579
X-RFC2646: Format=Flowed; Original
Path: forums-1-dub!forums-master!newssvr.sybase.com!news-sj-1.sprintlink.net!news-peer1.sprintlink.net!nntp1.phx1.gblx.net!nntp.gblx.net!nntp.gblx.net!border2.nntp.dca.giganews.com!nntp.giganews.com!novia!news-out.readnews.com!news-xxxfer.readnews.com!news.glorb.com!news.netfront.net!not-for-mail
Xref: forums-1-dub sybase.public.ase.general:28634
Article PK: 77876

Dump Sybase DB >> load into a temp Oracle DB (while replication is
suspended).

Run MINUS on replicated Oracle DB tables vs temp Oracle DB tables. That
would give you the lowest granularity.
Be careful with multi-million row tables though, since this type of
comparison may be expensive.

<Yog> wrote in message news:4af467ab.3458.1681692777@sybase.com...
> Situation:
> Sybase database (core application database & source of
> truth) is replicated to Oracle database using Data mirror.
> Both are in production. Application
> programs/interfaces/reports use Oracle for querying (select
> only).
>
> To prove that the data in Oracle is not changed, whats the
> best way to compare Sybase and Oracle.
>
> Thank you
> Yog