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.

comparate structure in database?

3 posts in General Discussion Last posting was on 2008-11-29 15:38:17.0Z
ivh Posted on 2008-11-28 15:34:13.0Z
Sender: 3586.49300e8f.1804289383@sybase.com
From: ivh
Newsgroups: ianywhere.public.general
Subject: comparate structure in database?
X-Mailer: WebNews to Mail Gateway v1.1t
Message-ID: <49300f75.359c.1681692777@sybase.com>
NNTP-Posting-Host: 10.22.241.41
X-Original-NNTP-Posting-Host: 10.22.241.41
Date: 28 Nov 2008 07:34:13 -0800
X-Trace: forums-1-dub 1227886453 10.22.241.41 (28 Nov 2008 07:34:13 -0800)
X-Original-Trace: 28 Nov 2008 07:34:13 -0800, 10.22.241.41
Lines: 5
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7244
Article PK: 5461

I all, how can i comparate 2 database in structure, exist
any utility to create this comparation?


thanks all


"Nick Elson [Sybase iAnywhere]" < Posted on 2008-11-28 19:53:27.0Z
From: "Nick Elson [Sybase iAnywhere]" <@nick@.@elson@@sybase@.@com@>
Newsgroups: ianywhere.public.general
References: <49300f75.359c.1681692777@sybase.com>
Subject: Re: comparate structure in database?
Lines: 20
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Message-ID: <49304c37$1@forums-1-dub>
Date: 28 Nov 2008 11:53:27 -0800
X-Trace: forums-1-dub 1227902007 10.22.241.152 (28 Nov 2008 11:53:27 -0800)
X-Original-Trace: 28 Nov 2008 11:53:27 -0800, vip152.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7245
Article PK: 5462

You can try using the dbunload with the -n -r options
to generate the schemas a SQL. Then you can use
you favourite comparison utility (numerous options here
from diff to windiff) to help identify differences. This
helpful if the two database have a common history.

Version 11 added a new switch to the dbunload utility
(-no) to unload objects in name order to help out where
there are different histories involved. That switch was
introduced for just this very purpose.

<ivh> wrote in message news:49300f75.359c.1681692777@sybase.com...
>I all, how can i comparate 2 database in structure, exist
> any utility to create this comparation?
>
>
> thanks all


Breck Carter [TeamSybase] Posted on 2008-11-29 15:38:17.0Z
From: "Breck Carter [TeamSybase]" <NOSPAM__breck.carter@gmail.com>
Newsgroups: ianywhere.public.general
Subject: Re: comparate structure in database?
Organization: RisingRoad Professional Services
Reply-To: NOSPAM__breck.carter@gmail.com
Message-ID: <pdo2j499lmb628hh48bd0q6dj6rrgcude8@4ax.com>
References: <49300f75.359c.1681692777@sybase.com>
X-Newsreader: Forte Agent 2.0/32.640
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: vip152.sybase.com
X-Original-NNTP-Posting-Host: vip152.sybase.com
Date: 29 Nov 2008 07:38:17 -0800
X-Trace: forums-1-dub 1227973097 10.22.241.152 (29 Nov 2008 07:38:17 -0800)
X-Original-Trace: 29 Nov 2008 07:38:17 -0800, vip152.sybase.com
Lines: 17
X-Authenticated-User: TeamSybase
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:7246
Article PK: 5465

In addition to what Nick said, see...

http://sqlanywhere.blogspot.com/2008/08/comparing-database-schemas.html

On 28 Nov 2008 07:34:13 -0800, ivh wrote:

>I all, how can i comparate 2 database in structure, exist
>any utility to create this comparation?
>
>
>thanks all

--
Breck Carter http://sqlanywhere.blogspot.com/

RisingRoad SQL Anywhere and MobiLink Professional Services
breck.carter@risingroad.com