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.

Comparing Text columns in 2 databases

3 posts in Windows NT Last posting was on 1999-12-08 10:23:21.0Z
Marco Otte Posted on 1999-12-07 09:09:44.0Z
From: "Marco Otte" <m.otte@isah.nl>
Subject: Comparing Text columns in 2 databases
Date: Tue, 7 Dec 1999 10:09:44 +0100
Lines: 25
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Message-ID: <1ISwbLJQ$GA.186@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: tb0054-2.dial.wxs.nl 195.121.164.54
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2874
Article PK: 854791

Hi all!

We're here dealing with a development environment where scripts are stored
in text fields.

The problem is that we want to compare the changed scripts in text column in
a table in the developmentdatabase
with the same column in the same table in the 'production' database. And as
a result of this comparison
we want to generate an update statement in order to get both databasecolumns
exactly equal.

We already found the 'hack' to "to break a text field into multiple 255
character fields" (by Bret Halford)
but the other way around (concatenate mutiple 255 character fields to a text
field) is then the problem ...

Anyone any solution??

thanks in advance,

Marco Otte
(Isah B.V)


Jason Froebe Posted on 1999-12-07 17:06:45.0Z
Message-ID: <384D3EA5.F80B31C6@sybase.com>
Date: Tue, 07 Dec 1999 11:06:45 -0600
From: Jason Froebe <jfroebe@sybase.com>
Organization: Sybase, Inc.
X-Mailer: Mozilla 4.7 [en] (X11; I; Linux 2.2.13 i686)
X-Accept-Language: en
MIME-Version: 1.0
To: Marco Otte <m.otte@isah.nl>
Subject: Re: Comparing Text columns in 2 databases
References: <1ISwbLJQ$GA.186@forums.sybase.com>
Content-Type: multipart/mixed; boundary="------------D437A8B8D1FCE5983AFE5769"
Newsgroups: sybase.public.sqlserver.nt
Lines: 43
NNTP-Posting-Host: 157.133.46.52
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2872
Article PK: 1090309


Marco Otte wrote:

> Hi all!
>
> We're here dealing with a development environment where scripts are stored
> in text fields.
>
> The problem is that we want to compare the changed scripts in text column in
> a table in the developmentdatabase
> with the same column in the same table in the 'production' database. And as
> a result of this comparison
> we want to generate an update statement in order to get both databasecolumns
> exactly equal.
>
> We already found the 'hack' to "to break a text field into multiple 255
> character fields" (by Bret Halford)
> but the other way around (concatenate mutiple 255 character fields to a text
> field) is then the problem ...
>
> Anyone any solution??
>
> thanks in advance,
>
> Marco Otte
> (Isah B.V)

>

Hi Marco,

If you are just checking if the two text columns are equal, you could run a
checksum on all the text fields. Store these checksums in a table. You will
now be able to determine if they are equal much faster.

j


Download VCard jfroebe.vcf


Marco Otte Posted on 1999-12-08 10:23:21.0Z
From: "Marco Otte" <m.otte@isah.nl>
References: <1ISwbLJQ$GA.186@forums.sybase.com> <384D3EA5.F80B31C6@sybase.com>
Subject: Re: Comparing Text columns in 2 databases
Date: Wed, 8 Dec 1999 11:23:21 +0100
Lines: 109
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2314.1300
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Message-ID: <gAn7RZWQ$GA.203@forums.sybase.com>
Newsgroups: sybase.public.sqlserver.nt
NNTP-Posting-Host: tb0059-2.dial.wxs.nl 195.121.164.59
Path: forums-1-dub!forums-master.sybase.com!forums.sybase.com
Xref: forums-1-dub sybase.public.sqlserver.nt:2865
Article PK: 1090302

Jason,

Thanks for the response!

I'm not aware of a T-sql function to get a checksum value for a text-column
entry?

Further more, WHEN we find a difference, we want to generate an update
statement in a script that must be run at a customers site production
database ...
So we still need to get out the changed text (preferable without bcp!)

Greetings,

Marco Otte
(Isah b.v.)

Jason Froebe <jfroebe@sybase.com> schreef in nieuwsbericht
<384D3EA5.F80B31C6@sybase.com>:ðÐÁ^ÀÐÁ^~ÐÁ^pÐÁ^`ÐÁ^0ÐÁ^...

> Marco Otte wrote:
>
> > Hi all!
> >
> > We're here dealing with a development environment where scripts are
stored
> > in text fields.
> >
> > The problem is that we want to compare the changed scripts in text
column in
> > a table in the developmentdatabase
> > with the same column in the same table in the 'production' database. And
as
> > a result of this comparison
> > we want to generate an update statement in order to get both
databasecolumns
> > exactly equal.
> >
> > We already found the 'hack' to "to break a text field into multiple 255
> > character fields" (by Bret Halford)
> > but the other way around (concatenate mutiple 255 character fields to a
text
> > field) is then the problem ...
> >
> > Anyone any solution??
> >
> > thanks in advance,
> >
> > Marco Otte
> > (Isah B.V)
>
> >
>
> Hi Marco,
>
> If you are just checking if the two text columns are equal, you could run
a
> checksum on all the text fields. Store these checksums in a table. You
will
> now be able to determine if they are equal much faster.
>
> j
>

Jason Froebe <jfroebe@sybase.com> schreef in berichtnieuws
384D3EA5.F80B31C6@sybase.com...
> Marco Otte wrote:
>
> > Hi all!
> >
> > We're here dealing with a development environment where scripts are
stored
> > in text fields.
> >
> > The problem is that we want to compare the changed scripts in text
column in
> > a table in the developmentdatabase
> > with the same column in the same table in the 'production' database. And
as
> > a result of this comparison
> > we want to generate an update statement in order to get both
databasecolumns
> > exactly equal.
> >
> > We already found the 'hack' to "to break a text field into multiple 255
> > character fields" (by Bret Halford)
> > but the other way around (concatenate mutiple 255 character fields to a
text
> > field) is then the problem ...
> >
> > Anyone any solution??
> >
> > thanks in advance,
> >
> > Marco Otte
> > (Isah B.V)
>
> >
>
> Hi Marco,
>
> If you are just checking if the two text columns are equal, you could run
a
> checksum on all the text fields. Store these checksums in a table. You
will
> now be able to determine if they are equal much faster.
>
> j
>